public PartialViewResult UpdateCustomerAddress(Int32 id)
{
SRLogRepository objdata = new SRLogRepository();
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
tblCustAddress custaddress = db.tblCustAddresses.Where(x => x.Id == id).FirstOrDefault();
CustomerAddressViewModel address = new CustomerAddressViewModel();
address.Address1 = custaddress.Address1;
address.Address2 = custaddress.Address2;
address.City = custaddress.City;
address.State = custaddress.State;
address.ZipCode = custaddress.ZipCode;
address.Country = custaddress.Country;
address.SiteName = custaddress.SiteName;
if (custaddress.IsPrimaryAddress == true)
{
address.IsPrimaryAddress = true;
}
else
{
address.IsPrimaryAddress = false;
}
//address.IsPrimaryAddress = custaddress.IsPrimaryAddress;
address.ProjectManagerList = objdata.GetGroupUser();
address.ProjectManager = custaddress.ProjectManager;
address.Id = custaddress.Id;
address.CustomerId = custaddress.CustomerId;
ViewBag.Adddisable = false;
ViewBag.CustomerId = custaddress.CustomerId;
ViewBag.CustomerAddressId = custaddress.Id;
return(PartialView("CreateCustomerAddress", address));
}
public ActionResult DeleteCustomer(int id)
{
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
var custcontact = (from c in db.tblCustContacts
where c.CustomerId == id
select c).ToList();
foreach (var c in custcontact)
{
int ContactId = c.Id;
tblCustContact contact = db.tblCustContacts.Where(x => x.Id == ContactId).FirstOrDefault();
db.tblCustContacts.Remove(contact);
db.SaveChanges();
}
var custaddress = (from c in db.tblCustAddresses
where c.CustomerId == id
select c).ToList();
foreach (var a in custaddress)
{
int AddressId = a.Id;
tblCustAddress address = db.tblCustAddresses.Where(x => x.Id == AddressId).FirstOrDefault();
db.tblCustAddresses.Remove(address);
db.SaveChanges();
}
tblCustomer customer = db.tblCustomers.Where(x => x.CustomerId == id).FirstOrDefault();
db.tblCustomers.Remove(customer);
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateCustomerAddress(CustomerAddressViewModel custaddress)
{
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
if (custaddress.CustomerId != 0)
{
CustomerRepository objdata = new CustomerRepository();
if (string.IsNullOrEmpty(custaddress.Address1) == false)
{
custaddress.Address1 = custaddress.Address1.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.Address2) == false)
{
custaddress.Address2 = custaddress.Address2.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.City) == false)
{
custaddress.City = custaddress.City.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.Country) == false)
{
custaddress.Country = custaddress.Country.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.State) == false)
{
custaddress.State = custaddress.State.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.ZipCode) == false)
{
custaddress.ZipCode = custaddress.ZipCode.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.SiteName) == false)
{
custaddress.SiteName = custaddress.SiteName.ToUpper();
}
objdata.AddUpdateCustomerAddress(custaddress, "Update");
tblCustomer customer = db.tblCustomers.Where(x => x.CustomerId == custaddress.CustomerId).FirstOrDefault();
var act = new ActivityRepository();
act.AddActivityLog(Convert.ToString(Session["User"]), "Edit address", "UpdateCustomerAddress", "Addresses for customer " + customer.CustomerName.ToUpper() + " edited by " + Convert.ToString(Session["User"]) + ".");
}
//CustomerRepository _repository = new CustomerRepository();
//var cust = _repository.GetCustomerDetails(custaddress.CustomerId);
tblCustAddress cust = new tblCustAddress();
return(Json(cust, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteCustomerAddress(Int32 Id)
{
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
tblCustAddress custaddress = db.tblCustAddresses.Where(x => x.Id == Id).FirstOrDefault();
int customerId = custaddress.CustomerId;
db.tblCustAddresses.Remove(custaddress);
db.SaveChanges();
tblCustomer customer = db.tblCustomers.Where(x => x.CustomerId == customerId).FirstOrDefault();
var act = new ActivityRepository();
act.AddActivityLog(Convert.ToString(Session["User"]), "Delete address", "DeleteCustomerAddress", "Address " + custaddress.Address1 + " of customer " + customer.CustomerName + " deleted by user " + Convert.ToString(Session["User"]) + ".");
return(Json(true, JsonRequestBehavior.AllowGet));
}
public JsonResult SetPrimaryAddress(Int32 Id, Int32 customerId, bool setdefault)
{
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
if (setdefault == true)
{
var cust = (from c in db.tblCustAddresses
where c.CustomerId == customerId && c.Id != Id
select c).ToList();
foreach (var c in cust)
{
tblCustAddress address = db.tblCustAddresses.Where(x => x.Id == c.Id).FirstOrDefault();
address.IsPrimaryAddress = false;
db.SaveChanges();
}
}
tblCustAddress custaddress = db.tblCustAddresses.Where(x => x.Id == Id).FirstOrDefault();
custaddress.IsPrimaryAddress = setdefault;
db.SaveChanges();
tblCustomer customer = db.tblCustomers.Where(x => x.CustomerId == customerId).FirstOrDefault();
var act = new ActivityRepository();
if (setdefault == true)
{
act.AddActivityLog(Convert.ToString(Session["User"]), "Update default address", "SetPrimaryAddress", "Default address set to " + custaddress.Address1 + " for customer " + customer.CustomerName + " by user " + Convert.ToString(Session["User"]) + ".");
}
else
{
act.AddActivityLog(Convert.ToString(Session["User"]), "Update default address", "SetPrimaryContact", "Default contact " + custaddress.Address1 + " removed for customer " + customer.CustomerName + " by user " + Convert.ToString(Session["User"]) + ".");
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public void AddUpdateCustomerAddress(CustomerAddressViewModel model, string Flag)
{
using (var context = new SR_Log_DatabaseSQLEntities())
{
if (Flag == "Add")
{
if (model.IsPrimaryAddress == true)
{
var ExistCust = (from c in context.tblCustAddresses
where c.CustomerId == model.CustomerId
select c).ToList();
if (ExistCust.Count > 0)
{
foreach (var cust in ExistCust)
{
if (cust.IsPrimaryAddress == true)
{
tblCustAddress result = (from c in context.tblCustAddresses
where c.Id == cust.Id
select c).FirstOrDefault();
if (result != null)
{
result.IsPrimaryAddress = false;
context.SaveChanges();
}
}
}
}
}
var customer = context.USP_TT_InsertCustAddress(model.CustomerId, model.Address1, model.Address2, model.City, model.State, model.ZipCode, model.Country, model.SiteName, model.IsPrimaryAddress, model.ProjectManager);
}
else
{
if (model.IsPrimaryAddress == true)
{
var ExistCust = (from c in context.tblCustAddresses
where c.CustomerId == model.CustomerId
select c).ToList();
if (ExistCust.Count > 0)
{
foreach (var cust in ExistCust)
{
if (cust.IsPrimaryAddress == true)
{
tblCustAddress r = (from c in context.tblCustAddresses
where c.Id == cust.Id && c.Id != model.Id
select c).SingleOrDefault();
if (r != null)
{
r.IsPrimaryAddress = false;
context.SaveChanges();
}
}
}
}
}
tblCustAddress result = (from c in context.tblCustAddresses
where c.Id == model.Id
select c).SingleOrDefault();
result.Address1 = model.Address1;
result.Address2 = model.Address2;
result.City = model.City;
result.State = model.State;
result.ZipCode = model.ZipCode;
result.Country = model.Country;
result.IsPrimaryAddress = model.IsPrimaryAddress;
result.SiteName = model.SiteName;
result.ProjectManager = model.ProjectManager;
context.SaveChanges();
}
}
}
public ActionResult CreateCustomerAddress(CustomerAddressViewModel custaddress)
{
SR_Log_DatabaseSQLEntities db = new SR_Log_DatabaseSQLEntities();
if (custaddress.CustomerId != 0)
{
var existcustcontact = db.tblCustAddresses.Where(x => x.Address1.Trim().ToUpper() == custaddress.Address1.Trim().ToUpper() && x.CustomerId == custaddress.CustomerId && x.SiteName.ToUpper() == custaddress.SiteName).FirstOrDefault();
if (existcustcontact != null)
{
ViewBag.Message = "This address is already added for this site. Please choose a different site name.";
return(Json(custaddress, JsonRequestBehavior.AllowGet));
}
else
{
CustomerRepository objdata = new CustomerRepository();
if (string.IsNullOrEmpty(custaddress.Address1) == false)
{
custaddress.Address1 = custaddress.Address1.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.Address2) == false)
{
custaddress.Address2 = custaddress.Address2.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.City) == false)
{
custaddress.City = custaddress.City.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.Country) == false)
{
custaddress.Country = custaddress.Country.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.State) == false)
{
custaddress.State = custaddress.State.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.ZipCode) == false)
{
custaddress.ZipCode = custaddress.ZipCode.ToUpper();
}
if (string.IsNullOrEmpty(custaddress.SiteName) == false)
{
custaddress.SiteName = custaddress.SiteName.ToUpper();
}
objdata.AddUpdateCustomerAddress(custaddress, "Add");
}
}
//CustomerRepository _repository = new CustomerRepository();
//var cust = _repository.GetCustomerDetails(custaddress.CustomerId);
tblCustAddress cust = new tblCustAddress();
return(Json(cust, JsonRequestBehavior.AllowGet));
}
