/// <summary>
/// Get Customer Document Details By CustDocId
/// </summary>
/// <param name="custDocId">Int32:custDocId</param>
/// <returns></returns>
public CustomerDocumentsDTO GetCustomerDocumentDetailsByCustDocId(int custDocId)
{
CustomerDocumentsDTO customerDocuments = new CustomerDocumentsDTO();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocument>>()
.GetSingle(item => item.CustDoc_Doc_Id == custDocId && item.CustDoc_IsDeleted == false), customerDocuments);
return customerDocuments;
}
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();
}
public void EditCustomerDocumentDetails(IList<CustomerDocDetailsDTO> listCustDocDetails, IList<CustomerDocumentsDTO> listCustDocument)
{
using (TransactionScope transactionScope = new TransactionScope())
{
for (int i = 0; i < listCustDocDetails.Count; i++)
{
customerdocdetail custDocdetailsEntity = new customerdocdetail();
CustomerDocService custDocuments = new CustomerDocService();
CustomerDocDetailsDTO customerDocDetail = custDocuments.GetCustomerDocumentDetailsByDocIdAndCustId(
listCustDocDetails[i].Cust_Doc_CustId, listCustDocDetails[i].Cust_Doc_DocId);
if (customerDocDetail.Cust_Doc_Id > 0)
{
AutoMapper.Mapper.Map(customerDocDetail, custDocdetailsEntity);
custDocdetailsEntity.Cust_Doc_FileName = listCustDocDetails[i].Cust_Doc_FileName;
custDocdetailsEntity.Cust_Doc_No = listCustDocDetails[i].Cust_Doc_No;
custDocdetailsEntity.Cust_Doc_ExDate = listCustDocDetails[i].Cust_Doc_ExDate;
ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>()
.Update(custDocdetailsEntity);
}
else
{
AutoMapper.Mapper.Map(listCustDocDetails[i], custDocdetailsEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocdetail>>()
.Save(custDocdetailsEntity);
}
CustomerDocumentsDTO customerDocument = new CustomerDocumentsDTO();
CustomerDocumentsViewDTO customerDocumentView = new CustomerDocumentsViewDTO();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocumentsview>>()
.GetSingle(item => item.CustDoc_Doc_Id == custDocdetailsEntity.Cust_Doc_Id && item.CustDoc_IsDeleted == false), customerDocumentView);
AutoMapper.Mapper.Map(customerDocumentView, customerDocument);
customerdocument custDocumentEntity = new customerdocument();
if (customerDocument.CustDoc_Id > 0)
{
AutoMapper.Mapper.Map(customerDocument, custDocumentEntity);
if (listCustDocument[i].CustDoc_File == null)
{
custDocumentEntity.CustDoc_IsDeleted = true;
}
else
{
custDocumentEntity.CustDoc_File = listCustDocument[i].CustDoc_File;
}
ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocument>>().Update(custDocumentEntity);
}
else
{
AutoMapper.Mapper.Map(listCustDocument[i], custDocumentEntity);
custDocumentEntity.CustDoc_Doc_Id = custDocdetailsEntity.Cust_Doc_Id;
ESalesUnityContainer.Container.Resolve<IGenericRepository<customerdocument>>().Save(custDocumentEntity);
}
}
transactionScope.Complete();
}
}
/// <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);
}