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