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