public void DeleteSaleAccount(int?user, int?OrgId, int?CompanyId, int Code) { try { string strMessage = ""; bool _success = false; var SaleAccount = dbUser.GetAgentById(Code); dbUser.DeleteSalesAccount(SaleAccount); SMSA_Logs_HI log = new SMSA_Logs_HI(); util.IsSpecifed <SMSA_Logs_HI>(log); log.ActivityBy = user.Value; log.ActivityDesc = "Delete Agent/SubAgent"; log.ActivityOn = DateTime.Now; log.ActivityType = "D"; log.ColumnId = Code; dbUser.AddActivityLog(log); strMessage = "Record successfully deleted."; _success = true; } catch (Exception ex) { Log.LogWrite(ex.Message, "Sale Account Delete", ex); } }
public void AddActivityLog(SMSA_Logs_HI log) { try { db.Configuration.ProxyCreationEnabled = false; db.SMSA_Logs_HI.Add(log); db.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void AddActivityLog(SMSA_Logs_HI log) { try { dbUser.Timeout = System.Threading.Timeout.Infinite; dbUser.AddActivityLog(log); dbUser.Dispose(); dbUser.Abort(); } catch (Exception ex) { dbUser.Dispose(); dbUser.Abort(); throw ex; } }
public ActionResult SaleAccount(int?user, int?OrgId, int?CompanyId, SRCC_SalesAccount_ST SAC) { try { string strMessage = ""; bool _success = true; if (SAC.AccountType == "S" && SAC.ParentSaleId == 0) { return(Json(new { success = false, response = "Please select parent agent." })); } if (SAC.AccountType == "A") { SAC.ParentSaleId = null; } if (SAC.SaleAccId > 0) { util.IsSpecifed <SRCC_SalesAccount_ST>(SAC); dbUser.UpdateSalesAccount(SAC); SMSA_Logs_HI log = new SMSA_Logs_HI(); util.IsSpecifed <SMSA_Logs_HI>(log); log.ActivityBy = user.Value; log.ActivityDesc = "Edit Agent/SubAgent"; log.ActivityOn = DateTime.Now; log.ActivityType = "U"; log.ColumnId = SAC.SaleAccId; dbUser.AddActivityLog(log); strMessage = "Record successfully updated."; _success = true; } else { // string password = new Utility().GetUniqueKey(8); // Membership.CreateUser(SaleAccount.UserName, password); SAC.CreatedBy = user; SAC.CreatedOn = DateTime.Now; util.IsSpecifed <SRCC_SalesAccount_ST>(SAC); int maxValue = dbUser.InsertSalesAccount(SAC); SAC.SaleAccId = maxValue; if (maxValue > 0) { SMSA_Logs_HI log = new SMSA_Logs_HI(); util.IsSpecifed <SMSA_Logs_HI>(log); log.ActivityBy = user.Value; log.ActivityDesc = "Add New Agent/SubAgent"; log.ActivityOn = DateTime.Now; log.ActivityType = "I"; log.ColumnId = SAC.SaleAccId; dbUser.AddActivityLog(log); strMessage = "Record successfully saved."; _success = true; } else { strMessage = "Application server error."; } } return(Json(new { success = _success, response = strMessage })); } catch (Exception ex) { Log.LogWrite(ex.Message, "Sale Account Insert/Edit", ex); return(Json(new { success = false, response = ex.Message.ToString() })); } }
public ActionResult Company(int?user, int?OrgId, int?CompanyId, CompanyDetail tt) { try { if (tt.CompanyID > 0) { SMSA_CompanyMst_ST Comp = dbUser.GetCompanyById(tt.CompanyID); #region Organization for each company if (tt.POrgId.HasValue && tt.POrgId > 0) { #region Organization SMSA_Organization_ST reqCompOrg = dbUser.GetOrganizationById(tt.OrgID); reqCompOrg.OrgType = tt.OrgType; reqCompOrg.SaleAccId = tt.SaleAccId; reqCompOrg.SaleAccIdSpecified = true; reqCompOrg.Description = reqCompOrg.UserName == "Org" + Comp.UserName ? tt.CompanyName : reqCompOrg.Description; dbUser.UpdateOrganization(reqCompOrg); Comp.OrgID = tt.POrgId.Value; Comp.OrgIDSpecified = true; #endregion } else { var lstOrg = dbUser.GetAllOrganization(); var reqOrgDefault = lstOrg.Where(x => x.UserName == "Org" + tt.UserName).FirstOrDefault(); if (reqOrgDefault != null) { #region Organization SMSA_Organization_ST reqCompOrg = dbUser.GetOrganizationById(reqOrgDefault.OrgID); reqCompOrg.OrgType = tt.OrgType; reqCompOrg.SaleAccId = tt.SaleAccId; reqCompOrg.SaleAccIdSpecified = true; reqCompOrg.Description = reqCompOrg.UserName == "Org" + Comp.UserName ? tt.CompanyName : reqCompOrg.Description; dbUser.UpdateOrganization(reqCompOrg); Comp.OrgID = reqOrgDefault.OrgID; Comp.OrgIDSpecified = true; #endregion } else { SMSA_Organization_ST org = new WPSService.SMSA_Organization_ST(); org.OrgType = tt.OrgType; org.SaleAccId = tt.SubAgentId > 0 ? tt.SubAgentId : tt.AgentId > 0 ? tt.AgentId : org.SaleAccId; org.SaleAccIdSpecified = true; org.Status = "A"; org.UserName = "******" + tt.UserName; org.CreatedBy = user; org.CreatedBySpecified = true; org.CreatedOn = DateTime.Now; org.CreatedOnSpecified = true; org.Description = tt.CompanyName; tt.POrgId = dbUser.InsertOrganization(org); Comp.OrgID = tt.POrgId.Value; Comp.OrgIDSpecified = true; if (Membership.GetUser(org.UserName) == null) { MembershipCreateStatus status; // Generate a new 12-character password with 1 non-alphanumeric character. //y0t(9ci&xUn^ string password = org.UserName + "123"; // utility.GetUniqueKey(8);//Membership.GeneratePassword(8, 0); // string password = "******"; MembershipUser newUser = Membership.CreateUser(org.UserName, password, org.UserName, "ok", "ok", true, out status); UserServiceClass.SMIM_UserMst_ST User = new UserServiceClass.SMIM_UserMst_ST(); User.UserId = 0; User.UserName = org.UserName; User.Email = tt.Email; User.FirstName = tt.ContactPerson; User.OrgId = tt.POrgId.Value; utility.IsSpecifed <UserServiceClass.SMIM_UserMst_ST>(User); int maxValue = db.InsertUser(User); } } } #endregion #region Company Comp.SMSA_Organization_ST = null; Comp.Address = tt.Address; Comp.CompanyName = tt.CompanyName; Comp.ContactPerson = tt.ContactPerson; Comp.Email = tt.Email; Comp.EstID = tt.EstID; Comp.IsActive = "Y"; Comp.IsApproved = "Y"; Comp.logoPath = tt.logoPath; Comp.Mobile = tt.Mobile; Comp.Phone = tt.Phone; Comp.SaleAccIdSpecified = true; if (tt.SubAgentId > 0) { Comp.SaleAccId = tt.SubAgentId; } else if (tt.AgentId > 0) { Comp.SaleAccId = tt.AgentId; } else { Comp.SaleAccId = null; } Comp.ModifyBy = user; Comp.ModifyBySpecified = true; Comp.ModifyOn = DateTime.Now; Comp.ModifyOnSpecified = true; dbUser.UpdateCompany(Comp); #endregion #region Activity Log SMSA_Logs_HI log = new SMSA_Logs_HI(); utility.IsSpecifed <SMSA_Logs_HI>(log); log.ActivityBy = user.Value; log.ActivityDesc = "Edit Company Details"; log.ActivityOn = DateTime.Now; log.ActivityType = "U"; log.ColumnId = tt.CompanyID; dbUser.AddActivityLog(log); #endregion //#region Organization //SMSA_Organization_ST reqOrg = dbUser.GetOrganizationById(tt.OrgID); //reqOrg.OrgType = tt.OrgType; //reqOrg.SaleAccId = tt.SaleAccId; //reqOrg.SaleAccIdSpecified = true; //reqOrg.Description = reqOrg.UserName == "Org" + Comp.UserName ? tt.CompanyName : reqOrg.Description; //dbUser.UpdateOrganization(reqOrg); //#endregion return(Json(new { success = true, response = "Company updated successfully." })); } else { #region Organization for each company if (tt.POrgId.HasValue && tt.POrgId > 0) { /*Organization laready defined and this company is part of group of companies*/ } else { SMSA_Organization_ST org = new WPSService.SMSA_Organization_ST(); org.OrgType = tt.OrgType; org.SaleAccId = tt.SubAgentId > 0 ? tt.SubAgentId : tt.AgentId > 0 ? tt.AgentId : org.SaleAccId; org.SaleAccIdSpecified = true; org.Status = "A"; org.UserName = "******" + tt.UserName; org.CreatedBy = user; org.CreatedBySpecified = true; org.CreatedOn = DateTime.Now; org.CreatedOnSpecified = true; org.Description = tt.CompanyName; tt.POrgId = dbUser.InsertOrganization(org); if (Membership.GetUser(org.UserName) == null) { MembershipCreateStatus status; // Generate a new 12-character password with 1 non-alphanumeric character. //y0t(9ci&xUn^ string password = org.UserName + "123"; //utility.GetUniqueKey(8);//Membership.GeneratePassword(8, 0); // string password = "******"; MembershipUser newUser = Membership.CreateUser(org.UserName, password, org.UserName, "ok", "ok", true, out status); UserServiceClass.SMIM_UserMst_ST User = new UserServiceClass.SMIM_UserMst_ST(); User.UserId = 0; User.UserName = org.UserName; User.Email = tt.Email; User.FirstName = tt.ContactPerson; User.OrgId = tt.POrgId.Value; utility.IsSpecifed <UserServiceClass.SMIM_UserMst_ST>(User); int maxValue = db.InsertUser(User); } } #endregion #region Company Insertion SMSA_CompanyMst_ST Comp = new SMSA_CompanyMst_ST(); Comp.OrgID = tt.POrgId.Value; Comp.OrgIDSpecified = true; Comp.Address = tt.Address; Comp.CompanyName = tt.CompanyName; Comp.ContactPerson = tt.ContactPerson; Comp.CreatedBy = user; Comp.CreatedBySpecified = true; Comp.CreatedOn = DateTime.Now; Comp.CreatedOnSpecified = true; Comp.Email = tt.Email; Comp.EstID = tt.EstID; Comp.IsActive = "Y"; Comp.IsApproved = "Y"; Comp.logoPath = tt.logoPath; Comp.Mobile = tt.Mobile; Comp.Phone = tt.Phone; Comp.SaleAccId = tt.SubAgentId > 0 ? tt.SubAgentId : tt.AgentId > 0 ? tt.AgentId : Comp.SaleAccId; Comp.SaleAccIdSpecified = true; Comp.UserName = tt.UserName; int rtn = dbUser.InsertCompany(Comp); #region Activity Log SMSA_Logs_HI log = new SMSA_Logs_HI(); utility.IsSpecifed <SMSA_Logs_HI>(log); log.ActivityBy = user.Value; log.ActivityDesc = "Add New Company"; log.ActivityOn = DateTime.Now; log.ActivityType = "I"; log.ColumnId = rtn; dbUser.AddActivityLog(log); #endregion if (rtn > 0) { if (Membership.GetUser(tt.UserName) == null) { MembershipCreateStatus status; // Generate a new 12-character password with 1 non-alphanumeric character. //y0t(9ci&xUn^ string password = tt.UserName + "123"; //utility.GetUniqueKey(8);//Membership.GeneratePassword(8, 0); // string password = "******"; MembershipUser newUser = Membership.CreateUser(tt.UserName, password, tt.UserName, "ok", "ok", true, out status); UserServiceClass.SMIM_UserMst_ST User = new UserServiceClass.SMIM_UserMst_ST(); User.UserId = 0; User.UserName = tt.UserName; User.Email = tt.Email; User.FirstName = tt.ContactPerson; User.OrgId = tt.POrgId.Value; User.CompanyId = rtn; utility.IsSpecifed <UserServiceClass.SMIM_UserMst_ST>(User); int maxValue = db.InsertUser(User); } return(Json(new { success = true, response = "Company registered successfully." })); } else if (rtn == 0) { return(Json(new { success = false, response = "Company already registered." })); } #endregion } } catch (Exception) { throw; } var req = tt; return(View(tt)); }