public int UpdateWorkVsTask(WorkVsTask objWorkVsTask)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"UPDATE WorkVsTask SET WorkDescriptionId = @WorkDescriptionId ,JobCardTaskId = @JobCardTaskId ,CreatedBy = @CreatedBy ,CreatedDate = @CreatedDate OUTPUT INSERTED.WorkVsTaskId WHERE WorkVsTaskId = @WorkVsTaskId";
var id = connection.Execute(sql, objWorkVsTask);
return(id);
}
}
public int InsertWorkVsTask(WorkVsTask objWorkVsTask, IDbConnection connection, IDbTransaction trn)
{
try
{
string sql = @"insert into WorkVsTask(WorkDescriptionId,JobCardTaskMasterId,Hours,CreatedBy,CreatedDate,OrganizationId) Values (@WorkDescriptionId,@JobCardTaskMasterId,@Hours,@CreatedBy,@CreatedDate,@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
var id = connection.Query <int>(sql, objWorkVsTask, trn).Single();
return(id);
}
catch (Exception)
{
throw;
}
}
