private List <CmnuserTeamDetail> InsertionList(vCmnUserTeam model, List <vCmnuserTeamDetail> details, UserCommonEntity commonEntity) { List <CmnuserTeamDetail> list = new List <CmnuserTeamDetail>(); GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF(); Int64 NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamDetailID", "CmnuserTeamDetail"); foreach (vCmnuserTeamDetail Item in details) { CmnuserTeamDetail entity = new CmnuserTeamDetail(); entity.TeamDetailID = NextID++; entity.TeamID = model.TeamID; entity.UserID = Item.UserID; entity.Sequence = Item.Sequence; entity.CompanyID = Item.CompanyID; entity.CreateBy = Item.CreateBy; entity.CreateOn = DateTime.Now; entity.CreatePc = HostService.GetIP(); entity.UpdateBy = Item.UpdateBy; entity.UpdateOn = Item.UpdateOn; entity.UpdatePc = Item.UpdatePc; entity.IsDeleted = Item.IsDeleted; entity.DeleteBy = Item.DeleteBy; entity.DeleteOn = Item.DeleteOn; entity.DeletePc = Item.DeletePc; list.Add(entity); } return(list); }
public int SaveTeam(vCmnUserTeam master, List <vCmnuserTeamDetail> Details, UserCommonEntity commonEntity) { int returnValue = 0; try { GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF(); if (master.EntityMode == "Inserted") { CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity); GenericFactoryEF_CmnUserTeam.Insert(returnModel); GenericFactoryEF_CmnUserTeam.Save(); returnValue = 1; } else if (master.EntityMode == "Updated" && !Details.Any(x => x.EntityMode == "Inserted")) { CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity); GenericFactoryEF_CmnUserTeam.Update(returnModel); GFactory_EF_CmnuserTeamDetail = new CmnuserTeamDetail_EF(); GFactory_EF_CmnuserTeamDetail.UpdateList(this.UpdateDetailsBinding(Details, commonEntity)); GenericFactoryEF_CmnUserTeam.Save(); GFactory_EF_CmnuserTeamDetail.Save(); returnValue = 2; } else { CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity); GenericFactoryEF_CmnUserTeam.Update(returnModel); GFactory_EF_CmnuserTeamDetail = new CmnuserTeamDetail_EF(); GFactory_EF_CmnuserTeamDetail.UpdateList(this.UpdateDetailsBinding(Details.Where(x => x.EntityMode == "Updated").ToList(), commonEntity)); GFactory_EF_CmnuserTeamDetail.InsertList(this.InsertionList(master, Details.Where(x => x.EntityMode == "Inserted").ToList(), commonEntity)); GenericFactoryEF_CmnUserTeam.Save(); GFactory_EF_CmnuserTeamDetail.Save(); returnValue = 2; } } catch (Exception ex) { throw; } return(returnValue); }
public IHttpActionResult DeleteTeam(object[] data) { int result = 0; vCmnUserTeam master = JsonConvert.DeserializeObject <vCmnUserTeam>(data[0].ToString()); UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString()); try { result = objService.DeleteTeam(master, commonEntity); } catch (Exception e) { e.ToString(); result = 0; } return(Json(new { result })); //return _finishGoodes; }
public int DeleteTeam(vCmnUserTeam master, UserCommonEntity commonEntity) { int returnValue = 0; try { GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF(); CmnUserTeam returnModel = GenericFactoryEF_CmnUserTeam.FindBy(x => x.TeamID == master.TeamID).FirstOrDefault(); returnModel.IsDeleted = true; returnModel.DeleteBy = commonEntity.loggedUserID; returnModel.DeleteOn = DateTime.Now; returnModel.DeletePc = HostService.GetIP(); GenericFactoryEF_CmnUserTeam.Update(returnModel); GenericFactoryEF_CmnUserTeam.Save(); returnValue = 3; } catch (Exception) { throw; } return(returnValue); }
private CmnUserTeam InsertionModelBinding(vCmnUserTeam model, List <vCmnuserTeamDetail> details, UserCommonEntity commonEntity) { GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF(); try { Int64 NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamID", "CmnUserTeam"); CmnUserTeam returnModel = new CmnUserTeam(); returnModel.TeamID = model.TeamID == 0 ? NextID : model.TeamID; returnModel.TeamName = model.TeamName; returnModel.DepartmentID = model.DepartmentID; returnModel.CompanyID = model.CompanyID; if (model.EntityMode == "Inserted") { returnModel.CreateBy = commonEntity.loggedUserID; returnModel.CreateOn = DateTime.Now; returnModel.CreatePc = HostService.GetIP(); } else { returnModel.UpdateBy = commonEntity.loggedUserID; returnModel.UpdateOn = DateTime.Now; returnModel.UpdatePc = HostService.GetIP(); } returnModel.IsDeleted = model.IsDeleted; if (returnModel.IsDeleted == true) { returnModel.DeleteBy = commonEntity.loggedUserID; returnModel.DeleteOn = DateTime.Now; returnModel.DeletePc = HostService.GetIP(); } NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamDetailID", "CmnuserTeamDetail"); foreach (vCmnuserTeamDetail Item in details) { CmnuserTeamDetail entity = new CmnuserTeamDetail(); entity.TeamDetailID = NextID++; if (Item.EntityMode != "Inserted") { entity.TeamDetailID = Item.TeamDetailID; } entity.TeamID = returnModel.TeamID; entity.UserID = Item.UserID; entity.Sequence = Item.Sequence; entity.CompanyID = Item.CompanyID; entity.CreateBy = Item.CreateBy; entity.CreateOn = DateTime.Now; entity.CreatePc = HostService.GetIP(); entity.UpdateBy = Item.UpdateBy; entity.UpdateOn = Item.UpdateOn; entity.UpdatePc = Item.UpdatePc; entity.IsDeleted = Item.IsDeleted; entity.DeleteBy = Item.DeleteBy; entity.DeleteOn = Item.DeleteOn; entity.DeletePc = Item.DeletePc; returnModel.CmnuserTeamDetails.Add(entity); } return(returnModel); } catch (Exception ex) { ex.Message.ToString(); throw; } }