public List <M_CustomerParent> getAllParents()
{
try
{
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
List <M_CustomerParent> PList = new List <M_CustomerParent>();
dbContext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllParentCustomersResult> lst = dbContext._getAllParentCustomers();
foreach (_getAllParentCustomersResult result in lst)
{
M_CustomerParent M = new M_CustomerParent();
M.Customer_Name = result.CustomerName;
M.Parent_Id = result.ParentCustomerId;
PList.Add(M);
}
return(PList);
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
// Console.WriteLine(ex.Message.ToString());
return(null);
}
}
public JsonResult EditCustomer(M_CustomerParent Model)
{
bool result = false;
Model.Parent_Id = _session.Customer_ID;
try
{
result = CustomerOBj.Update_ParentCustomerDetails(Model);
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool Update_ParentCustomerDetails(M_CustomerParent pr)
{
try
{
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
dbContext._setUpdateParentCustomer(pr.Parent_Id,
pr.Customer_Name,
pr.Telephone,
pr.Fax,
pr.Email,
pr.Address1,
pr.Address2,
pr.Address3,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(false);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
public List <M_CustomerParent> getAllCustomerDetails_()
{
try
{
List <M_CustomerParent> Requests = new List <M_CustomerParent>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllParentCustomersDetailsResult> lst = datacontext._getAllParentCustomersDetails();
foreach (_getAllParentCustomersDetailsResult result in lst)
{
M_CustomerParent req = new M_CustomerParent();
req.Customer_Name = result.CustomerName;
req.Address1 = result.Address1 + " ," + result.Address2 + " ," + result.Address3;
req.ContactPersonDesignation = result.ContactPersonDesignation;
req.ContactPersonDirectPhone = result.ContactPersonDirectPhoneNumber;
req.ContactPersonEmail = result.ContactPersonEmail;
req.ContactPersonMobile = result.ContactPersonMobile;
req.ContactPersonName = result.ContactPersonName;
req.CreatedDate = result.CreatedDate;
req.Email = result.Email;
req.Fax = result.Fax;
req.IsNCEMember = result.NCEMember;
req.IsVat = result.IsSVat;
req.Parent_Id = result.ParentCustomerId;
req.Request_Id = result.RequestId;
req.Status = result.Status;
req.Telephone = result.Telephone;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
