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