private void FillGridWithCustomerDetails(int mandatoryDocId, string documentNo) { IList<CustomerDTO> lstCustomerDTO = new List<CustomerDTO>(); if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICustomerService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { int agentId = Convert.ToInt32(customerDetails.Cust_AgentId); switch (agentId) { case 20: customerDetails.Cust_AgentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentShortNameByAgentId(agentId); break; case 21: customerDetails.Cust_AgentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentShortNameByAgentId(agentId); break; case 22: customerDetails.Cust_AgentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentShortNameByAgentId(agentId); break; case 23: customerDetails.Cust_AgentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentShortNameByAgentId(agentId); break; case 24: customerDetails.Cust_AgentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentShortNameByAgentId(agentId); break; } lstCustomerDTO.Add(customerDetails); } } else { CustomerDocDetailsDTO docDetails = new CustomerDocDetailsDTO(); docDetails = ESalesUnityContainer.Container.Resolve<ICustomerDocService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (docDetails.Cust_Doc_Customer != null) { lstCustomerDTO.Add(docDetails.Cust_Doc_Customer); } } if (lstCustomerDTO.Count > 0) { grdDCACustomersAssociation.DataSource = lstCustomerDTO; grdDCACustomersAssociation.DataBind(); } else { ShowBlankGrid(); } }
/// <summary> /// Get Customer Document Details By DocId And CustId /// </summary> /// <param name="customerId">Int32:customerId</param> /// <param name="documentId">Int32:documentId</param> /// <returns></returns> public CustomerDocDetailsDTO GetCustomerDocumentDetailsByDocIdAndCustId(int customerId, int documentId) { CustomerDocDetailsDTO customerDocDetails = new CustomerDocDetailsDTO(); AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>() .GetSingle(item => item.Cust_Doc_CustId == customerId && item.Cust_Doc_DocId == documentId && item.Cust_Doc_IsDeleted == false), customerDocDetails); return customerDocDetails; }
/// <summary> /// Get Customer By Document Id /// </summary> /// <param name="documentType">Int32:documentType</param> /// <param name="documentNumber">string:documentNumber</param> /// <returns></returns> public CustomerDocDetailsDTO GetCustomerByDocumentId(int documentType, string documentNumber) { CustomerDocDetailsDTO customerDocDetails = new CustomerDocDetailsDTO(); AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>() .GetSingle(item => item.Cust_Doc_DocId == documentType && item.Cust_Doc_No.Equals(documentNumber) && item.Cust_Doc_IsDeleted == false), customerDocDetails); return customerDocDetails; }
/// <summary> /// Get Registered Customer By documentType and documentNumber /// </summary> /// <param name="documentType">Int32:documentType</param> /// <param name="documentNumber">string:documentNumber</param> /// <returns></returns> public CustomerDocDetailsDTO GetRegisteredCustomerByDocumentId(int documentType, string documentNumber) { CustomerDocDetailsDTO customerDocDetails = new CustomerDocDetailsDTO(); AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>() .GetSingle(item => item.Cust_Doc_DocId == documentType && item.Cust_Doc_No == documentNumber && item.Cust_Doc_IsDeleted == false && item.customer.Cust_IsBlacklisted == false && item.customer.Cust_RegCustType == true && item.customer.Cust_Code != null ), customerDocDetails); return customerDocDetails; }
private void FillGridWithAuthRepDetails(int mandatoryDocId, string documentNo) { CustomerDTO customer = new CustomerDTO(); if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICustomerService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { customer = customerDetails; } } else { CustomerDocDetailsDTO doctype = new CustomerDocDetailsDTO(); doctype = ESalesUnityContainer.Container.Resolve<ICustomerDocService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (doctype.Cust_Doc_Customer != null) { customer = doctype.Cust_Doc_Customer; } } if (customer.Cust_Id>0) { IList<AuthRepDTO> lstAuthRepDetailsDTO = (ESalesUnityContainer.Container.Resolve<IAuthRepService>() .GetAuthRepDetailsForCustomer(customer.Cust_Id)); ViewState[Globals.StateMgmtVariables.CUSTOMERID] = customer.Cust_Id; ViewState[Globals.StateMgmtVariables.CUSTFOLDERNAME] = customer.Cust_FolderName; if (lstAuthRepDetailsDTO.Count > 0) { grdManageAuthRep.DataSource = lstAuthRepDetailsDTO; grdManageAuthRep.DataBind(); } else { FillBlankGrid(); } } else { FillBlankGrid(); } }
private void FillDropdownWithCustomerDetails(int mandatoryDocId, string documentNo) { IList<CustomerDTO> lstCustomerDTO = new List<CustomerDTO>(); if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { lstCustomerDTO.Add(customerDetails); } } else { CustomerDocDetailsDTO docDetails = new CustomerDocDetailsDTO(); docDetails = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (docDetails.Cust_Doc_Customer != null) { lstCustomerDTO.Add(docDetails.Cust_Doc_Customer); } } if (lstCustomerDTO.Count > 0) { PopulateCustCautionList(); DropDownList ddlCustomerName = (DropDownList)grdCustCautionLstMaster.FooterRow.FindControl("ddlCustomerName"); ddlCustomerName.DataSource = lstCustomerDTO; ddlCustomerName.DataBind(); ddlCustomerName.Items.Insert(0, new ListItem(Messages.SelectCustomer, "0")); } else { PopulateCustCautionList(); // ShowBlankGrid(); } }
/// <summary> /// /// </summary> private void FillGridWithCustomerDetails(int mandatoryDocId, string documentNo) { IList<CustomerDTO> lstCustomerDTO = new List<CustomerDTO>(); if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICustomerService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { lstCustomerDTO.Add(customerDetails); } } else { CustomerDocDetailsDTO docDetails = new CustomerDocDetailsDTO(); docDetails = ESalesUnityContainer.Container.Resolve<ICustomerDocService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (docDetails.Cust_Doc_Customer != null) { lstCustomerDTO.Add(docDetails.Cust_Doc_Customer); } } if (lstCustomerDTO.Count > 0) { grdManageCustomers.DataSource = lstCustomerDTO; grdManageCustomers.DataBind(); ViewState[Globals.StateMgmtVariables.TRADENAME] = lstCustomerDTO[0].Cust_TradeName; } else { FillBlankGrid(); } }
/// <summary> /// Verify Customer Document No Exists or not by custDocId,docId and docNo /// </summary> /// <param name="custDocId">Int32:custDocId</param> /// <param name="docId">Int32:docId</param> /// <param name="docNo">string:docNo</param> /// <returns></returns> public bool CustomerDocumentNoExists(int custDocId, int docId, string docNo) { CustomerDocDetailsDTO objCustomerDocDetailsDTO = new CustomerDocDetailsDTO(); if (custDocId > 0) { AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>().GetSingle (item => item.Cust_Doc_Id != custDocId && item.Cust_Doc_DocId == docId && item.Cust_Doc_No == docNo && item.Cust_Doc_IsDeleted == false), objCustomerDocDetailsDTO); } else { AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>().GetSingle (item => item.Cust_Doc_DocId == docId && item.Cust_Doc_No == docNo && item.Cust_Doc_IsDeleted == false), objCustomerDocDetailsDTO); } return objCustomerDocDetailsDTO.Cust_Doc_Id > 0 ? true : false; }
/// <summary> /// Delete Customer Document Details /// </summary> /// <param name="customerDocs"></param> private static void DeleteCustomerDocumentDetails(CustomerDocDetailsDTO customerDocs) { customerdocdetail custDocEntity = new customerdocdetail(); AutoMapper.Mapper.Map(customerDocs, custDocEntity); ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>().Update(custDocEntity); }
private void FillDropdownWithTruckRegNo(int mandatoryDocId, string documentNo) { IList<CustomerDTO> lstCustomerDTO = new List<CustomerDTO>(); IList<TruckDetailsDTO> lstTruckDTO = new List<TruckDetailsDTO>(); if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { lstTruckDTO = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCautionListForTrucksByCustId(customerDetails.Cust_Id); } } else { CustomerDocDetailsDTO docDetails = new CustomerDocDetailsDTO(); docDetails = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (docDetails.Cust_Doc_Customer != null) { lstTruckDTO = ESalesUnityContainer.Container.Resolve<ICautionListService>().GetCautionListForTrucksByCustId(docDetails.Cust_Doc_Id); } } if (lstTruckDTO.Count > 0) { PopulateTruckCautionList(); DropDownList ddlTruckRegNo = (DropDownList)grdTruckCautionLst.FooterRow.FindControl("ddlTruckRegNo"); ddlTruckRegNo.DataSource = lstTruckDTO; ddlTruckRegNo.DataBind(); ddlTruckRegNo.Items.Insert(0, new ListItem(Messages.SelectTruckRegNo, "0")); } else { PopulateTruckCautionList(); DropDownList ddlTruckRegNo = (DropDownList)grdTruckCautionLst.FooterRow.FindControl("ddlTruckRegNo"); ddlTruckRegNo.Items.Insert(0, new ListItem(Messages.SelectTruckRegNo, "0")); } }
private void SaveDocumentListForCustomer() { IList<CustomerDocDetailsDTO> listDocDetail = new List<CustomerDocDetailsDTO>(); IList<CustomerDocumentsDTO> listCustDocument = new List<CustomerDocumentsDTO>(); foreach (GridViewRow row in grdDocument.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (((TextBox)(row.Cells[3].Controls[1])).Text != string.Empty) { CustomerDocDetailsDTO custDocDetails = new CustomerDocDetailsDTO(); custDocDetails.Cust_Doc_CustId = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.CUSTOMERID]); custDocDetails.Cust_Doc_DocId = Convert.ToInt32(grdDocument.DataKeys[row.RowIndex].Value); custDocDetails.Cust_Doc_No = ((TextBox)(row.Cells[3].Controls[1])).Text; DateTimeFormatInfo dateTimeFormatterProvider = DateTimeFormatInfo.CurrentInfo.Clone() as DateTimeFormatInfo; dateTimeFormatterProvider.ShortDatePattern = "dd/MM/yyyy"; if (((TextBox)(row.Cells[4].Controls[1])).Text != string.Empty) { custDocDetails.Cust_Doc_ExDate = DateTime.Parse(((TextBox)(row.Cells[4].Controls[1])).Text, dateTimeFormatterProvider); } CustomerDocumentsDTO custDocument = new CustomerDocumentsDTO(); custDocument.CustDoc_CreatedBy = base.GetCurrentUserId(); custDocument.CustDoc_CreatedDate = DateTime.Now; if (((Label)(row.Cells[6].Controls[1])).Text.Trim() != string.Empty) { string filePath = Path.Combine(Convert.ToString(ViewState[Globals.StateMgmtVariables.FILEPATH]), ((Label)(row.Cells[6].Controls[1])).Text); custDocument.CustDoc_File = ImageToBlob.ConvertImageToByteArray(filePath); } else { custDocument.CustDoc_File = null; } listCustDocument.Add(custDocument); custDocDetails.Cust_Doc_FileName = ((Label)(row.Cells[6].Controls[1])).Text; custDocDetails.Cust_Doc_CreatedBy = GetCurrentUserId(); custDocDetails.Cust_Doc_CreatedDate = DateTime.Now; custDocDetails.Cust_Doc_LastUpdatedDate = DateTime.Now; listDocDetail.Add(custDocDetails); } } } //Save Customer Document Details ESalesUnityContainer.Container.Resolve<ICustomerService>().SaveAndUpdateCustomerDocumentDetails(listDocDetail, listCustDocument); DeleteFiles(); }
private void FillGridWithTruckDetails(int mandatoryDocId, string documentNo) { CustomerDTO customer = new CustomerDTO(); try { ExceptionHandler.AppExceptionManager.Process(() => { if (Convert.ToInt32(mandatoryDocId) == 0) { CustomerDTO customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICustomerService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { customer = customerDetails; } } else { CustomerDocDetailsDTO doctype = new CustomerDocDetailsDTO(); doctype = ESalesUnityContainer.Container.Resolve<ICustomerDocService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (doctype.Cust_Doc_Customer != null) { customer = doctype.Cust_Doc_Customer; } } if (customer.Cust_Id >0) { IList<TruckDetailsDTO> lstTruckDetailsDTO = (ESalesUnityContainer.Container.Resolve<ITruckService>() .GetTruckDetailsForCustomer(customer.Cust_Id)); ViewState[Globals.StateMgmtVariables.CUSTOMERID] = customer.Cust_Id; ViewState[Globals.StateMgmtVariables.CUSTFOLDERNAME] = customer.Cust_FolderName; if (lstTruckDetailsDTO.Count > 0) { grdManageTrucks.DataSource = lstTruckDetailsDTO; grdManageTrucks.DataBind(); } else { FillBlankGrid(); } } else { FillBlankGrid(); } }, Globals.ExceptionTypes.ExceptionShielding.ToString()); } catch (Exception ex) { } }
private void FillGridWithCustomerDetails(int mandatoryDocId, string documentNo) { IList<CustomerDTO> lstCustomerDTO = new List<CustomerDTO>(); CustomerDTO customerDetails = null; if (Convert.ToInt32(mandatoryDocId) == 0) { customerDetails = new CustomerDTO(); customerDetails = ESalesUnityContainer.Container.Resolve<ICustomerService>().GetCustomerDetailsByCode(documentNo); if (customerDetails.Cust_Id > 0) { lstCustomerDTO.Add(customerDetails); } } else { CustomerDocDetailsDTO docDetails = new CustomerDocDetailsDTO(); docDetails = ESalesUnityContainer.Container.Resolve<ICustomerDocService>().GetCustomerByDocumentId(mandatoryDocId, documentNo); if (docDetails.Cust_Doc_Customer != null) { lstCustomerDTO.Add(docDetails.Cust_Doc_Customer); } } if (lstCustomerDTO.Count > 0) { CustomerDocDetailsDTO custDocDetails = ESalesUnityContainer.Container.Resolve<ICustomerDocService>() .GetCustomerDocumentDetailsByDocIdAndCustId(Convert.ToInt32(lstCustomerDTO[0].Cust_Id), Convert.ToInt32(ddlAllDocument.SelectedItem.Value)); if (custDocDetails.Cust_Doc_Id > 0) { LoadDocumentGrid(); ViewState[Globals.StateMgmtVariables.CUSTOMERID] = custDocDetails.Cust_Doc_CustId; foreach (GridViewRow row in grdDocument.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (custDocDetails != null) { ((TextBox)row.FindControl("txtDocNo")).Text = custDocDetails.Cust_Doc_No; ((HiddenField)row.FindControl("hdnCustDocId")).Value = custDocDetails.Cust_Doc_Id.ToString(); ((TextBox)row.FindControl("txtDocExDate")).Text = string.IsNullOrEmpty(Convert.ToString(custDocDetails.Cust_Doc_ExDate)) ? string.Empty : Convert.ToDateTime(custDocDetails.Cust_Doc_ExDate).ToString("dd MMM yyyy"); } } } grdManageCustomers.DataSource = lstCustomerDTO; grdManageCustomers.DataBind(); //ViewState[Globals.StateMgmtVariables.TRADENAME] = lstCustomerDTO[0].Cust_TradeName; } else { grdManageCustomers.DataSource = lstCustomerDTO; grdManageCustomers.DataBind(); CustomerDocDetailsDTO custDocDetailsNew = ESalesUnityContainer.Container.Resolve<ICustomerDocService>() .GetCustomerDocumentDetailsByDocIdAndCustId(Convert.ToInt32(lstCustomerDTO[0].Cust_Id), Convert.ToInt32(ddlMandatoryDoc.SelectedItem.Value)); LoadDocumentGrid(); ViewState[Globals.StateMgmtVariables.CUSTOMERID] = customerDetails.Cust_Id; } } else { FillBlankGrid(); } }
/// <summary> /// /// </summary> /// <returns></returns> private void SaveDocumentListForCustomer() { IList<CustomerDocDetailsDTO> listDocDetail = new List<CustomerDocDetailsDTO>(); IList<CustomerDocumentsDTO> listCustDocument = new List<CustomerDocumentsDTO>(); foreach (GridViewRow row in grdDocument.Rows) { if (row.RowType == DataControlRowType.DataRow) { if (((TextBox)(row.Cells[3].Controls[1])).Text != string.Empty) { CustomerDocDetailsDTO custDocDetails = new CustomerDocDetailsDTO(); custDocDetails.Cust_Doc_CustId = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.CUSTOMERID]); custDocDetails.Cust_Doc_DocId = Convert.ToInt32(grdDocument.DataKeys[row.RowIndex].Value); custDocDetails.Cust_Doc_No = ((TextBox)(row.Cells[3].Controls[1])).Text; DateTimeFormatInfo dateTimeFormatterProvider = DateTimeFormatInfo.CurrentInfo.Clone() as DateTimeFormatInfo; dateTimeFormatterProvider.ShortDatePattern = "dd/MM/yyyy"; if (((TextBox)(row.Cells[4].Controls[1])).Text != string.Empty) { custDocDetails.Cust_Doc_ExDate = DateTime.Parse(((TextBox)(row.Cells[4].Controls[1])).Text, dateTimeFormatterProvider); } CustomerDocumentsDTO custDocument = new CustomerDocumentsDTO(); custDocument.CustDoc_CreatedBy = base.GetCurrentUserId(); custDocument.CustDoc_CreatedDate = DateTime.Now; //If fileupload control has file if (filAuthDoc.HasFile) { string uploadFilePath = Path.Combine(Server.MapPath("../CustomerAuthImages"), filAuthDoc.FileName); filAuthDoc.SaveAs(uploadFilePath); custDocument.CustDoc_File = ImageToBlob.ConvertImageToByteArray(uploadFilePath); custDocDetails.Cust_Doc_FileName = filAuthDoc.FileName; //Delete the file from application folder after converting into byte array File.Delete(uploadFilePath); } else { custDocument.CustDoc_File = null; } listCustDocument.Add(custDocument); custDocDetails.Cust_Doc_CreatedBy = GetCurrentUserId(); custDocDetails.Cust_Doc_CreatedDate = DateTime.Now; custDocDetails.Cust_Doc_LastUpdatedDate = DateTime.Now; listDocDetail.Add(custDocDetails); } } } //Save Customer Document Details ESalesUnityContainer.Container.Resolve<ICustomerService>().EditCustomerDocumentDetails(listDocDetail, listCustDocument); }