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);
}
