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