/// <summary>
/// Get Truck Doc Details By TruckId And DocId
/// </summary>
/// <param name="truckId">Int32:truckId</param>
/// <param name="documentId">Int32:documentId</param>
/// <returns></returns>
public TruckDocDetailsDTO GetTruckDocDetailsByTruckIdAndDocId(int truckId, int documentId)
{
TruckDocDetailsDTO objTruckDocDetails = new TruckDocDetailsDTO();
truckdocdetail TruckDocDetailsEntity = ESalesUnityContainer.Container
.Resolve<IGenericRepository<truckdocdetail>>()
.GetSingle(item => item.Truck_Doc_TruckId == truckId && item.Truck_Doc_DocId == documentId && item.Truck_Doc_IsDeleted == false);
AutoMapper.Mapper.Map(TruckDocDetailsEntity, objTruckDocDetails);
//return the value
return objTruckDocDetails;
}
/// <summary>
/// Verify Truck Document No Exists by truckDocId,docId and docNo
/// </summary>
/// <param name="truckDocId">Int32:truckDocId</param>
/// <param name="docId">Int32:docId</param>
/// <param name="docNo">string:docNo</param>
/// <returns></returns>
public bool TruckDocumentNoExists(int truckDocId, int docId, string docNo)
{
TruckDocDetailsDTO objTruckDocDetailsDTO = new TruckDocDetailsDTO();
if (truckDocId > 0)
{
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdocdetail>>().GetSingle
(item => item.Truck_Doc_Id != truckDocId && item.Truck_Doc_DocId == docId && item.Truck_Doc_DocNo == docNo &&
item.Truck_Doc_IsDeleted == false), objTruckDocDetailsDTO);
}
else
{
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdocdetail>>().GetSingle
(item => item.Truck_Doc_DocId == docId && item.Truck_Doc_DocNo == docNo &&
item.Truck_Doc_IsDeleted == false), objTruckDocDetailsDTO);
}
return objTruckDocDetailsDTO.Truck_Doc_Id > 0 ? true : false;
}
private void FillGridWithTruckDetails(string truckNo,string docName)
{
TruckVerificationDTO truckDetails = new TruckVerificationDTO();
truckDetails = ESalesUnityContainer.Container.Resolve<ITruckService>().GetAllTruckDetails(truckNo);
if (truckDetails.type > 0)
{
IList<TruckVerificationDTO> lstTruckDetails = new List<TruckVerificationDTO>();
lstTruckDetails.Add(truckDetails);
grdManageTrucks.DataSource = lstTruckDetails;
grdManageTrucks.DataBind();
}
else
{
//ucMessageBoxForGrid.ShowMessage(Resources.Messages.TruckDetailsDoesNotExist);
}
if (Convert.ToInt32(ddlTruckDoc.SelectedItem.Value) == 1)
{
grdManageTrucks.Columns[6].Visible = true;
grdDocument.Visible = false;
}
else
{
grdManageTrucks.Columns[6].Visible = false;
grdDocument.Visible = true;
if (truckDetails.type == 1)
{
TruckDocDetailsDTO truckDocDetails = new TruckDocDetailsDTO();
truckDocDetails = ESalesUnityContainer.Container.Resolve<ITruckDocService>().GetTruckDocDetailsByTruckIdAndDocId(truckDetails.Truck_Id, Convert.ToInt32(ddlTruckDoc.SelectedItem.Value));
if (truckDocDetails.Truck_Doc_Id > 0)
{
LoadDocumentGrid();
ViewState[Globals.StateMgmtVariables.TRUCKID] = truckDocDetails.Truck_Doc_TruckId;
foreach (GridViewRow row in grdDocument.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (truckDocDetails != null)
{
((TextBox)row.FindControl("txtDocNo")).Text = truckDocDetails.Truck_Doc_DocNo;
//((HiddenField)row.FindControl("hdnCustDocId")).Value = truckDocDetails.Cust_Doc_Id.ToString();
((TextBox)row.FindControl("txtDocExDate")).Text = string.IsNullOrEmpty(Convert.ToString(truckDocDetails.Truck_Doc_ExDate)) ? string.Empty :
Convert.ToDateTime(truckDocDetails.Truck_Doc_ExDate).ToString("dd MMM yyyy");
}
}
}
}
else
{
base.ShowBlankRowInGrid<DocTypeDTO>(grdDocument);
}
}
else if (truckDetails.type == 2)
{
StandaloneTruckDocDetails standaloneTruckDocDetails = ESalesUnityContainer.Container.Resolve<IStandaloneTruckService>().GetStandaloneTruckDocDetailsByTruckIdAndDocId(truckDetails.Truck_Id, Convert.ToInt32(ddlTruckDoc.SelectedItem.Value));
if (standaloneTruckDocDetails.StandaloneTruck_Doc_Id > 0)
{
LoadDocumentGrid();
ViewState[Globals.StateMgmtVariables.TRUCKID] = standaloneTruckDocDetails.StandaloneTruck_Doc_TruckId;
foreach (GridViewRow row in grdDocument.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (standaloneTruckDocDetails != null)
{
((TextBox)row.FindControl("txtDocNo")).Text = standaloneTruckDocDetails.StandaloneTruck_Doc_DocNo;
//((HiddenField)row.FindControl("hdnCustDocId")).Value = truckDocDetails.Cust_Doc_Id.ToString();
((TextBox)row.FindControl("txtDocExDate")).Text = string.IsNullOrEmpty(Convert.ToString(standaloneTruckDocDetails.StandaloneTruck_Doc_ExDate)) ? string.Empty :
Convert.ToDateTime(standaloneTruckDocDetails.StandaloneTruck_Doc_ExDate).ToString("dd MMM yyyy");
}
}
}
}
else
{
base.ShowBlankRowInGrid<DocTypeDTO>(grdDocument);
}
}
}
}
private void SaveDocumentListForTruck(string truckNo)
{
TruckVerificationDTO truckDetails = new TruckVerificationDTO();
truckDetails = ESalesUnityContainer.Container.Resolve<ITruckService>().GetAllTruckDetails(truckNo);
IList<TruckDocDetailsDTO> listTruckDocDetail = new List<TruckDocDetailsDTO>();
IList<TruckDocumentsDTO> listTruckDocument = new List<TruckDocumentsDTO>();
IList<StandaloneTruckDocDetails> listStandaloneTruckDocDetail = new List<StandaloneTruckDocDetails>();
foreach (GridViewRow row in grdDocument.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (((TextBox)(row.Cells[2].Controls[1])).Text != string.Empty)
{
if (truckDetails.type == 1)
{
TruckDocDetailsDTO truckDocDetails = new TruckDocDetailsDTO();
truckDocDetails.Truck_Doc_TruckId = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.TRUCKID]);
truckDocDetails.Truck_Doc_DocId = Convert.ToInt32(grdDocument.DataKeys[row.RowIndex].Value);
truckDocDetails.Truck_Doc_DocNo = ((TextBox)(row.Cells[2].Controls[1])).Text;
DateTimeFormatInfo dateTimeFormatterProvider = DateTimeFormatInfo.CurrentInfo.Clone() as DateTimeFormatInfo;
dateTimeFormatterProvider.ShortDatePattern = "dd/MM/yyyy";
if (((TextBox)(row.Cells[3].Controls[1])).Text != string.Empty)
{
truckDocDetails.Truck_Doc_ExDate = DateTime.Parse(((TextBox)(row.Cells[3].Controls[1])).Text, dateTimeFormatterProvider);
}
TruckDocumentsDTO truckDocument = new TruckDocumentsDTO();
truckDocument.TruckDoc_CreatedBy = base.GetCurrentUserId();
truckDocument.TruckDoc_CreatedDate = DateTime.Now;
truckDocument.TruckDoc_LastUpdatedDate = DateTime.Now;
//If fileupload control has file
if (filAuthDoc.HasFile)
{
string uploadFilePath = Path.Combine(Server.MapPath("../CustomerAuthImages"), filAuthDoc.FileName);
filAuthDoc.SaveAs(uploadFilePath);
truckDocument.TruckDoc_File = ImageToBlob.ConvertImageToByteArray(uploadFilePath);
truckDocDetails.Truck_Doc_FileName = filAuthDoc.FileName;
//Delete the file from application folder after converting into byte array
File.Delete(uploadFilePath);
}
else
{
truckDocument.TruckDoc_File = null;
}
listTruckDocument.Add(truckDocument);
truckDocDetails.Truck_Doc_CreatedBy = GetCurrentUserId();
truckDocDetails.Truck_Doc_CreatedDate = DateTime.Now;
truckDocDetails.Truck_Doc_LastUpdatedDate = DateTime.Now;
listTruckDocDetail.Add(truckDocDetails);
ESalesUnityContainer.Container.Resolve<ITruckService>().SaveAndUpdateTruckDocumentDetails(listTruckDocDetail, listTruckDocument);
}
else if (truckDetails.type == 2)
{
StandaloneTruckDocDetails standaloneTruckDocDetails = new StandaloneTruckDocDetails();
standaloneTruckDocDetails.StandaloneTruck_Doc_TruckId = Convert.ToInt32(ViewState[Globals.StateMgmtVariables.TRUCKID]);
standaloneTruckDocDetails.StandaloneTruck_Doc_DocId = Convert.ToInt32(grdDocument.DataKeys[row.RowIndex].Value);
standaloneTruckDocDetails.StandaloneTruck_Doc_DocNo = ((TextBox)(row.Cells[2].Controls[1])).Text;
if (((TextBox)(row.Cells[3].Controls[1])).Text != string.Empty)
{
standaloneTruckDocDetails.StandaloneTruck_Doc_ExDate = DateTime.Parse(((TextBox)(row.Cells[3].Controls[1])).Text.ToString());
}
if (filAuthDoc.HasFile)
{
string uploadFilePath = Path.Combine(Server.MapPath("../CustomerAuthImages"), filAuthDoc.FileName);
filAuthDoc.SaveAs(uploadFilePath);
standaloneTruckDocDetails.StandaloneTruck_Doc_File = ImageToBlob.ConvertImageToByteArray(uploadFilePath);
standaloneTruckDocDetails.StandaloneTruck_Doc_FileName = filAuthDoc.FileName;
File.Delete(uploadFilePath);
}
else
{
standaloneTruckDocDetails.StandaloneTruck_Doc_File = null;
}
standaloneTruckDocDetails.StandaloneTruck_Doc_CreatedBy = GetCurrentUserId();
standaloneTruckDocDetails.StandaloneTruck_Doc_CreatedDate = DateTime.Now;
standaloneTruckDocDetails.StandaloneTruck_Doc_LastUpdatedDate = DateTime.Now;
listStandaloneTruckDocDetail.Add(standaloneTruckDocDetails);
ESalesUnityContainer.Container.Resolve<IStandaloneTruckService>().SaveAndUpdateStandaloneTruckDocumentDetails(listStandaloneTruckDocDetail);
}
}
}
}
}
/// <summary>
/// Delete Truck Doc Details
/// </summary>
/// <param name="truckDocs"></param>
private static void DeleteTruckDocDetails(TruckDocDetailsDTO truckDocs)
{
truckdocdetail truckDocEntity = new truckdocdetail();
AutoMapper.Mapper.Map(truckDocs, truckDocEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdocdetail>>().Update(truckDocEntity);
}
private void SaveDocumentListForTrucks(int truckId)
{
IList<TruckDocDetailsDTO> listTruckDetail = new List<TruckDocDetailsDTO>();
IList<TruckDocumentsDTO> listTruckDocument = new List<TruckDocumentsDTO>();
foreach (GridViewRow row in grdDocument.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (((TextBox)(row.Cells[3].Controls[1])).Text != string.Empty)
{
TruckDocDetailsDTO truckDocDetail = new TruckDocDetailsDTO();
truckDocDetail.Truck_Doc_TruckId = truckId;
truckDocDetail.Truck_Doc_DocId = Convert.ToInt32(grdDocument.DataKeys[row.RowIndex].Value);
truckDocDetail.Truck_Doc_DocNo = ((TextBox)(row.Cells[3].Controls[1])).Text;
DateTimeFormatInfo dateTimeFormatterProvider = DateTimeFormatInfo.CurrentInfo.Clone() as DateTimeFormatInfo;
dateTimeFormatterProvider.ShortDatePattern = "dd/MM/yyyy";
truckDocDetail.Truck_Doc_ExDate = DateTime.Parse(((TextBox)(row.Cells[4].Controls[1])).Text, dateTimeFormatterProvider);
TruckDocumentsDTO truckDocument = new TruckDocumentsDTO();
truckDocument.TruckDoc_CreatedBy = base.GetCurrentUserId();
truckDocument.TruckDoc_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);
truckDocument.TruckDoc_File = ImageToBlob.ConvertImageToByteArray(filePath);
}
else
{
truckDocument.TruckDoc_File = null;
}
listTruckDocument.Add(truckDocument);
truckDocDetail.Truck_Doc_FileName = ((Label)(row.Cells[6].Controls[1])).Text;
truckDocDetail.Truck_Doc_CreatedBy = GetCurrentUserId();
truckDocDetail.Truck_Doc_CreatedDate = DateTime.Now;
truckDocDetail.Truck_Doc_LastUpdatedDate = DateTime.Now;
listTruckDetail.Add(truckDocDetail);
}
}
}
//Save Truck Document Details
ESalesUnityContainer.Container.Resolve<ITruckService>().SaveAndUpdateTruckDocumentDetails(listTruckDetail, listTruckDocument);
}
