public string SetChildCustomerRequest(M_Customer pr)
{
try
{
string PCRequesNo = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("CustomerRequestNo", dbContext);
PCRequesNo = "CCRN" + RequestNo.ToString();
dbContext._setParentChildCustomerRequest(PCRequesNo,
pr.Customer_Name,
pr.Telephone,
pr.Email,
pr.Fax,
"P",
pr.Address1,
pr.Address2,
pr.Address3,
pr.CreatedBy,// User Session Parent User ID Here
pr.IsVat,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.IsNCEMember,
pr.Parent_Id, // User Session Parent Customer ID Here
pr.ProductDetails,
pr.ExportSectorId);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(PCRequesNo);
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string setInvoiceHeader(M_InvoiceData req)
{
// InvoiceDetailSaving Check = new InvoiceDetailSaving();
string RequestId = req.RequestId;
try
{
string InvoiceNo = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
if (req.GrossTotal != 0)
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence seqmanager = new B_RecordSequence();
Int64 RequestNo = seqmanager.getNextSequence("InvoiceNo", dbContext);
InvoiceNo = "STM" + DateTime.Now.ToString("yy") + String.Format("{0:D9}", RequestNo);
dbContext._setInvoiceHeader(InvoiceNo,
req.CustomerId,
req.StartDate,
req.EndDate,
req.GrossTotal,
req.InvoiceTotal,
req.IsTaxInvoice,
req.Createdby,
req.PrintCount);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
}
}
catch (Exception ex)
{
dbContext.Transaction.Rollback();
ErrorLog.LogError(ex);
}
return(InvoiceNo);
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(string.Empty);
}
}
public string setSupportingDocSignRequestINCertRequest(M_SupportDocumentUpload hdr)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext.Connection.Open();
try
{
B_RecordSequence seqmanager = new B_RecordSequence();
datacontext.Transaction = datacontext.Connection.BeginTransaction();
long No = Convert.ToInt64(seqmanager.getNextSequence("SupportingDocSignRq"));
if (No == 0)
{
return(null);
}
string Doc_No = "SDR" + No.ToString();
datacontext._setSupportingDocApproveFrmCRquest(Doc_No,
hdr.SupportingDocumentID,
hdr.ClientId,
hdr.UploadedBy,
hdr.Status,
hdr.UploadedPath,
hdr.DocumentName,
hdr.ApprovedBy,
Convert.ToDateTime(hdr.UploadedDate),
hdr.CertifiedDocPathe,
Convert.ToDateTime(hdr.ExpiredOn),
hdr.RequestRefNo);
datacontext.SubmitChanges();
datacontext.Transaction.Commit();
return(Doc_No);
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
datacontext.Transaction.Rollback();
return(null);
}
finally
{
datacontext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string setUploadBasedCertificateRequest(M_Cerificate EmR, string Filename)
{
try
{
string certificatereqno = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("CertificateRequestNo", dbContext);
certificatereqno = "CRN" + RequestNo.ToString();
dbContext._setUploadBasedCRequests(certificatereqno,
EmR.Client_Id,
"P",
EmR.Createdby,
EmR.CertificateUploadPath + certificatereqno + "/" + Filename,
EmR.InvoiceNo,
EmR.SealRequired.ToString());
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(certificatereqno);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string setSupportingDocSignRequest(M_SupportDocumentUpload Model)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
datacontext.Connection.Open();
try
{
B_RecordSequence seqmanager = new B_RecordSequence();
datacontext.Transaction = datacontext.Connection.BeginTransaction();
string Doc_No = "SDR" + seqmanager.getNextSequence("SupportingDocSignRq", datacontext);
datacontext._setSupportingDocApproveRequest(Doc_No,
Model.SupportingDocumentID,
Model.ClientId,
Model.UploadedBy,
Model.Status,
Model.UploadedPath + "/" + Doc_No + "/" + Model.DocumentName,
Model.DocumentName);
datacontext.SubmitChanges();
datacontext.Transaction.Commit();
return(Doc_No);
}
catch (Exception Ex)
{
ErrorLog.LogError(Ex);
datacontext.Transaction.Rollback();
return(null);
}
finally
{
datacontext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public bool RejectR_NewRejectReason(M_Reject sd)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
B_RecordSequence seqmanager = new B_RecordSequence();
Int64 rr = seqmanager.getNextSequence("RejectCode", datacontext);
string rrc = "RRC" + rr.ToString();
datacontext._setNewRejectReason(rrc, sd.Reject_ReasonCategory, sd.Reject_ReasonName, sd.Createdby, "Y");
datacontext.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(false);
}
}
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 string SetApproveClientCustomerRequest(M_CustomerRequest pr)
{
try
{
string ChildCID = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence ChildID = new B_RecordSequence();
Int64 RequestNo = ChildID.getNextSequence("CustomerID", dbContext);
ChildCID = "CC" + RequestNo.ToString();
dbContext._setApproveChildCustomer(pr.Request_Id,
pr.Parent_CustomerId,
ChildCID,
pr.Customer_Name,
pr.Telephone,
pr.Email,
pr.Fax,
"A",
pr.Address1,
pr.Address2,
pr.Address3,
"ADMIN",
pr.IsVat,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.IsNCEMember,
pr.ProductDetails,
pr.ExportSectorId.ToString(),
pr.Template_ID);
dbContext._setUpdateClientCustomerReq("A", pr.Request_Id);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
//MailSender Mail = new MailSender();
//Mail.SendEmail(pr.ContactPersonEmail, "NCE Client Customer Registration Approval", Parent_Approved + " Your Client Customer Code is : " + ParentCID, " ");
return(ChildCID);
//Email Send function needed
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string SetCustomerParentRequest(M_CustomerParentRequest pr)
{
try
{
string PRequesNo = string.Empty;
string EncriptPass = Encrypt_Decrypt.Encrypt(pr.Admin_Password, Password);
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("ParentRequestNo", dbContext);
PRequesNo = "PCRN" + RequestNo.ToString();
dbContext.DCISsetParentCustomerRequest(PRequesNo,
pr.Customer_Name,
pr.Telephone,
pr.Email,
pr.Fax,
"P",
pr.Address1,
pr.Address2,
pr.Address3,
"",
pr.IsVat,
pr.Admin_UserId,
EncriptPass,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.IsNCEMember,
pr.Admin_Name);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(PRequesNo);
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string SetApproveCustomerParentRequest(M_CustomerParentRequest pr, string createdby)
{
try
{
string ParentCID = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("ParentCustomerId", dbContext);
ParentCID = "PC" + RequestNo.ToString();
dbContext.DCISsetApproveParentCustomer(pr.Request_Id,
ParentCID,
pr.Customer_Name,
pr.Telephone,
pr.Email,
pr.Fax,
"A",
pr.Address1,
pr.Address2,
pr.Address3,
createdby,
pr.IsVat,
pr.ContactPersonName,
pr.ContactPersonDesignation,
pr.ContactPersonDirectPhone,
pr.ContactPersonMobile,
pr.ContactPersonEmail,
pr.IsNCEMember);
dbContext.DCISsetUpdateParentCustomerReq("A", pr.Request_Id);
dbContext.DCISsetApprovedPCUser(pr.Admin_UserId, pr.Admin_Name, pr.Admin_Password, ParentCID);
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
MailSender Mail = new MailSender();
Mail.SendEmail(pr.ContactPersonEmail, "NCE Registration Approval", Parent_Approved + " Your Customer Code is : " + ParentCID, " ");
return(ParentCID);
//Email Send function needed
}
catch (Exception ex)
{
ErrorLog.LogError("B_Customer", ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public string setCertificateRequest(M_Cerificate hdr)
{
try
{
string certificatereqno = string.Empty;
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
dbContext.Connection.ConnectionString = Connection_;
dbContext.Connection.Open();
try
{
dbContext.Transaction = dbContext.Connection.BeginTransaction();
B_RecordSequence CParentId = new B_RecordSequence();
Int64 RequestNo = CParentId.getNextSequence("CertificateRequestNo", dbContext);
certificatereqno = "CRN" + RequestNo.ToString();
dbContext._setCertifcateRequestHeader(certificatereqno,
hdr.TemplateId,
hdr.Client_Id,
hdr.Createdby,
hdr.Status,
hdr.Consignor_Exporter,
hdr.Consignee,
hdr.InvoiceNo,
Convert.ToDateTime(hdr.InvoiceDate),
hdr.CountyOfOrigin,
hdr.PortOfLoading,
hdr.PortOfDischarge,
hdr.Vessel,
hdr.PlaceOfDelivery,
hdr.TotalInvoiceValue,
hdr.TotalQuantity,
hdr.OtherComments,
hdr.Remarks,
hdr.SealRequired.ToString());
dbContext._setCertificateRequestDetails(certificatereqno,
hdr.Goods_Item,
hdr.ShippingMarks,
hdr.PackageType,
hdr.SummaryDescription,
hdr.QtyNUnit,
hdr.HSCode,
hdr.Createdby);
if (hdr.AddAsReff)
{
dbContext._setReffrennceRequest(hdr.Consignee, hdr.Client_Id, certificatereqno, hdr.ParentId, hdr.CTemplateName);
}
dbContext.SubmitChanges();
dbContext.Transaction.Commit();
return(certificatereqno);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
dbContext.Transaction.Rollback();
return(null);
}
finally
{
dbContext.Connection.Close();
}
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}