public string SaveUpdateLC(SalLCMaster LCInfo, List <SalLCDetail> LCDetailList, ArrayList fileNames, vmCmnParameters objcmnParam) { GenericFactory_SalLCMaster = new SalLCMaster_EF(); GenericFactory_SalLCDetail = new SalLCDetail_EF(); GenericFactory_CmnDocument = new CmnDocument_EF(); GenericFactory_EF_SalPIMaster = new SalPIMaster_EF(); GenericFactory_EF_SalBookingMaster = new SalBookingMaster_EF(); string result = ""; string newLCRefNo = ""; long FirstDigit = 0, OtherDigits = 0, nextDetailId = 0, NextId = 0; #region Amendment Block if (LCInfo.LCID > 0) { using (TransactionScope transaction = new TransactionScope()) { try { NextId = Convert.ToInt64(GenericFactory_SalLCMaster.getMaxID("SalLCMaster")); nextDetailId = Convert.ToInt64(GenericFactory_SalLCDetail.getMaxID("SalLCDetail")); FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, Convert.ToInt32(nextDetailId.ToString().Length) - 1)); //******------------------start create LC Amendment No No------------------****** string[] amendmendNo = LCInfo.LCReferenceNo.ToString().Split(new string[] { "-AMD-" }, StringSplitOptions.None); //itemMaster.PINO.ToString().Contains("Revise").ToString(); int amendNo = 0; if (amendmendNo.Length > 1) { amendNo = Convert.ToInt16(amendmendNo[amendmendNo.Length - 1]) + 1; newLCRefNo = amendmendNo[0] + "-AMD-" + amendNo.ToString(); } else if (amendmendNo.Length == 1) { newLCRefNo = LCInfo.LCReferenceNo.ToString() + "-AMD-1".ToString(); amendNo = 1; } //******------------------end create LC Amendment No------------------****** //******------------------Update LC master and Detail------------------****** Int64 lLCID = LCInfo.LCID; IEnumerable <SalLCMaster> objSalLCMaster = GenericFactory_SalLCMaster.FindBy(m => m.LCID == lLCID).ToList(); SalLCMaster lstSalLCMaster = new SalLCMaster(); foreach (SalLCMaster lc in objSalLCMaster) { lc.IsActive = false; lstSalLCMaster = lc; } GenericFactory_SalLCMaster.Update(lstSalLCMaster); GenericFactory_SalLCMaster.Save(); IEnumerable <SalLCDetail> objSalLCDetail = GenericFactory_SalLCDetail.FindBy(m => m.LCID == lLCID).ToList(); SalLCDetail lstSalLCDetail = new SalLCDetail(); foreach (SalLCDetail lcd in objSalLCDetail) { lcd.IsActive = false; lstSalLCDetail = lcd; } GenericFactory_SalLCDetail.Update(lstSalLCDetail); GenericFactory_SalLCDetail.Save(); //******------------------End Update LC master and Detail ------------------****** //******------------------Start PI Table Update ------------------****** foreach (SalLCDetail sdtl in LCDetailList) { SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault(); objSalPIMaster.IsLcCompleted = true; GenericFactory_EF_SalPIMaster.Update(objSalPIMaster); GenericFactory_EF_SalPIMaster.Save(); } //******------------------ End PI Table Update ------------------****** LCInfo.LCID = NextId; LCInfo.LCReferenceNo = newLCRefNo; LCInfo.AmendmentDate = LCInfo.LCDate; LCInfo.AmendmentNo = amendNo.ToString(); LCInfo.CreateOn = DateTime.Now; LCInfo.IsMasterLC = false; LCInfo.IsActive = true; LCInfo.IsHDOCompleted = false; List <SalLCDetail> lstLCDetail = new List <SalLCDetail>(); foreach (SalLCDetail sdtl in LCDetailList) { SalLCDetail objLCDetail = new SalLCDetail(); objLCDetail.LCDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits); objLCDetail.LCID = NextId; objLCDetail.PIID = sdtl.PIID; objLCDetail.PINo = sdtl.PINo; objLCDetail.CustomCode = LCInfo.LCReferenceNo; objLCDetail.LCReferenceNo = LCInfo.LCReferenceNo; objLCDetail.AmendmentNo = LCInfo.AmendmentNo; objLCDetail.AmendmentDate = LCInfo.AmendmentDate; objLCDetail.CompanyID = LCInfo.CompanyID; objLCDetail.IsHDOCompleted = false; objLCDetail.CreateBy = LCInfo.CreateBy; objLCDetail.CreateOn = DateTime.Now; objLCDetail.CreatePc = HostService.GetIP(); objLCDetail.IsActive = true; objLCDetail.IsDeleted = false; objLCDetail.DBID = 1; objLCDetail.StatusBy = 1; objLCDetail.StatusID = 1; lstLCDetail.Add(objLCDetail); OtherDigits++; } GenericFactory_SalLCMaster.Insert(LCInfo); GenericFactory_SalLCMaster.Save(); GenericFactory_SalLCMaster.updateMaxID("SalLCMaster", Convert.ToInt64(NextId)); GenericFactory_SalLCDetail.InsertList(lstLCDetail); GenericFactory_SalLCDetail.Save(); GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); //**********----------------------Start File Upload----------------------********** int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument")); List <CmnDocument> lstCmnDocument = new List <CmnDocument>(); for (int i = 1; i <= fileNames.Count; i++) { CmnDocument objCmnDocument = new CmnDocument(); objCmnDocument.DocumentID = DocumentID; objCmnDocument.DocumentPahtID = 1; //objCmnDocument.DocumentName = fileNames[i].ToString(); string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString()); objCmnDocument.DocumentName = newLCRefNo + "_Doc_" + i + extension; objCmnDocument.TransactionID = LCInfo.LCID; objCmnDocument.TransactionTypeID = 1; objCmnDocument.CompanyID = LCInfo.CompanyID; objCmnDocument.CreateBy = LCInfo.CreateBy; objCmnDocument.CreateOn = DateTime.Now; objCmnDocument.CreatePc = HostService.GetIP(); objCmnDocument.IsDeleted = false; objCmnDocument.IsDeleted = false; lstCmnDocument.Add(objCmnDocument); DocumentID++; } GenericFactory_CmnDocument.InsertList(lstCmnDocument); GenericFactory_CmnDocument.Save(); GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1)); //**********----------------------File upload completed----------------------********** transaction.Complete(); result = newLCRefNo; } catch (Exception e) { e.ToString(); result = ""; } } } #endregion Amendment Block #region New LC Block else { using (TransactionScope transaction = new TransactionScope()) { //////////////////////////////////////////Primary Key and Custom Code Strat////////////////////////////////// ////start new maxId //int NextId = Convert.ToInt16(GenericFactory_SalLCMaster.getMaxID("SalLCMaster")); //int nextDetailId = Convert.ToInt16(GenericFactory_SalLCDetail.getMaxID("SalLCDetail")); ////end new maxId //...........START new maxId........// NextId = Convert.ToInt64(GenericFactory_SalLCMaster.getMaxID("SalLCMaster")); nextDetailId = Convert.ToInt64(GenericFactory_SalLCDetail.getMaxID("SalLCDetail")); FirstDigit = Convert.ToInt64(nextDetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(nextDetailId.ToString().Substring(1, nextDetailId.ToString().Length - 1)); //..........END new maxId.........// //// start for custom code //string customCode = ""; //CmnCustomCode objCustomCode = GFactory_EF_CmnCustomCode.FindBy(m => m.MenuID == 25 && m.CompanyID == LCInfo.CompanyID).FirstOrDefault(); //int customCodeID = Convert.ToInt16(objCustomCode.RecordID); //if (customCodeID > 0) //{ // customCode = GenericFactory_SalLCMaster.getCustomCode(customCodeID, DateTime.Now, LCInfo.CompanyID, 1, 1); //} //else //{ // customCode = NextId.ToString(); //} //// end for custom code //......... START for custom code........... // string customCode = ""; string CustomNo = customCode = GenericFactory_SalLCMaster.getCustomCode(objcmnParam.menuId, LCInfo.LCDate ?? DateTime.Now, LCInfo.CompanyID, 1, 1);// // 1 for user id and 1 for db id --- work later if (CustomNo != null) { customCode = CustomNo; } else { customCode = NextId.ToString(); } //.........END for custom code............ // //////////////////////////////////////////Primary Key and Custom Code End////////////////////////////////// try { LCInfo.LCID = NextId; LCInfo.CreateOn = DateTime.Now; if (LCInfo.MasterLCNO != "") { LCInfo.IsMasterLC = true; } else { LCInfo.IsMasterLC = false; } LCInfo.IsActive = true; LCInfo.LCReferenceNo = customCode; LCInfo.AmendmentNo = "0"; LCInfo.IsHDOCompleted = false; string ImagePath = string.Empty; //if (string.IsNullOrEmpty(ImagePath) && !string.IsNullOrEmpty(LCInfo.ImageNames)) //{ // //ImagePath=utils //} List <SalLCDetail> lstSalLCDetail = new List <SalLCDetail>(); foreach (SalLCDetail sdtl in LCDetailList) { SalLCDetail objSalLCDetail = new SalLCDetail(); //objSalLCDetail.LCDetailID = nextDetailId; objSalLCDetail.LCDetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits); objSalLCDetail.LCID = NextId; objSalLCDetail.PIID = sdtl.PIID; objSalLCDetail.PINo = sdtl.PINo; objSalLCDetail.CustomCode = LCInfo.LCReferenceNo; objSalLCDetail.LCReferenceNo = LCInfo.LCReferenceNo; objSalLCDetail.IsHDOCompleted = false; objSalLCDetail.CompanyID = LCInfo.CompanyID; objSalLCDetail.CreateBy = LCInfo.CreateBy; objSalLCDetail.CreateOn = DateTime.Now; objSalLCDetail.CreatePc = HostService.GetIP(); objSalLCDetail.IsActive = true; objSalLCDetail.IsDeleted = false; objSalLCDetail.DBID = 1; objSalLCDetail.StatusBy = 1; objSalLCDetail.StatusID = 1; lstSalLCDetail.Add(objSalLCDetail); OtherDigits++; } //foreach (SalLCDetail sdtl in LCDetailList) //{ // SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault(); // objSalPIMaster.IsLcCompleted = true; // GenericFactory_EF_SalPIMaster.Update(objSalPIMaster); // GenericFactory_EF_SalPIMaster.Save(); //} /////////////////////// Start PI Table Update ///////////////////////////// foreach (SalLCDetail sdtl in LCDetailList) { SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault(); objSalPIMaster.IsLcCompleted = true; GenericFactory_EF_SalPIMaster.Update(objSalPIMaster); GenericFactory_EF_SalPIMaster.Save(); } /////////////////////// End PI Table Update ///////////////////////////// /////////////////////// Start Booking Table Update ///////////////////////////// foreach (SalLCDetail sdtl in LCDetailList) { SalPIMaster objSalPIMaster = GenericFactory_EF_SalPIMaster.FindBy(m => m.PIID == sdtl.PIID).FirstOrDefault(); SalBookingMaster objBookingMaster = GenericFactory_EF_SalBookingMaster.FindBy(m => m.BookingID == objSalPIMaster.BookingID).FirstOrDefault(); objBookingMaster.IsLCCompleted = true; GenericFactory_EF_SalBookingMaster.Update(objBookingMaster); GenericFactory_EF_SalBookingMaster.Save(); } /////////////////////// End Booking Table Update ///////////////////////////// GenericFactory_SalLCMaster.Insert(LCInfo); GenericFactory_SalLCMaster.Save(); GenericFactory_SalLCMaster.updateMaxID("SalLCMaster", Convert.ToInt64(NextId)); GenericFactory_SalLCMaster.updateCustomCode(25, DateTime.Now, LCInfo.CompanyID, 1, 1); GenericFactory_SalLCDetail.InsertList(lstSalLCDetail); GenericFactory_SalLCDetail.Save(); //GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(nextDetailId - 1)); GenericFactory_SalLCDetail.updateMaxID("SalLCDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); ////////////////////////////////////////Start File Upload////////////////////////////// int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument")); List <CmnDocument> lstCmnDocument = new List <CmnDocument>(); for (int i = 1; i <= fileNames.Count; i++) { CmnDocument objCmnDocument = new CmnDocument(); objCmnDocument.DocumentID = DocumentID; objCmnDocument.DocumentPahtID = 1; //objCmnDocument.DocumentName = fileNames[i].ToString(); string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString()); objCmnDocument.DocumentName = customCode + "_Doc_" + i + extension; objCmnDocument.TransactionID = LCInfo.LCID; objCmnDocument.TransactionTypeID = 1; objCmnDocument.CompanyID = LCInfo.CompanyID; objCmnDocument.CreateBy = LCInfo.CreateBy; objCmnDocument.CreateOn = DateTime.Now; objCmnDocument.CreatePc = HostService.GetIP(); objCmnDocument.IsDeleted = false; objCmnDocument.IsDeleted = false; lstCmnDocument.Add(objCmnDocument); DocumentID++; } GenericFactory_CmnDocument.InsertList(lstCmnDocument); GenericFactory_CmnDocument.Save(); GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1)); ///////////////////////////////////////////////File upload completed///////////////////////////////////////////// transaction.Complete(); result = customCode; } catch (Exception e) { e.ToString(); result = ""; } } } #endregion New LC Block return(result); }
public string SaveUpdatePOMasterNdetails(PurchasePOMaster chMaster, List <PurchasePODetail> chDetails, int menuID, ArrayList fileNames, List <vmTermsCondition> termdetail) { _ctxCmn = new ERP_Entities(); GenericFactory_EF_CmnCombo = new CmnCombo_EF(); string result = ""; if (chMaster.POID > 0) { using (TransactionScope transaction = new TransactionScope()) { try { Int64 poID = chMaster.POID; IEnumerable <PurchasePOMaster> lstPurchasePOMaster = (from qcm in _ctxCmn.PurchasePOMasters.Where(m => m.POID == poID && m.CompanyID == chMaster.CompanyID) select qcm).ToList(); PurchasePOMaster objPurchasePOMaster = new PurchasePOMaster(); foreach (PurchasePOMaster qcms in lstPurchasePOMaster) { qcms.UpdateBy = chMaster.CreateBy; qcms.UpdateOn = DateTime.Now; qcms.UpdatePc = HostService.GetIP(); qcms.POID = chMaster.POID; qcms.CurrencyID = chMaster.CurrencyID; qcms.Amount = chMaster.Amount; qcms.PODate = chMaster.PODate; qcms.BankAccountNo = chMaster.BankAccountNo; qcms.DepartmentID = chMaster.DepartmentID; qcms.TransactionTypeID = chMaster.TransactionTypeID; qcms.BankBranchID = chMaster.BankBranchID; qcms.IsDeleted = false; qcms.BankID = chMaster.BankID; qcms.PartyID = chMaster.PartyID; //qcms.PIID = chMaster.PIID; qcms.CompanyID = chMaster.CompanyID; qcms.ExpireDate = chMaster.ExpireDate; //qcms.FRID= chMaster.FRID; qcms.LCorVoucherorLcafDate = chMaster.LCorVoucherorLcafDate; qcms.LCorVoucherorLcafNo = chMaster.LCorVoucherorLcafNo; qcms.MoneyTransactionTypeID = chMaster.MoneyTransactionTypeID; qcms.OrderTypeID = chMaster.OrderTypeID; qcms.RequisitionID = qcms.RequisitionID; qcms.ShipmentDate = qcms.ShipmentDate; objPurchasePOMaster = qcms; } List <PurchasePODetail> lstPurchasePODetail = new List <PurchasePODetail>(); foreach (PurchasePODetail qcdt in chDetails) { PurchasePODetail objPurchasePODetail = (from qcdetl in _ctxCmn.PurchasePODetails.Where(m => m.PODetailID == qcdt.PODetailID) select qcdetl).FirstOrDefault(); objPurchasePODetail.Amount = qcdt.Amount; objPurchasePODetail.FOBValue = qcdt.FOBValue; objPurchasePODetail.FreightCharge = qcdt.FreightCharge; objPurchasePODetail.HSCode = qcdt.HSCode; objPurchasePODetail.ItemID = qcdt.ItemID; objPurchasePODetail.NetWeight = qcdt.NetWeight; objPurchasePODetail.IsDeleted = false; objPurchasePODetail.GrossWeight = qcdt.GrossWeight; objPurchasePODetail.OriginCountryID = qcdt.OriginCountryID; objPurchasePODetail.NetWeight = qcdt.NetWeight; objPurchasePODetail.PackingQty = qcdt.PackingQty; objPurchasePODetail.PackingUnitID = qcdt.PackingUnitID; objPurchasePODetail.Qty = qcdt.Qty; objPurchasePODetail.UnitID = qcdt.UnitID; objPurchasePODetail.UnitPrice = qcdt.UnitPrice; objPurchasePODetail.WeightUnitID = qcdt.WeightUnitID; objPurchasePODetail.UpdateBy = chMaster.CreateBy; objPurchasePODetail.UpdateOn = DateTime.Now; objPurchasePODetail.UpdatePc = HostService.GetIP(); lstPurchasePODetail.Add(objPurchasePODetail); } _ctxCmn.SaveChanges(); //**********----------------------Start File Upload----------------------********** GenericFactory_CmnDocument = new CmnDocument_EF(); int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument")); List <CmnDocument> lstCmnDocument = new List <CmnDocument>(); for (int i = 1; i <= fileNames.Count; i++) { CmnDocument objCmnDocument = new CmnDocument(); objCmnDocument.DocumentID = DocumentID; objCmnDocument.DocumentPahtID = 2; //objCmnDocument.DocumentName = fileNames[i].ToString(); string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString()); objCmnDocument.DocumentName = chMaster.PONo + "_Doc_" + i + extension; objCmnDocument.TransactionID = chMaster.POID; objCmnDocument.TransactionTypeID = 22; objCmnDocument.CompanyID = chMaster.CompanyID; objCmnDocument.CreateBy = Convert.ToInt16(chMaster.CreateBy); objCmnDocument.CreateOn = DateTime.Now; objCmnDocument.CreatePc = HostService.GetIP(); objCmnDocument.IsDeleted = false; objCmnDocument.IsDeleted = false; lstCmnDocument.Add(objCmnDocument); DocumentID++; } GenericFactory_CmnDocument.InsertList(lstCmnDocument); GenericFactory_CmnDocument.Save(); GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1)); //**********----------------------File upload completed----------------------********** transaction.Complete(); result = chMaster.PONo.ToString(); } catch (Exception e) { e.ToString(); result = ""; } } } else { using (TransactionScope transaction = new TransactionScope()) { try { //...........START new maxId...............// long NextId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("PurchasePOMaster")); long FirstDigit = 0; long OtherDigits = 0; long nextChDetailId = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("PurchasePODetail")); FirstDigit = Convert.ToInt64(nextChDetailId.ToString().Substring(0, 1)); OtherDigits = Convert.ToInt64(nextChDetailId.ToString().Substring(1, nextChDetailId.ToString().Length - 1)); //..........END new maxId....................// //......... START for custom code........... // string customCode = ""; string CustomNo = GenericFactory_EF_CmnCombo.getCustomCode(menuID, chMaster.PODate ?? DateTime.Now, chMaster.CompanyID ?? 1, 1, 1); if (CustomNo != null) { customCode = CustomNo; } else { customCode = NextId.ToString(); } //.........END for custom code............ // string newChNo = customCode; chMaster.POID = NextId; chMaster.CreateOn = DateTime.Now; chMaster.CreatePc = HostService.GetIP(); chMaster.PONo = newChNo; chMaster.IsDeleted = false; List <PurchasePODetail> lstchDetail = new List <PurchasePODetail>(); foreach (PurchasePODetail sdtl in chDetails) { PurchasePODetail objchDetail = new PurchasePODetail(); objchDetail.PODetailID = Convert.ToInt64(FirstDigit + "" + OtherDigits);//nextQCDetailId; objchDetail.POID = NextId; objchDetail.FOBValue = sdtl.FOBValue; objchDetail.FreightCharge = sdtl.FreightCharge; objchDetail.HSCode = sdtl.HSCode; objchDetail.OriginCountryID = sdtl.OriginCountryID; objchDetail.ItemID = sdtl.ItemID; objchDetail.GrossWeight = sdtl.GrossWeight; objchDetail.NetWeight = sdtl.NetWeight; objchDetail.PackingQty = sdtl.PackingQty; objchDetail.PackingUnitID = sdtl.PackingUnitID; objchDetail.UnitID = sdtl.UnitID; objchDetail.UnitPrice = sdtl.UnitPrice; objchDetail.WeightUnitID = sdtl.WeightUnitID; objchDetail.Qty = sdtl.Qty; objchDetail.IsDeleted = false; objchDetail.Amount = sdtl.Amount; objchDetail.UnitID = sdtl.UnitID; objchDetail.CreateBy = chMaster.CreateBy; objchDetail.CreateOn = DateTime.Now; objchDetail.CreatePc = HostService.GetIP(); lstchDetail.Add(objchDetail); OtherDigits++; // InvGrrDetail objInvGrrDetail = (from grrd in _ctxCmn.InvGrrDetails.Where(m => m.GrrID == qcMaster.GrrID && m.ItemID == sdtl.ItemID) select grrd).FirstOrDefault(); // objInvGrrDetail.QcRemainingQty = objInvGrrDetail.QcRemainingQty - (sdtl.PassQty + sdtl.RejectQty); } _ctxCmn.PurchasePOMasters.Add(chMaster); //............Save Term and condition.................// if (termdetail.Count > 0) { long FirstDigits = 0; long OtherDigitss = 0; long NextPOTermID = Convert.ToInt16(GenericFactory_EF_CmnCombo.getMaxID("PurchasePOTerm")); FirstDigits = Convert.ToInt64(NextPOTermID.ToString().Substring(0, 1)); OtherDigitss = Convert.ToInt64(NextPOTermID.ToString().Substring(1, NextPOTermID.ToString().Length - 1)); List <PurchasePOTerm> lstTerms = new List <PurchasePOTerm>(); foreach (vmTermsCondition sdtl in termdetail) { PurchasePOTerm objchDetail = new PurchasePOTerm(); objchDetail.POTermsID = Convert.ToInt64(FirstDigits + "" + OtherDigitss);//nextQCDetailId; objchDetail.POID = NextId; objchDetail.TermID = Convert.ToInt32(sdtl.TermID); objchDetail.CompanyID = Convert.ToInt16(chMaster.CompanyID); objchDetail.Sequence = sdtl.Sequence; objchDetail.IsDeleted = false; objchDetail.CreateBy = Convert.ToInt32(chMaster.CreateBy); objchDetail.CreateOn = DateTime.Now; objchDetail.CreatePc = HostService.GetIP(); lstTerms.Add(objchDetail); OtherDigitss++; } _ctxCmn.PurchasePOTerms.AddRange(lstTerms); //............Update MaxID.................// GenericFactory_EF_CmnCombo.updateMaxID("PurchasePOTerm", Convert.ToInt64(FirstDigits + "" + (OtherDigitss - 1))); } //............Update MaxID.................// GenericFactory_EF_CmnCombo.updateMaxID("PurchasePOMaster", Convert.ToInt64(NextId)); //............Update CustomCode.............// GenericFactory_EF_CmnCombo.updateCustomCode(menuID, chMaster.PODate ?? DateTime.Now, chMaster.CompanyID ?? 1, 1, 1); _ctxCmn.PurchasePODetails.AddRange(lstchDetail); //............Update MaxID.................// GenericFactory_EF_CmnCombo.updateMaxID("PurchasePODetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1))); _ctxCmn.SaveChanges(); //**********----------------------Start File Upload----------------------********** GenericFactory_CmnDocument = new CmnDocument_EF(); int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument")); List <CmnDocument> lstCmnDocument = new List <CmnDocument>(); for (int i = 1; i <= fileNames.Count; i++) { CmnDocument objCmnDocument = new CmnDocument(); objCmnDocument.DocumentID = DocumentID; objCmnDocument.DocumentPahtID = 2; //objCmnDocument.DocumentName = fileNames[i].ToString(); string extension = System.IO.Path.GetExtension(fileNames[i - 1].ToString()); objCmnDocument.DocumentName = chMaster.PONo + "_Doc_" + i + extension; objCmnDocument.TransactionID = chMaster.POID; objCmnDocument.TransactionTypeID = 22; objCmnDocument.CompanyID = chMaster.CompanyID; objCmnDocument.CreateBy = Convert.ToInt16(chMaster.CreateBy); objCmnDocument.CreateOn = DateTime.Now; objCmnDocument.CreatePc = HostService.GetIP(); objCmnDocument.IsDeleted = false; objCmnDocument.IsDeleted = false; lstCmnDocument.Add(objCmnDocument); DocumentID++; } GenericFactory_CmnDocument.InsertList(lstCmnDocument); GenericFactory_CmnDocument.Save(); GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1)); //**********----------------------File upload completed----------------------********** transaction.Complete(); result = newChNo; } catch (Exception e) { result = ""; } } } return(result); }
public int uploadFiles(List <vmRndDoc> _DocList) { int?transactionTypeID = _DocList.FirstOrDefault().TransactionTypeID; transactionTypeID = 30; ERP_Entities _contex = new ERP_Entities(); CmnDocumentPath objDocumentPath = _contex.CmnDocumentPaths.Where(x => x.TransactionTypeID == transactionTypeID).FirstOrDefault(); GenericFactory_CmnDocument = new CmnDocument_EF(); int DocumentID = Convert.ToInt16(GenericFactory_CmnDocument.getMaxID("CmnDocument")); List <CmnDocument> lstCmnDocument = new List <CmnDocument>(); List <CmnDocument> UpdateCmnDocument = new List <CmnDocument>(); bool isCreated = true; foreach (vmRndDoc item in _DocList) { CmnDocument objCmnDocument = new CmnDocument(); CmnDocument objCmnDocumentTemp = new CmnDocument(); if (item.DocumentID == 0) { isCreated = true; objCmnDocument.DocumentID = DocumentID; } else { isCreated = false; objCmnDocument.DocumentID = item.DocumentID; objCmnDocumentTemp = _contex.CmnDocuments.Where(x => x.DocumentID == item.DocumentID).FirstOrDefault(); } objCmnDocument.DocumentPahtID = objDocumentPath.DocumentPathID; objCmnDocument.DocName = item.DocName; objCmnDocument.DocumentName = item.DocumentName; objCmnDocument.TransactionID = item.TransactionID; objCmnDocument.TransactionTypeID = item.TransactionTypeID; objCmnDocument.CompanyID = item.CompanyID; objCmnDocument.IsDeleted = item.IsDeleted; if (isCreated) { objCmnDocument.CreateBy = Convert.ToInt16(item.CreateBy); objCmnDocument.CreateOn = DateTime.Now; objCmnDocument.CreatePc = HostService.GetIP(); } else if (item.IsDeleted) { objCmnDocument.CreateBy = objCmnDocumentTemp.CreateBy; objCmnDocument.CreateOn = objCmnDocumentTemp.CreateOn; objCmnDocument.CreatePc = objCmnDocumentTemp.CreatePc; objCmnDocument.UpdateBy = objCmnDocumentTemp.UpdateBy; objCmnDocument.UpdateOn = objCmnDocumentTemp.UpdateOn; objCmnDocument.UpdatePc = objCmnDocumentTemp.UpdatePc; objCmnDocument.DeleteBy = Convert.ToInt16(item.CreateBy); objCmnDocument.DeleteOn = DateTime.Now; objCmnDocument.DeletePc = HostService.GetIP(); } else { objCmnDocument.CreateBy = objCmnDocumentTemp.CreateBy; objCmnDocument.CreateOn = objCmnDocumentTemp.CreateOn; objCmnDocument.CreatePc = objCmnDocumentTemp.CreatePc; objCmnDocument.UpdateBy = Convert.ToInt16(item.CreateBy); objCmnDocument.UpdateOn = DateTime.Now; objCmnDocument.UpdatePc = HostService.GetIP(); } DocumentID++; if (isCreated) { lstCmnDocument.Add(objCmnDocument); } else { UpdateCmnDocument.Add(objCmnDocument); } } GenericFactory_CmnDocument.InsertList(lstCmnDocument); GenericFactory_CmnDocument.Save(); GenericFactory_CmnDocumentUpDate = new CmnDocument_EF(); GenericFactory_CmnDocumentUpDate.UpdateList(UpdateCmnDocument); GenericFactory_CmnDocumentUpDate.Save(); GenericFactory_CmnDocument.updateMaxID("CmnDocument", Convert.ToInt64(DocumentID - 1)); return(DocumentID); }