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