public M_SupportDocument getSupportDocLinks(string RequestId) { try { M_SupportDocument Cu = new M_SupportDocument(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; var lst = datacontext._getSupportDocDownloadData(RequestId).SingleOrDefault(); if (lst != null) { Cu.Download_Path = lst.DownloadPath; Cu.SupportingDocument_Name = lst.DownloadDocName; Cu.Request_ID = lst.RequestID; } } return(Cu); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ActionResult NewSupportDoc(M_SupportDocument Model) { if (Model.SupportingDocument_Name == null) { return(PartialView("P_NewSupportDoc")); } string result = "Error"; try { Model.Created_By = _session.User_Id; if (Model.SupportingDocument_Id == null) { if (objSettings.SDcoument_NewSDcoument(Model)) { result = "Success"; } } else { if (objSettings.SDcoument_UpdateSDcoument(Model)) { result = "Success"; } } } catch (Exception Ex) { ErrorLog.LogError(Ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public List <M_SupportDocument> getTemplateSupportingDocs(string ClientId, string TemplateId) { try { List <M_SupportDocument> lstSD = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getSupportingDOCforRequestResult> lst = datacontext._getSupportingDOCforRequest(ClientId, TemplateId); foreach (_getSupportingDOCforRequestResult result in lst) { M_SupportDocument SD = new M_SupportDocument(); SD.SupportingDocument_Id = result.SupportingDocumentId; SD.SupportingDocument_Name = result.SupportingDocumentName; SD.Is_Mandatory = result.IsMandatory; SD.Template_Id = result.TemplateId; lstSD.Add(SD); } } return(lstSD); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public ActionResult NewSupportDocForTemplate(M_SupportDocument Model) { if (Model.SupportingDocument_Id == null || Model.Template_Id == null) { Model.Is_Mandatory = "Y"; return(PartialView("P_NewSupportDocForTemplate", Model)); } string result = "Error"; try { if (Model.Template_SupportID == 0) { Model.Created_By = "Admin"; if (objSettings.STemp_NewTemplateSupportDoc(Model)) { result = "Success"; } } else { Model.Modified_By = "Admin"; if (objSettings.STemp_UpdateTemplateSupportDoc(Model)) { result = "Success"; } } } catch (Exception Ex) { ErrorLog.LogError(Ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public List <M_SupportDocument> STemp_getSDoctemplates(string IsActive, string TemplateId) { try { List <M_SupportDocument> lstR = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getTemplateSupportDoc_ListResult> lst = datacontext._getTemplateSupportDoc_List(IsActive, TemplateId); foreach (_getTemplateSupportDoc_ListResult result in lst) { M_SupportDocument t = new M_SupportDocument(); t.SupportingDocument_Id = result.SupportingDocumentId; t.SupportingDocument_Name = result.SupportingDocumentName; t.Template_Id = result.TemplateId; t.Template_Name = result.TemplateName; t.Template_SupportID = result.TemplateSupportingDocument; t.Is_Mandatory = result.IsMandatory; lstR.Add(t); } } return(lstR); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public bool STemp_UpdateTemplateSupportDoc(M_SupportDocument sd) { try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { int count = 0; datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_CheckTemplateSupportDocResult> lst = datacontext._CheckTemplateSupportDoc(sd.SupportingDocument_Id, sd.Template_Id); foreach (_CheckTemplateSupportDocResult i in lst) { count = Convert.ToInt32(i.Count_); } if (count == 0) { datacontext._setUpdateTemplateSupportDoc(sd.Template_SupportID, sd.Template_Id, sd.SupportingDocument_Id, sd.Is_Mandatory, sd.Modified_By); datacontext.SubmitChanges(); } } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public List <M_SupportDocument> SDocument_getSDcouments(string supportingDocumentId, string createdBy) { try { List <M_SupportDocument> lstSD = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getSupportDocumentResult> lst = datacontext._getSupportDocument(supportingDocumentId, createdBy); foreach (_getSupportDocumentResult result in lst) { M_SupportDocument SD = new M_SupportDocument(); SD.SupportingDocument_Id = result.SupportingDocumentId; SD.SupportingDocument_Name = result.SupportingDocumentName; SD.Created_By = result.CreatedBy; SD.Created_Date = result.CreatedDate; lstSD.Add(SD); } } return(lstSD); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public List <M_SupportDocument> getCertificateSupportDocs(string CertificateId) { try { List <M_SupportDocument> lstpackage = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getSignedCertificateSupportDocResult> lst = datacontext._getSignedCertificateSupportDoc(CertificateId); foreach (_getSignedCertificateSupportDocResult result in lst) { M_SupportDocument cd = new M_SupportDocument(); cd.Download_Path = result.DPath; cd.Certificate_RequestId = result.RequestRefNo; cd.SupportingDocument_Name = result.Dname; cd.SupportingDocument_Id = result.DId; cd.Status_ = result.IsSigned; lstpackage.Add(cd); } } return(lstpackage); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
//[UserFilter(Function_Id = "F_SUPORT.DOC.N")] public ActionResult NewSupportDoc(string SD, string Name) { if (SD != "") { M_SupportDocument S = new M_SupportDocument(); S.SupportingDocument_Name = Name.Replace("_", " "); S.SupportingDocument_Id = SD; return(PartialView("P_NewSupportDoc", S)); } return(PartialView("P_NewSupportDoc")); }
public bool setInvoiceRate(M_SupportDocument M) { try { using (DBLinqDataContext dbContext = new DBLinqDataContext()) { dbContext.Connection.ConnectionString = Connection_; dbContext._setInvoiceRate(M.ClientID_, M.Invoice_No, M.Request_ID, M.Rate_Id, M.Rate_, M.Created_By); return(true); } } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public JsonResult DeleteSupportDocForTemplate(M_SupportDocument Model) { string result = "Error"; try { if (objSettings.STemp_DeleteRejectReason(Model)) { result = "Success"; } } catch (Exception Ex) { ErrorLog.LogError(Ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public bool STemp_DeleteRejectReason(M_SupportDocument sd) { try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; datacontext._setDeleteTemplateSupportDoc(sd.Template_SupportID); datacontext.SubmitChanges(); } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public bool SDcoument_DeleteSDcoument(M_SupportDocument sd) { try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; datacontext._setDeleteSupportingDocuments(sd.SupportingDocument_Id); datacontext.SubmitChanges(); } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public List <M_SupportDocument> getSupportingDocumentDownload(string ParentId) { try { List <M_SupportDocument> lstSDDoc = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getSupportingDocumentDownloadResult> lst = datacontext._getSupportingDocumentDownload(ParentId); foreach (_getSupportingDocumentDownloadResult result in lst) { M_SupportDocument SD = new M_SupportDocument(); SD.SupportingDocument_Id = result.SupportingDocID; SD.SupportingDocument_Name = result.SupportingDocumentName; SD.Request_ID = result.RequestID; SD.Download_Path = result.DownloadPath; SD.Certificate_RequestId = result.CertificateRequestId; SD.Request_By = result.RequestBy; SD.Description_ = result.InvoiceNo; // SD.Request_Date = result.RequestDate.ToString(); SD.Request_Date = result.RequestDate.Value.ToString("dd/MMM/yy"); SD.Approved_Date = result.ApprovedDate.Value.ToString("dd/MMM/yy"); SD.Approved_BY = result.ApprovedBy; string Con = result.Consignor.Split('<')[0]; string Cone = result.Consignee.Split('<')[0]; SD.Consignee_ = Cone; SD.Consignor_ = Con; SD.Is_Downloaded = result.IsDownloaded; lstSDDoc.Add(SD); } } return(lstSDDoc); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
//For Invoice Genaration public List <M_SupportDocument> getSuuportingDocumentApproval(M_InvoiceData M) { try { List <M_SupportDocument> DocList = new List <M_SupportDocument>(); using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; System.Data.Linq.ISingleResult <_getSuppotingDocumentPeriodicDetailResult> lst = datacontext._getSuppotingDocumentPeriodicDetail(M.CustomerId, M.SupportingDocStatus, M.Start.ToString(), M.End.ToString(), M.InvoiceRateId, M.OtherRateId, M.SupDocInvoiceRateId, M.SupDocOtherRateId, M.AttachSheetId); foreach (_getSuppotingDocumentPeriodicDetailResult result in lst) { M_SupportDocument SRH = new M_SupportDocument(); SRH.Request_ID = result.RequestID; SRH.SupportingDocument_Id = result.SupportingDocID; SRH.SupportingDocument_Name = result.UploadDocName; SRH.Rate_Id = result.RatesId; SRH.Rate_ = result.Rates; DocList.Add(SRH); } } return(DocList); } catch (Exception ex) { ErrorLog.LogError(ex); return(null); } }
public bool SDcoument_NewSDcoument(M_SupportDocument sd) { string SupDocID = string.Empty; try { using (DBLinqDataContext datacontext = new DBLinqDataContext()) { datacontext.Connection.ConnectionString = Connection_; B_RecordSequence seqmanager = new B_RecordSequence(); Int64 sdid = seqmanager.getNextSequence("SupDocID", datacontext); SupDocID = "SDID" + sdid.ToString(); datacontext._setSupportingDocuments(SupDocID, sd.SupportingDocument_Name, sd.Created_By, "Y"); datacontext.SubmitChanges(); } return(true); } catch (Exception ex) { ErrorLog.LogError(ex); return(false); } }
public ActionResult NewSupportDocForTemplate(int id, string sid, string tempid, string isactive) { NCETemplate objTemp = new NCETemplate(); List <M_NCETemplate> Temp = objTemp.getTemplateData("%", "Y", "%"); ViewBag.Bag_NceTemplates = new SelectList(Temp, "Template_Id", "Template_Name"); List <M_SupportDocument> Support = objSettings.SDocument_getSDcouments("%", "%"); ViewBag.Bag_SupportDoc = new SelectList(Support, "SupportingDocument_Id", "SupportingDocument_Name"); M_SupportDocument sp = new M_SupportDocument(); if (id != 0) { sp.Template_SupportID = id; sp.SupportingDocument_Id = sid; sp.Template_Id = tempid; sp.Is_Mandatory = isactive; return(PartialView("P_NewSupportDocForTemplate", sp)); } sp.Is_Mandatory = "Y"; return(PartialView("P_NewSupportDocForTemplate", sp)); }
public ActionResult BulkDownload(string IDs) { try { var strin = new JavaScriptSerializer().DeserializeObject(IDs); string[] arr = strin.ToString().Split(','); if (System.IO.File.Exists(Server.MapPath ("~/Temp/Supportdocs.zip"))) { System.IO.File.Delete(Server.MapPath ("~/Temp/Supportdocs.zip")); } ZipArchive zip = ZipFile.Open(Server.MapPath ("~/Temp/Supportdocs.zip"), ZipArchiveMode.Create); for (int a = 0; a < arr.Length; a++) { M_SupportDocument D = new M_SupportDocument(); D = objCd.getSupportDocLinks(arr[a]); string Folder = arr[a] + "/"; zip.CreateEntryFromFile(Server.MapPath (D.Download_Path), Folder + D.SupportingDocument_Name); } zip.Dispose(); return(File(Server.MapPath("~/Temp/Supportdocs.zip"), "application/zip", DateTime.Now.ToString("dd.MM.yyyy.ss") + ".zip")); //byte[] fileBytes = System.IO.File.ReadAllBytes(Server.MapPath("~/Temp/Certificates.zip")); //return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, DateTime.Now.ToString("dd.MM.yyyy.ss") + ".zip"); } catch (Exception Ex) { ErrorLog.LogError(Ex); return(View()); } }
public ActionResult GenarateInvoice(DateTime S, DateTime E, string C) { /*Start get data for Calculate And Insert to invoice Header for get Invoice No*/ String Start = S.ToString("yyyyMMdd"); String End = E.ToString("yyyyMMdd"); /*end make date for corrct format*/ String Certi_Status = "A";//Certificate Status String SDoc_Status = "A"; String AttachSheetId = System.Configuration.ConfigurationManager.AppSettings["AttachedSheetId"]; String CertificateRateId = System.Configuration.ConfigurationManager.AppSettings["CertificateRateId"]; //get Certificate Rate Id from Web Config String SupDocCertificateRateId = System.Configuration.ConfigurationManager.AppSettings["SupDocCertificateRateId"]; //get Certificate Rate Id from Web Config String InvoiceRateId = System.Configuration.ConfigurationManager.AppSettings["InvoiceRateId"]; //get Invoice Rate Id String OtherRateId = System.Configuration.ConfigurationManager.AppSettings["OtherRateId"]; //get Other Rate Id String SupDocOtherRateId = System.Configuration.ConfigurationManager.AppSettings["SupdocOtherRateId"]; //get Supprting Document Id for Other Rate String SupsDocInvoiceRateId = System.Configuration.ConfigurationManager.AppSettings["SupdocInvoiceRateId"]; //get Supporting Document id For Invoice Rate String VATCode = System.Configuration.ConfigurationManager.AppSettings["VatCode"]; M_InvoiceData Invo_data = new M_InvoiceData(); Invo_data.CustomerId = C; Invo_data.Start = Start; Invo_data.End = End; Invo_data.InvoiceRateId = InvoiceRateId; Invo_data.OtherRateId = OtherRateId; Invo_data.SupDocInvoiceRateId = SupsDocInvoiceRateId; Invo_data.SupDocOtherRateId = SupDocOtherRateId; Invo_data.AttachSheetId = AttachSheetId; Invo_data.SupportingDocStatus = SDoc_Status; Invo_data.StartDate = S; Invo_data.EndDate = E; decimal Cost_Certificate = 0; decimal Cost_SupprotDoc = 0; decimal BeforTax_Total = 0; /*start get Certificate Data*/ decimal TaxCount = 0; decimal AfterTax_Total = 0; string Is_SVat = string.Empty; string checkTaxInvoice = "N"; foreach (var requst in objInv.getInvoiceDetail_Certs(Certi_Status, Start, End, C, CertificateRateId)) { Cost_Certificate += requst.Rate_; // Calculate Certificate cost befor tax Is_SVat = requst.Is_SVAT; } /*start get Suporting Document Data*/ foreach (var supporting in objSDApp.getSuuportingDocumentApproval(Invo_data)) { Cost_SupprotDoc += supporting.Rate_; } BeforTax_Total = Cost_Certificate + Cost_SupprotDoc;//get gross total=Total Certificate value+total Supproting Document Value AfterTax_Total = BeforTax_Total; Invo_data.GrossTotal = BeforTax_Total; if (Is_SVat.Equals("Y")) { foreach (var money in objInv.getTaxDetails("Y", "Y")) { decimal presentage = money.RateValue; TaxCount = presentage * AfterTax_Total / 100; AfterTax_Total += TaxCount; checkTaxInvoice = "Y"; } } else { foreach (var money in objInv.getTaxDetails("Y", VATCode)) { decimal presentage = money.RateValue; TaxCount = presentage * AfterTax_Total / 100; AfterTax_Total += TaxCount; checkTaxInvoice = "Y"; } } Invo_data.InvoiceTotal = AfterTax_Total; Invo_data.IsTaxInvoice = checkTaxInvoice; Invo_data.PrintCount = 0; Invo_data.Createdby = "Admin"; string Invoice_No = objInv.setInvoiceHeader(Invo_data); /*end get Suporting Document Data*/ M_InvoiceData objInde = new M_InvoiceData(); /*start set Value for Invoice detail Table*/ foreach (var requst in objInv.getInvoiceDetail_Certs(Certi_Status, Start, End, Invo_data.CustomerId, CertificateRateId)) { /*---------------insert value to detail table------------------*/ objInde.RequestId = requst.Request_Id; objInde.invoiceNo = Invoice_No; objInde.Rate = requst.Rate_; objInde.Createdby = "Admin"; objInv.setInvoiceDetails(objInde); } /*end set Value for Invoice detail Table*/ foreach (var supporting in objSDApp.getSuuportingDocumentApproval(Invo_data)) { string RateId = supporting.Rate_Id; // string SuportingId = supporting.SupportingDocument_Id; M_SupportDocument CRH = new M_SupportDocument(); CRH.ClientID_ = Invo_data.CustomerId; CRH.Invoice_No = Invoice_No; CRH.Request_ID = supporting.Request_ID; CRH.Rate_Id = RateId; CRH.Rate_ = supporting.Rate_; CRH.Created_By = "Admin"; objInv.setInvoiceRate(CRH); /*end to set Invoice rate Table*/ } decimal TaxCounts = 0; decimal NetTotal = BeforTax_Total; if (Is_SVat.Equals("Y")) { foreach (var money in objInv.getTaxDetails("Y", "Y")) { /*---------------------insert value to invoice tax------------------*/ decimal presentage = money.RateValue; TaxCounts = presentage * BeforTax_Total / 100; NetTotal = NetTotal + TaxCounts; M_TaxNRates taxdeta = new M_TaxNRates(); taxdeta.InvoiceId = Invoice_No; taxdeta.RateID = money.RateID; taxdeta.RateValue = TaxCounts; taxdeta.CreatedBy = "Admin"; taxdeta.TaxPresentage = presentage; objInv.setInvoiceTaxDetails(taxdeta); } } else { foreach (var money in objInv.getTaxDetails("Y", VATCode)) { /*---------------------insert value to invoice tax------------------*/ decimal presentage = money.RateValue; TaxCounts = presentage * BeforTax_Total / 100; NetTotal = NetTotal + TaxCounts; M_TaxNRates taxdeta = new M_TaxNRates(); taxdeta.InvoiceId = Invoice_No; taxdeta.RateID = money.RateID; taxdeta.RateValue = TaxCounts; taxdeta.CreatedBy = "Admin"; taxdeta.TaxPresentage = presentage; objInv.setInvoiceTaxDetails(taxdeta); } } return(RedirectToAction("InvoiceView", new { Invo = Invoice_No })); }