public WorkDescription InsertWorkDescription(WorkDescription objWorkDescription) { using (IDbConnection connection = OpenConnection(dataConnection)) { //var result = new WorkDescription(); IDbTransaction trn = connection.BeginTransaction(); string sql = @"insert into WorkDescription(WorkDescriptionRefNo,VehicleModelId,FreezerUnitId,BoxId, WorkDescr,WorkDescrShortName,isNewInstallation,isRepair,isSubAssembly,isProjectBased,CreatedBy,CreatedDate,OrganizationId) Values (@WorkDescriptionRefNo,@VehicleModelId,@FreezerUnitId,@BoxId,@WorkDescr,@WorkDescrShortName,@isNewInstallation, @isRepair,@isSubAssembly,0,@CreatedBy,@CreatedDate,@OrganizationId); SELECT CAST(SCOPE_IDENTITY() as int)"; try { int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(WorkDescription).Name, "0", 1); objWorkDescription.WorkDescriptionRefNo = "WD/" + internalid; var id = connection.Query <int>(sql, objWorkDescription, trn).Single(); var worksitemrepo = new WorkVsItemRepository(); foreach (var item in objWorkDescription.WorkVsItems) { if (item.ItemId == 0 || item.Quantity == 0) { continue; } item.WorkDescriptionId = id; item.CreatedBy = objWorkDescription.CreatedBy; item.CreatedDate = objWorkDescription.CreatedDate; worksitemrepo.InsertWorkVsItem(item, connection, trn); } var workstaskepo = new WorkVsTaskRepository(); foreach (var item in objWorkDescription.WorkVsTasks) { if (item.JobCardTaskMasterId == 0) { continue; } item.WorkDescriptionId = id; item.CreatedBy = objWorkDescription.CreatedBy; item.CreatedDate = objWorkDescription.CreatedDate; workstaskepo.InsertWorkVsTask(item, connection, trn); } objWorkDescription.WorkDescriptionId = id; InsertLoginHistory(dataConnection, objWorkDescription.CreatedBy, "Create", "Work Description", id.ToString(), "0"); trn.Commit(); } catch (Exception ex) { trn.Rollback(); objWorkDescription.WorkDescriptionId = 0; objWorkDescription.WorkDescriptionRefNo = null; } return(objWorkDescription); } }
public WorkDescription GetWorkDescription(int WorkDescriptionId) { using (IDbConnection connection = OpenConnection(dataConnection)) { string sql = @"select * from WorkDescription where WorkDescriptionId=@WorkDescriptionId"; var objWorkDescription = connection.Query <WorkDescription>(sql, new { WorkDescriptionId = WorkDescriptionId }).First <WorkDescription>(); var worksitemrepo = new WorkVsItemRepository(); var workstaskrepo = new WorkVsTaskRepository(); objWorkDescription.WorkVsItems = worksitemrepo.GetWorkDescriptionWorkVsItems(WorkDescriptionId); objWorkDescription.WorkVsTasks = workstaskrepo.GetWorkDescriptionWorkVsTasks(WorkDescriptionId); return(objWorkDescription); } }