public SysBuyerAgent SetToBussinessObject(Sys_BuyerAgent Entity) { SysBuyerAgent Model = new SysBuyerAgent(); Model.BuyerAgentID = Entity.BuyerAgentID; Model.AgentID = Entity.AgentID; Model.BuyerID = Entity.BuyerID; Model.BuyerName = _context.Sys_Buyer.Where(m => m.BuyerID == Entity.AgentID).FirstOrDefault().BuyerName; Model.AgentType = Entity.AgentType; Model.IsActive = Entity.IsActive == true ? "Active" : "Inactive"; return(Model); }
public Sys_BuyerAgent SetToModelObject(SysBuyerAgent model) { Sys_BuyerAgent Entity = new Sys_BuyerAgent(); Entity.BuyerAgentID = model.BuyerAgentID; Entity.AgentID = model.AgentID; Entity.BuyerID = model.BuyerID; Entity.AgentType = model.AgentType; Entity.IsActive = model.IsActive == "Active"; Entity.SetOn = DateTime.Now; Entity.SetBy = model.SetBy; Entity.IPAddress = string.Empty; return(Entity); }
public ValidationMsg Save(SysBuyer model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { var exitBuyerCode = _context.Sys_Buyer.Where(m => m.BuyerCode == model.BuyerCode).ToList(); if (exitBuyerCode.Count > 0) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Buyer Code Already Exit."; } else { #region Buyer model.SetBy = userid; Sys_Buyer tblSysBuyer = SetToModelObject(model); _context.Sys_Buyer.Add(tblSysBuyer); _context.SaveChanges(); BuyerID = tblSysBuyer.BuyerID; #endregion #region Save Buyer Address if (model.BuyerAddressList != null) { if (model.BuyerAddressList.Count > 1) { buyeraddress = 1; } else { foreach (SysBuyerAddress objSysBuyerAddress in model.BuyerAddressList) { objSysBuyerAddress.BuyerID = BuyerID; objSysBuyerAddress.SetBy = userid; objSysBuyerAddress.IsActive = string.IsNullOrEmpty(objSysBuyerAddress.IsActive) ? "Active" : objSysBuyerAddress.IsActive; Sys_BuyerAddress tblBuyerAddress = SetToModelObject(objSysBuyerAddress); _context.Sys_BuyerAddress.Add(tblBuyerAddress); } #region Save Buyer Agent if (model.BuyerAgentList != null) { foreach (SysBuyerAgent objBuyerAgent in model.BuyerAgentList) { if (objBuyerAgent.BuyerID != 0) { if (objBuyerAgent.AgentType == "Local Agent") { ++localAgent; } else if (objBuyerAgent.AgentType == "Foreign Agent") { ++foreignAgent; } if (localAgent == 1 || foreignAgent == 1) { objBuyerAgent.BuyerAgentID = BuyerID; objBuyerAgent.BuyerID = BuyerID; objBuyerAgent.SetBy = userid; objBuyerAgent.IsActive = string.IsNullOrEmpty(objBuyerAgent.IsActive) ? "Active" : objBuyerAgent.IsActive; Sys_BuyerAgent tblSysBuyerAgent = SetToModelObject(objBuyerAgent); _context.Sys_BuyerAgent.Add(tblSysBuyerAgent); } } } } #endregion #region Transaction if (buyeraddress == 1) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Please Enter only one Active Buyer Address."; } if (localAgent > 1 || foreignAgent > 1) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Please Enter Same Agent Type Only Once."; } if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 1) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 1) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 0) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 0) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } #endregion } } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Please Enter Buyer Address."; } #endregion } } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public ValidationMsg Update(SysBuyer model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { Sys_Buyer CurrentEntity = SetToModelObject(model); var OriginalEntity = _context.Sys_Buyer.First(m => m.BuyerID == model.BuyerID); OriginalEntity.BuyerID = CurrentEntity.BuyerID; OriginalEntity.BuyerCode = CurrentEntity.BuyerCode; OriginalEntity.BuyerName = CurrentEntity.BuyerName; OriginalEntity.BuyerCategory = CurrentEntity.BuyerCategory; OriginalEntity.BuyerType = CurrentEntity.BuyerType; OriginalEntity.IsActive = CurrentEntity.IsActive; OriginalEntity.ModifiedBy = userid; OriginalEntity.ModifiedOn = DateTime.Now; //#region Save Buyer Address //if (model.BuyerAddressList != null) //{ // foreach (SysBuyerAddress objbuyerAddress in model.BuyerAddressList) // { // if (objbuyerAddress.BuyerAddressID == 0) // { // var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList(); // if (exitData.Count > 0) // { // buyeraddress = 1; // } // else // { // objbuyerAddress.BuyerID = model.BuyerID; // objbuyerAddress.SetBy = userid; // objbuyerAddress.IsActive = string.IsNullOrEmpty(objbuyerAddress.IsActive) ? "Active" : objbuyerAddress.IsActive; // Sys_BuyerAddress tblPurchaseYearPeriod = // SetToModelObject(objbuyerAddress); // _context.Sys_BuyerAddress.Add(tblPurchaseYearPeriod); // _context.SaveChanges(); // } // } // else // { // if (objbuyerAddress.IsActive == "Inactive") // { // Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress); // var OrgEntity = // _context.Sys_BuyerAddress.First( // m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID); // OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID; // OrgEntity.BuyerID = CurEntity.BuyerID; // OrgEntity.Address = CurEntity.Address; // OrgEntity.ContactPerson = CurEntity.ContactPerson; // OrgEntity.ContactNumber = CurEntity.ContactNumber; // OrgEntity.EmailAddress = CurEntity.EmailAddress; // OrgEntity.FaxNo = CurEntity.FaxNo; // OrgEntity.PhoneNo = CurEntity.PhoneNo; // OrgEntity.SkypeID = CurEntity.SkypeID; // OrgEntity.IsActive = CurEntity.IsActive; // OrgEntity.ModifiedBy = userid; // OrgEntity.ModifiedOn = DateTime.Now; // } // else // { // var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList(); // if (exitData.Count > 0) // { // buyeraddress = 1; // } // else // { // Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress); // var OrgEntity = // _context.Sys_BuyerAddress.First( // m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID); // OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID; // OrgEntity.BuyerID = CurEntity.BuyerID; // OrgEntity.Address = CurEntity.Address; // OrgEntity.ContactPerson = CurEntity.ContactPerson; // OrgEntity.ContactNumber = CurEntity.ContactNumber; // OrgEntity.EmailAddress = CurEntity.EmailAddress; // OrgEntity.FaxNo = CurEntity.FaxNo; // OrgEntity.PhoneNo = CurEntity.PhoneNo; // OrgEntity.SkypeID = CurEntity.SkypeID; // OrgEntity.IsActive = CurEntity.IsActive; // OrgEntity.ModifiedBy = userid; // OrgEntity.ModifiedOn = DateTime.Now; // } // } // } // } //} //#endregion #region Save Buyer Address if (model.BuyerAddressList != null) { foreach (SysBuyerAddress objbuyerAddress in model.BuyerAddressList) { if (objbuyerAddress.BuyerAddressID == 0) { var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList(); if (exitData.Count > 0) { buyeraddress = 1; } else { objbuyerAddress.BuyerID = model.BuyerID; objbuyerAddress.SetBy = userid; objbuyerAddress.IsActive = string.IsNullOrEmpty(objbuyerAddress.IsActive) ? "Active" : objbuyerAddress.IsActive; Sys_BuyerAddress tblPurchaseYearPeriod = SetToModelObject(objbuyerAddress); _context.Sys_BuyerAddress.Add(tblPurchaseYearPeriod); _context.SaveChanges(); } } else { if (objbuyerAddress.IsActive == "Inactive") { Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress); var OrgEntity = _context.Sys_BuyerAddress.First(m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID); OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID; OrgEntity.BuyerID = CurEntity.BuyerID; OrgEntity.Address = CurEntity.Address; OrgEntity.ContactPerson = CurEntity.ContactPerson; OrgEntity.ContactNumber = CurEntity.ContactNumber; OrgEntity.EmailAddress = CurEntity.EmailAddress; OrgEntity.FaxNo = CurEntity.FaxNo; OrgEntity.PhoneNo = CurEntity.PhoneNo; OrgEntity.SkypeID = CurEntity.SkypeID; OrgEntity.IsActive = CurEntity.IsActive; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } else { var exitData = _context.Sys_BuyerAddress.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true).ToList(); if ((exitData.Count > 0) && (model.BuyerAddressList.Count > 1)) //if (exitData.Count > 0) { buyeraddress = 1; } else { Sys_BuyerAddress CurEntity = SetToModelObject(objbuyerAddress); var OrgEntity = _context.Sys_BuyerAddress.First(m => m.BuyerAddressID == objbuyerAddress.BuyerAddressID); OrgEntity.BuyerAddressID = CurEntity.BuyerAddressID; OrgEntity.BuyerID = CurEntity.BuyerID; OrgEntity.Address = CurEntity.Address; OrgEntity.ContactPerson = CurEntity.ContactPerson; OrgEntity.ContactNumber = CurEntity.ContactNumber; OrgEntity.EmailAddress = CurEntity.EmailAddress; OrgEntity.FaxNo = CurEntity.FaxNo; OrgEntity.PhoneNo = CurEntity.PhoneNo; OrgEntity.SkypeID = CurEntity.SkypeID; OrgEntity.IsActive = CurEntity.IsActive; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } } } } } #endregion #region Save Buyer Agent if (model.BuyerAgentList != null) { foreach (SysBuyerAgent objBuyerAgent in model.BuyerAgentList) { if (objBuyerAgent.BuyerAgentID == 0) { if (objBuyerAgent.BuyerID != 0) { if (objBuyerAgent.AgentType == "Local Agent") { ++localAgent; var exitData = _context.Sys_BuyerAgent.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true && m.AgentType == "Local Agent").ToList(); if (exitData.Count > 0) { ++localAgent; } } else if (objBuyerAgent.AgentType == "Foreign Agent") { ++foreignAgent; var exitData = _context.Sys_BuyerAgent.Where(m => m.BuyerID == model.BuyerID && m.IsActive == true && m.AgentType == "Foreign Agent").ToList(); if (exitData.Count > 0) { ++foreignAgent; } } if (localAgent == 1 || foreignAgent == 1) { objBuyerAgent.BuyerID = model.BuyerID; objBuyerAgent.SetBy = userid; objBuyerAgent.IsActive = string.IsNullOrEmpty(objBuyerAgent.IsActive) ? "Active" : objBuyerAgent.IsActive; Sys_BuyerAgent tblSysBuyerAgent = SetToModelObject(objBuyerAgent); _context.Sys_BuyerAgent.Add(tblSysBuyerAgent); } } } else { if (objBuyerAgent.AgentType == "Local Agent") { ++localAgent; } else if (objBuyerAgent.AgentType == "Foreign Agent") { ++foreignAgent; } if (localAgent == 1 || foreignAgent == 1) { Sys_BuyerAgent CurEntity = SetToModelObject(objBuyerAgent); var OrgEntity = _context.Sys_BuyerAgent.First( m => m.BuyerAgentID == objBuyerAgent.BuyerAgentID); OrgEntity.BuyerAgentID = CurEntity.BuyerAgentID; OrgEntity.AgentID = CurEntity.AgentID; OrgEntity.BuyerID = CurEntity.BuyerID; OrgEntity.AgentType = CurEntity.AgentType; OrgEntity.IsActive = CurEntity.IsActive; OrgEntity.ModifiedBy = userid; OrgEntity.ModifiedOn = DateTime.Now; } } } } #endregion if (buyeraddress == 1) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Please Enter only one Active Buyer Address."; } if (localAgent > 1 || foreignAgent > 1) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Please Enter Same Agent Type Only Once."; } if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 1) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 1) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } if (buyeraddress == 0 && localAgent == 1 && foreignAgent == 0) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } if (buyeraddress == 0 && localAgent == 0 && foreignAgent == 0) { _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } } } catch (Exception ex) { if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Buyer Code Already Exit.."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } } return(_vmMsg); }