public JsonResult Cancel_Doc(M_CancelDocument Model)
{
Model.CanceledBy = _session.User_Id;
Model.InvoicNo = "SDID1";// should come from the app config InvoiceID for Invoice
bool re = objCncl.setCertificateCancelation(Model);
//var result = new { Msg = output, CID = ID };
return(Json(re, JsonRequestBehavior.AllowGet));
}
public List <M_CancelDocument> getCancelCertificate(string start, string end, string cutomerId, string refNo)
{
try
{
List <M_CancelDocument> DocList = new List <M_CancelDocument>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
string doc = null;
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getCanceleCertificateResult> lst = datacontext._getCanceleCertificate(start, end, cutomerId, refNo);
foreach (_getCanceleCertificateResult result in lst)
{
M_CancelDocument SRH = new M_CancelDocument();
SRH.Ref_No = result.DocumentId;
SRH.Client = result.CustomerName;
SRH.Remark = result.Remark;
SRH.CanceledBy = result.CancelBy;
doc = result.DocumentType;
if (doc == "C")
{
SRH.Dtype = "Certificate";
}
else if (doc == "O")
{
SRH.Dtype = "Other Document";
}
else if (doc == "I")
{
SRH.Dtype = "Invoice";
}
SRH.Canceled_Date = result.CancelDate.ToString("dd/MMM/yyyy");
SRH.Parent = result.Parent;
DocList.Add(SRH);
}
}
return(DocList);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
Console.WriteLine(ex.Message.ToString());
return(null);
}
}
public List <M_CancelDocument> getDocumentCancelList(string CustomerId,
string Status, string fromdate, string todate, string InvoiceSupDocId, string refNo)
{
try
{
List <M_CancelDocument> DocList = new List <M_CancelDocument>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllCertificateCancelDetailsResult> lst = datacontext._getAllCertificateCancelDetails(CustomerId,
Status, fromdate, todate, InvoiceSupDocId, refNo);
foreach (_getAllCertificateCancelDetailsResult result in lst)
{
M_CancelDocument SRH = new M_CancelDocument();
SRH.Client = result.CustomerName;
SRH.ApprovedDate = result.Approve_Date.Value.ToString("dd/MMM/yyyy");
SRH.Dtype = result.docTypes;
SRH.Ref_No = result.Ref_;
SRH.InvoicNo = result.Invoice;
SRH.Parent = result.Parent;
SRH.ApprovedBy = result.Approved_by;
SRH.IsDownloaded = result.IsDownloaded;
SRH.Path = result.Path_;
SRH.RequestId = result.Req_id;
SRH.ClientId = result.CustomerId;
DocList.Add(SRH);
}
}
return(DocList);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
