public int InsertJobCardDailyActivityTask(JobCardDailyActivityTask objJobCardDailyActivityTask) { using (IDbConnection connection = OpenConnection(dataConnection)) { string sql = @"insert into JobCardDailyActivityTask (JobCardDailyActivityId,JobCardTaskId,TaskStartDate,TaskEndDate,ActualHours,CreatedBy,CreatedDate,OrganizationId) Values (@JobCardDailyActivityId,@JobCardTaskId,@TaskStartDate,@TaskEndDate,@ActualHours,@CreatedBy,@CreatedDate,@OrganizationId); SELECT CAST(SCOPE_IDENTITY() as int)"; var id = connection.Query <int>(sql, objJobCardDailyActivityTask).Single(); return(id); } }
private int InsertDailyActivityTasks(JobCardDailyActivityTask item, IDbConnection connection, IDbTransaction txn) { //foreach (var item in model.JobCardDailyActivityTask) //{ if (item.ActualHours == null || item.ActualHours == 0) { return(0); } item.JobCardDailyActivityId = item.JobCardDailyActivityId; item.CreatedDate = DateTime.Now; item.TaskEndDate = item.TaskStartDate; string sql = @"insert into JobCardDailyActivityTask (JobCardDailyActivityId,JobCardTaskId,TaskStartDate,TaskEndDate,OverTime,ActualHours,CreatedBy,CreatedDate,OrganizationId, EmployeeId, StartTime, EndTime) Values (@JobCardDailyActivityId,@JobCardTaskId,@TaskStartDate,@TaskEndDate,@OverTime,@ActualHours,@CreatedBy,@CreatedDate,@OrganizationId, NULLIF(@EmployeeId, 0), @StartTime, @EndTime); SELECT CAST(SCOPE_IDENTITY() as int)"; var taskid = connection.Query <int>(sql, item, txn).Single(); //} return(1); }