API tools faq
paste
Guest User

Untitled

a guest
Feb 17th, 2019
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.30 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE [dbo].[tblTask] (
  2. [TaskId] NUMERIC (18) IDENTITY (1, 1) NOT NULL,
  3. [ClientId] INT NULL,
  4. [UserName] VARCHAR (50) NULL,
  5. [Task] VARCHAR (MAX) NULL,
  6. [EmpId] INT NULL,
  7. [AssignedDate] DATETIME2 (7) NULL,
  8. [DueDate] DATETIME2 (7) NULL,
  9. [CompletionDate] DATETIME2 (7) NULL,
  10. [EstTime] FLOAT (53) NULL,
  11. [ActualTime] VARCHAR (50) NULL,
  12. [Status] VARCHAR (50) NULL,
  13. [Priority] VARCHAR (50) NULL,
  14. [Remarks] VARCHAR (8000) NULL,
  15. [TechnicalRemarks1] VARCHAR (8000) NULL,
  16. [TechnicalRemarks2] VARCHAR (8000) NULL,
  17. [TechnicalRemarks3] VARCHAR (8000) NULL,
  18. [TaskPercentage] NUMERIC (18, 2) NULL,
  19. [StartTime] DATETIME2 (7) NULL,
  20. [Tno] INT NOT NULL,
  21. [DeliverToday] BIT NULL,
  22. [dt_Status] BIT NULL,
  23. [UpdateStatusNO] INT CONSTRAINT [DF__tblTask__UpdateS__5070F446] DEFAULT ((0)) NULL,
  24. [patchStatus] INT NULL,
  25. [SupportFile] VARCHAR (MAX) NULL,
  26. [Codecommit] INT NULL,
  27. [Tremark1file] VARCHAR (MAX) NULL,
  28. [Tremark2file] VARCHAR (MAX) NULL,
  29. [remarkfile] VARCHAR (MAX) NULL,
  30. [Taskfile] VARCHAR (MAX) NULL,
  31. [Moduleid] INT NULL,
  32. [StatusDate] DATETIME2 (7) NULL,
  33. [ParentID] INT NULL,
  34. [TaskTypeid] INT NULL,
  35. [Projectid] INT NULL,
  36. [SubTaskTypeid] INT NULL,
  37. [Ptaskid] INT NULL,
  38. [DepartmentID] INT NULL,
  39. [SuggesionRemarks] VARCHAR (8000) NULL,
  40. [DevHours] FLOAT (53) NULL,
  41. [Start] INT NULL,
  42. [IsStartDate] INT NULL,
  43. [ReleaseID] NVARCHAR (MAX) NOT NULL,
  44. [Bug] INT NULL,
  45. [Suggestions] INT NULL,
  46. [Approved] INT NULL,
  47. [Movement] INT NULL,
  48. [QAHrs] NUMERIC (18) NULL,
  49. [MiscHrs] NUMERIC (18) NULL,
  50. [summary] VARCHAR (500) NULL,
  51. [Email] VARCHAR (500) NULL,
  52. [LocalClientDetails] VARCHAR (500) NULL,
  53. CONSTRAINT [PK_tblTask] PRIMARY KEY CLUSTERED ([Tno] ASC)
  54.  
  55. if Update(Status) or Update(EmpID)
  56. begin
  57. insert into tblTaskLog (TaskId,ClientId,UserName,Task,EmpIdFrom,EmpIdTo,AssignedDate,DueDate,EstTime,StatusFrom,StatusTo,SystemName,CreationDate)
  58. select D.TaskId,D.ClientId,D.UserName,D.Task,D.EmpId,I.EmpId,D.AssignedDate,D.DueDate,D.EstTime,D.Status,i.Status,Host_Name(),Getdate()
  59. From Deleted D inner join Inserted I on D.TaskId=I.TaskId
  60. Where D.Status<>I.Status or D.EmpID<>I.EmpID
  61. ------------------------------------------------------
  62.  
  63. ---------------------Status Change---------------------
  64. if Update(Status)
  65. begin
  66. Declare @OldStatus varchar(200)
  67. Declare @NewStatus varchar(200)
  68. select @NewStatus=Status from inserted
  69. select @OldStatus=Status from deleted
  70. --select @NewStatus NewStatus,@OldStatus OldStatus
  71. --if((Select status from inserted)<>(select Status from deleted))
  72. if @NewStatus <> @OldStatus
  73. begin
  74.  
  75. Update tbltask set Statusdate=Getdate() where taskid=(Select Taskid from inserted)
  76. end
  77.  
  78. end
  79. --------------------------------------------------------------
  80.  
  81. End
  82.  
  83. [Table("tblTask")]
  84. public class TaskMainDTO
  85. {
  86. public int? ClientId { get; set; }
  87. public string Username { get; set; }
  88. public string Task { get; set; }
  89. public int? EmpId { get; set; }
  90. public DateTime? AssignedDate { get; set; }
  91. public DateTime? DueDate { get; set; }
  92. public DateTime? CompletionDate { get; set; }
  93. public double? EstTime { get; set; }
  94. public string ActualTime { get; set; }
  95. public string Status { get; set; }
  96. public string Priority { get; set; }
  97. public string Remarks { get; set; }
  98. public string TechnicalRemarks1 { get; set; }
  99. public string TechnicalRemarks2 { get; set; }
  100. public string TechnicalRemarks3 { get; set; }
  101. public decimal? TaskPercentage { get; set; }
  102. public DateTime? StartTime { get; set; }
  103. [Key]
  104. public int Tno { get; set; }
  105. public bool? DeliverToday { get; set; }
  106. public bool? dt_Status { get; set; }
  107. public int? UpdateStatusNo { get; set; }
  108. public int? patchStatus { get; set; }
  109. public string SupportFile { get; set; }
  110. public int? Codecommit { get; set; }
  111. public string Tremark1file { get; set; }
  112. public string Tremark2file { get; set; }
  113. public string remarkfile { get; set; }
  114. public string Taskfile { get; set; }
  115. public int? Moduleid { get; set; }
  116. public DateTime StatusDate { get; set; }
  117. public int? ParentID { get; set; }
  118. public int? TaskTypeid { get; set; }
  119. public int? Projectid { get; set; }
  120. public int? SubTaskTypeid { get; set; }
  121. public int? Ptaskid { get; set; }
  122. public int? DepartmentID { get; set; }
  123. public string SuggesionRemarks { get; set; }
  124. public double? DevHours { get; set; }
  125. public int? Start { get; set; }
  126. public int? IsStartDate { get; set; }
  127. public string ReleaseID { get; set; }
  128. public int? Bug { get; set; }
  129. public int? Suggestions { get; set; }
  130. public int? Approved { get; set; }
  131. public int? Movement { get; set; }
  132. public decimal? QAHrs { get; set; }
  133. public decimal? MiscHrs { get; set; }
  134. public string summary { get; set; }
  135. public string Email { get; set; }
  136. public string LocalClientDetails { get; set; }
  137.  
  138. public class TaskMainVM
  139. {
  140. public TaskMainVM()
  141. {
  142.  
  143. }
  144. public TaskMainVM(TaskMainDTO model)
  145. {
  146. ClientId = model.ClientId;
  147. Projectid = model.Projectid;
  148. Moduleid = model.Moduleid;
  149. TaskTypeid = model.TaskTypeid;
  150. SubTaskTypeid = model.SubTaskTypeid;
  151. EmpId = model.EmpId;
  152. DepartmentID = model.DepartmentID;
  153. Username = model.Username;
  154. Status = model.Status;
  155. Priority = model.Priority;
  156. ReleaseID = model.ReleaseID;
  157. AssignedDate = model.AssignedDate;
  158. DueDate = model.DueDate;
  159. CompletionDate = model.CompletionDate;
  160. StartTime = model.StartTime;
  161. ActualTime = model.ActualTime;
  162. DevHours = model.DevHours;
  163. QAHrs = model.QAHrs;
  164. MiscHrs = model.MiscHrs;
  165. Tno = model.Tno;
  166. summary = model.summary;
  167. Task = model.Task;
  168. Taskfile = model.Taskfile;
  169. LocalClientDetails = model.LocalClientDetails;
  170. Email = model.Email;
  171.  
  172. }
  173.  
  174. public int? ClientId { get; set; }
  175. public string Username { get; set; }
  176. public string Task { get; set; }
  177. public int? EmpId { get; set; }
  178. public DateTime? AssignedDate { get; set; }
  179. public DateTime? DueDate { get; set; }
  180. public DateTime? CompletionDate { get; set; }
  181. public double? EstTime { get; set; }
  182. public string ActualTime { get; set; }
  183. public string Status { get; set; }
  184. public string Priority { get; set; }
  185. public string Remarks { get; set; }
  186. public string TechnicalRemarks1 { get; set; }
  187. public string TechnicalRemarks2 { get; set; }
  188. public string TechnicalRemarks3 { get; set; }
  189. public decimal? TaskPercentage { get; set; }
  190. public DateTime? StartTime { get; set; }
  191.  
  192. public int Tno { get; set; }
  193. public bool? DeliverToday { get; set; }
  194. public bool? dt_Status { get; set; }
  195. public int? UpdateStatusNo { get; set; }
  196. public int? patchStatus { get; set; }
  197. public string SupportFile { get; set; }
  198. public int? Codecommit { get; set; }
  199. public string Tremark1file { get; set; }
  200. public string Tremark2file { get; set; }
  201. public string remarkfile { get; set; }
  202. public string Taskfile { get; set; }
  203. public int? Moduleid { get; set; }
  204. public DateTime StatusDate { get; set; }
  205. public int? ParentID { get; set; }
  206. public int? TaskTypeid { get; set; }
  207. public int? Projectid { get; set; }
  208. public int? SubTaskTypeid { get; set; }
  209. public int? Ptaskid { get; set; }
  210. public int? DepartmentID { get; set; }
  211. public string SuggesionRemarks { get; set; }
  212. public double? DevHours { get; set; }
  213. public int? Start { get; set; }
  214. public int? IsStartDate { get; set; }
  215. public string ReleaseID { get; set; }
  216. public int? Bug { get; set; }
  217. public int? Suggestions { get; set; }
  218. public int? Approved { get; set; }
  219. public int? Movement { get; set; }
  220. public decimal? QAHrs { get; set; }
  221. public decimal? MiscHrs { get; set; }
  222. public string summary { get; set; }
  223. public string Email { get; set; }
  224. public string LocalClientDetails { get; set; }
  225.  
  226. // save task data
  227. public JsonResult SaveTaskDataInDb(TaskMainVM model)
  228. {
  229. var result = false;
  230. try
  231. {
  232. using (Db db = new Db())
  233. {
  234. TaskMainDTO dto = new TaskMainDTO();
  235.  
  236. dto.ClientId = model.ClientId;
  237. dto.Projectid = model.Projectid;
  238. dto.Moduleid = model.Moduleid;
  239. dto.TaskTypeid = model.TaskTypeid;
  240. dto.SubTaskTypeid = model.SubTaskTypeid;
  241. dto.EmpId = model.EmpId;
  242. dto.DepartmentID = model.DepartmentID;
  243. dto.Username = model.Username;
  244. dto.Status = model.Status;
  245. dto.Priority = model.Priority;
  246. dto.ReleaseID = model.ReleaseID;
  247. dto.AssignedDate = model.AssignedDate;
  248. dto.DueDate = model.DueDate;
  249. dto.CompletionDate = model.CompletionDate;
  250. dto.StartTime = model.StartTime;
  251. dto.ActualTime = model.ActualTime;
  252. dto.DevHours = model.DevHours;
  253. dto.QAHrs = model.QAHrs;
  254. dto.MiscHrs = model.MiscHrs;
  255. dto.Tno = 78999;
  256. dto.summary = model.summary;
  257. dto.Task = model.Task;
  258. dto.Taskfile = model.Taskfile;
  259. dto.LocalClientDetails = model.LocalClientDetails;
  260. dto.Email = model.Email;
  261.  
  262.  
  263. db.TaskMain.Add(dto);
  264. db.SaveChanges();
  265. result = true;
  266.  
  267.  
  268. }
  269.  
  270.  
  271. }
  272. catch (Exception ex)
  273. {
  274. throw ex;
  275. }
  276. return Json(result, JsonRequestBehavior.AllowGet);
  277.  
  278. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!