public M_ProductOwner Owner_getCompanyDetails()
{
try
{
M_ProductOwner details = new M_ProductOwner();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getOwnerCompanyResult> lst = datacontext._getOwnerCompany();
foreach (_getOwnerCompanyResult result in lst)
{
details.Organization = result.OrganizationName;
details.PO_BOX = result.PostBox;
details.Address1 = result.Address1;
details.Address2 = result.Address2;
details.Address3 = result.Address3;
}
}
return(details);
}
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_ExportSector> ExportS_getExportSection(string IsActive)
{
try
{
List <M_ExportSector> lstGroup = new List <M_ExportSector>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getExportSectorResult> lst = datacontext._getExportSector(IsActive);
foreach (_getExportSectorResult result in lst)
{
M_ExportSector grp = new M_ExportSector();
grp.ExportSectorId = Convert.ToInt32(result.ExportId);
grp.ExportSectorName = result.ExportSector;
grp.IsActive = result.Status;
lstGroup.Add(grp);
}
}
return(lstGroup);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_Reject> RejectR_getRejectReasons(string RCategory, string IsActive)
{
try
{
List <M_Reject> lstR = new List <M_Reject>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getRejectReasons_ListResult> lst = datacontext._getRejectReasons_List(RCategory, IsActive);
foreach (_getRejectReasons_ListResult result in lst)
{
M_Reject R = new M_Reject();
R.Reject_ReasonCategory = result.Category;
R.Reject_ReasonName = result.ReasonName;
R.Reject_ReasonId = result.RejectCode;
R.Createdby = result.CreatedBy;
R.CreatedDate = Convert.ToDateTime(result.CreatedDate);
lstR.Add(R);
}
}
return(lstR);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public M_ProductOwner Owner_getContactPerson()
{
try
{
M_ProductOwner details = new M_ProductOwner();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getOwnerContactResult> lst = datacontext._getOwnerContact();
foreach (_getOwnerContactResult result in lst)
{
details.Contact_Person = result.Name;
details.Telephone_ = result.TelephoneNo;
details.Fax_ = result.FaxNo;
details.Email_ = result.Email;
details.Web_ = result.WebAddress;
}
}
return(details);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
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_Customer> getCustomerClients(string PCID)
{
try
{
List <M_Customer> lstSD = new List <M_Customer>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <getCustomerClientListResult> lst = datacontext.getCustomerClientList(PCID);
foreach (getCustomerClientListResult result in lst)
{
M_Customer SD = new M_Customer();
SD.TemplateId = result.TemplateId;
SD.Customer_Name = result.CustomerName;
SD.ClientId = result.CustomerId;
lstSD.Add(SD);
}
}
return(lstSD);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_ExportSector> getAllExportSector(string status)
{
try
{
List <M_ExportSector> Requests = new List <M_ExportSector>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllExportSectorResult> lst = datacontext._getAllExportSector(status);
foreach (_getAllExportSectorResult result in lst)
{
M_ExportSector req = new M_ExportSector();
req.ExportSectorId = result.ExportId;
req.ExportSectorName = result.ExportSector;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_UGroup> _getUserGroups()
{
try
{
List <M_UGroup> list = new List <M_UGroup>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getUserGroupsResult> ckuser = datacontext._getUserGroups();
foreach (_getUserGroupsResult result in ckuser)
{
M_UGroup s = new M_UGroup();
s.GroupId = result.GroupId;
s.GroupName = result.GroupName;
list.Add(s);
}
}
return(list);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_CertificateRefferance> getRefferenceCRequest(string PCID)
{
try
{
List <M_CertificateRefferance> lstSD = new List <M_CertificateRefferance>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <getCustomerConsigneesReffResult> lst = datacontext.getCustomerConsigneesReff(PCID);
foreach (getCustomerConsigneesReffResult result in lst)
{
M_CertificateRefferance SD = new M_CertificateRefferance();
SD.Consignee = result.Consignee;
SD.RequestId = result.RequestId;
SD.TemplateName = result.TemplateName;
SD.SeqNo = result.SeqNo;
lstSD.Add(SD);
}
}
return(lstSD);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_SupportDocumentUpload> getPendingSDRequests(string ClientId, string Status, string Parent)
{
try
{
List <M_SupportDocumentUpload> lstSD = new List <M_SupportDocumentUpload>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getPendingSDocApprovalsResult> lst = datacontext._getPendingSDocApprovals(Status, ClientId, Parent);
foreach (_getPendingSDocApprovalsResult result in lst)
{
M_SupportDocumentUpload SD = new M_SupportDocumentUpload();
SD.RequestRefNo = result.RequestID;
SD.SupportingDocumentID = result.SupportingDocID;
SD.DocumentName = result.SupportingDocumentName;
SD.ClientId = result.CustomerID + " : " + result.CustomerName;
SD.UploadedDate = result.RequestDate.Value.ToString("dd/MMM/yyyy");
SD.UploadedBy = result.RequestBy;
SD.ParentId = result.ParentName;
SD.UploadedPath = result.UploadPath;
SD.DocumentTitle = result.UploadDocName;
lstSD.Add(SD);
}
}
return(lstSD);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
//CertificateManager CM;
//CustometTaxDetailManager tax;
//InvoiceDetailSavingManager InvoicesaveManager;
//InvoiceDetailSaving invoice;
public List <M_InvoiceDetails> getAllInvoice(string Start, string End, string Status, string ParentId)
{
try
{
List <M_InvoiceDetails> Requests = new List <M_InvoiceDetails>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllInvoiceResult> lst = datacontext._getAllInvoice(Start, End, Status, ParentId);
foreach (_getAllInvoiceResult result in lst)
{
M_InvoiceDetails req = new M_InvoiceDetails();
req.Customer_Name = result.CustomerName;
req.Customer_Id = result.CustomerId;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public ActionResult SaveTransactions(string currCode, string userId, string transactionType, string Rate, string ForeignAmount, string LocalAmount, string AvgCost, string AvgStock, string print)
{
LinqMasterDataContext mastContext = new LinqMasterDataContext();
System.Data.Linq.ISingleResult <SaveTransactionResult> ret = mastContext.SaveTransaction(userId, currCode, transactionType, Convert.ToDecimal(Rate), Convert.ToDecimal(ForeignAmount), Convert.ToDecimal(LocalAmount), Convert.ToDecimal(AvgCost), Convert.ToDouble(AvgStock));
decimal TranNo = 0;
TranNo = ret.First <SaveTransactionResult>().TranNo;
//if (ret != null && ret.Any())
//{
// foreach (var item in ret)
// {
// TranNo = item.TranNo;
// }
//}
var compDetails = mastContext.tblCompanies.FirstOrDefault();
var AdditionaValues = new { currCode = currCode, transactionType = transactionType, ForeignAmount = ForeignAmount, LocalAmount = LocalAmount, Rate = Rate, TranNo = TranNo };
if (print == "true")
{
PrintReceipt(TranNo, currCode, userId, transactionType, Rate, ForeignAmount, LocalAmount, AvgCost);
}
return(Json(new { compDetails, AdditionaValues }, JsonRequestBehavior.AllowGet));
}
public List <M_CustomerParent> getAllParents()
{
try
{
using (DBLinqDataContext dbContext = new DBLinqDataContext())
{
List <M_CustomerParent> PList = new List <M_CustomerParent>();
dbContext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getAllParentCustomersResult> lst = dbContext._getAllParentCustomers();
foreach (_getAllParentCustomersResult result in lst)
{
M_CustomerParent M = new M_CustomerParent();
M.Customer_Name = result.CustomerName;
M.Parent_Id = result.ParentCustomerId;
PList.Add(M);
}
return(PList);
}
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
// Console.WriteLine(ex.Message.ToString());
return(null);
}
}
public List <M_TaxNRates> getCustomerRates(string CustometId)
{
try
{
List <M_TaxNRates> Requests = new List <M_TaxNRates>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getChildDeafaultRatesResult> lst = datacontext._getChildDeafaultRates(CustometId);
foreach (_getChildDeafaultRatesResult result in lst)
{
M_TaxNRates req = new M_TaxNRates();
req.RateID = result.RateId;
req.RateName = result.RateName;
req.RateValue = result.RateValue;
req.CustomerID = result.CustomerId;
Requests.Add(req);
}
}
return(Requests);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public M_NCETemplate getTemplateData(string TempID, String IsActive)
{
try
{
M_NCETemplate th = new M_NCETemplate();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <DCISgetTemplateHeaderResult> lst = datacontext.DCISgetTemplateHeader(TempID, IsActive, "%");
foreach (DCISgetTemplateHeaderResult result in lst)
{
th.Template_Id = result.TemplateId;
th.Template_Name = result.TemplateName;
th.Description_ = result.Description;
th.Img_Url = result.ImgUrl;
th.Is_Active = result.IsActive;
}
}
return(th);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_Reject> getReasons(string RejectCode)
{
try
{
List <M_Reject> lstreason = new List <M_Reject>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getRejectReasonsResult> lst = datacontext._getRejectReasons(RejectCode);
foreach (_getRejectReasonsResult result in lst)
{
M_Reject r = new M_Reject();
r.Reject_ReasonId = result.RejectCode;
r.Reject_ReasonName = result.ReasonName;
lstreason.Add(r);
}
}
return(lstreason);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public bool checkUserName(string UserName)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getUserNameResult> ckuser = datacontext._getUserName(UserName);
foreach (_getUserNameResult result in ckuser)
{
if (result.UserID.Equals(UserName))
{
return(true);
}
else
{
return(false);
}
}
}
return(false);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(true);
}
}
public bool checkAuthorization(string UserGroupId, string FunctionId)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getUserGroupFunctionResult> ckuser = datacontext._getUserGroupFunction(FunctionId, UserGroupId);
foreach (_getUserGroupFunctionResult result in ckuser)
{
if (result.GroupId.Equals(UserGroupId))
{
return(true);
}
else
{
return(false);
}
}
}
return(false);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(true);
}
}
public List <M_SupportDocumentUpload> getSupportingDOCfRequest(string ID)
{
try
{
List <M_SupportDocumentUpload> DocList = new List <M_SupportDocumentUpload>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getCRequestSupportingDOCResult> lst = datacontext._getCRequestSupportingDOC(ID);
foreach (_getCRequestSupportingDOCResult result in lst)
{
M_SupportDocumentUpload SUP = new M_SupportDocumentUpload();
SUP.SupportingDocumentID = result.SupportingDocumentId;
SUP.Remarks = result.Remarks;
SUP.RequestRefNo = result.RequestRefNo;
SUP.UploadedBy = result.UploadedBy;
SUP.UploadedPath = result.UploadedPath;
SUP.DocumentName = result.DocumentName;
SUP.Seq_No = result.UploadSeqNo;
SUP.DocumentTitle = result.SupportingDocumentName;
SUP.UploadedDate = result.RequestDate.ToString();
SUP.SignatureRequired = Convert.ToBoolean(result.SignatureRequired);
DocList.Add(SUP);
}
}
return(DocList);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public M_Users _getUserInfo(string UId)
{
try
{
M_Users s = new M_Users();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getUserInfoResult> ckuser = datacontext._getUserInfo(UId);
foreach (_getUserInfoResult result in ckuser)
{
s.Designation = result.Designation;
s.UserName = result.PersonName;
s.UserId = result.UserID;
s.IsActive = result.IsActive;
s.Email = result.Email;
s.UserGroup = result.UserGroupID;
}
}
return(s);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
private void LoadGrdNhan()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int strMadviqly = int.Parse(session.User.ma_dviqly);
//List<CBDN.db_DSDiemNhanNVXacNhanResult> lstNhan = new List<CBDN.db_DSDiemNhanNVXacNhanResult>();
System.Data.Linq.ISingleResult <CBDN.db_DSDiemNhanNVXacNhanResult> lstNhan = null;
System.Data.Linq.ISingleResult <CBDN.db_DSDiemGiaoNVXacNhanResult> lstGiao = null;
if (cmbPhuongThuc.Value != null)
{
lstNhan = db.db_DSDiemNhanNVXacNhan(strMadviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), int.Parse(cmbPhuongThuc.Value + ""));
lstGiao = db.db_DSDiemGiaoNVXacNhan(strMadviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), int.Parse(cmbPhuongThuc.Value + ""));
}
else
{
lstNhan = db.db_DSDiemNhanNVXacNhan(strMadviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), 0);
lstGiao = db.db_DSDiemGiaoNVXacNhan(strMadviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), 0);
}
grdNhan.DataSource = lstNhan;
grdNhan.DataBind();
grdGiao.DataSource = lstGiao;
grdGiao.DataBind();
grdSanLuonghan.DataSource = lstNhan;
grdSanLuonghan.DataBind();
grdSLGiao.DataSource = lstGiao;
grdSLGiao.DataBind();
}
public List <M_Users> getBackEndUsers()
{
try
{
List <M_Users> lstUser = new List <M_Users>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getBackendSystemUsersResult> lst = datacontext._getBackendSystemUsers();
foreach (_getBackendSystemUsersResult result in lst)
{
M_Users usr = new M_Users();
usr.UserId = result.UserID;
usr.UserGroup = result.UserGroupID;
usr.UserName = result.PersonName;
usr.IsActive = result.IsActive;
usr.Email = result.Email;
usr.Designation = result.Designation;
lstUser.Add(usr);
}
}
return(lstUser);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_Signatory> _getSignatoryUser()
{
try
{
List <M_Signatory> list = new List <M_Signatory>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getSignatoryUsersResult> ckuser = datacontext._getSignatoryUsers(Group_Singatory);
foreach (_getSignatoryUsersResult result in ckuser)
{
M_Signatory s = new M_Signatory();
s.UserId = result.UserID;
s.UserName = result.PersonName;
list.Add(s);
}
}
return(list);
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_TaxNRates> getTaxDetails(string IsActive, string IsVat)
{
try
{
List <M_TaxNRates> taxdetail = new List <M_TaxNRates>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getTaxDetailsResult> lst = datacontext._getTaxDetails(IsActive, IsVat);
foreach (_getTaxDetailsResult result in lst)
{
M_TaxNRates tax = new M_TaxNRates();
tax.RateName = result.TaxName;
tax.RateValue = result.TaxPercentage;
tax.RateID = result.TaxCode;
tax.Priority = Convert.ToInt32(result.TaxPriority);
taxdetail.Add(tax);
}
}
return(taxdetail);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public List <M_CDownload> getCertificateDownload(string RequestId,
string CustID,
string certID, string seal, string invoiceNo, string ParentId)
{
try
{
List <M_CDownload> lstpackage = new List <M_CDownload>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getDownloadCertificateResult> lst = datacontext._getDownloadCertificate(RequestId,
CustID,
certID,
seal,
invoiceNo,
ParentId);
foreach (_getDownloadCertificateResult result in lst)
{
M_CDownload cd = new M_CDownload();
if (result.SealRequired == "True")
{
cd.IsStamped = "Yes";
}
else
{
cd.IsStamped = "No";
}
cd.IsDownloaded = result.IsDownloaded;
cd.RequestBy = result.CreatedBy;
cd.RefNo = result.CertificateId;
cd.CertPath = result.CertificatePath;
cd.IsDownloaded = result.IsDownloaded;
cd.IsPrinted = result.IsDownloaded;
cd.RequestID = result.RequestId;
cd.ClientName = result.CustomerName;
cd.ReqType = result.Ctype;
cd.ApproveDate = result.CreatedDate.ToString("dd/MMM/yy");
cd.RequestDate = result.RequestDate.ToString("dd/MMM/yy");
cd.InvoiceNo = result.InvoiceNo;
cd.ApprovedBy = result.created;
cd.ParentN = result.ParentName;
cd.CertPath = result.CertificatePath;
lstpackage.Add(cd);
}
}
return(lstpackage);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
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 M_Customer get_ChildCustomerDetails(string ClientId)
{
try
{
M_Customer req = new M_Customer();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <_getClientCustomerDetailsResult> lst = datacontext._getClientCustomerDetails(ClientId);
foreach (_getClientCustomerDetailsResult r in lst)
{
req.Address1 = r.Address1;
req.Address2 = r.Address2;
req.Address3 = r.Address3;
req.ContactPersonDesignation = r.ContactPersonDesignation;
req.ContactPersonDirectPhone = r.ContactPersonDirectPhoneNumber;
req.ContactPersonEmail = r.ContactPersonEmail;
req.ContactPersonMobile = r.ContactPersonMobile;
req.ContactPersonName = r.ContactPersonName;
req.CreatedDate = Convert.ToDateTime(r.CreatedDate);
req.Customer_Name = r.CustomerName; // Child Customer
req.Email = r.Email;
req.Fax = r.Fax;
req.Request_Id = r.RequestId;
req.Telephone = r.Telephone;
req.IsNCEMember = r.NCEMember;
req.IsVat = r.IsSVat;
req.ProductDetails = r.Productdetails;
req.ExportSectorId = Convert.ToInt32(r.ExportSector);
req.ExportSector = r.ExportSectorName;
req.TemplateId = r.TemplateId;
req.Parent_Id = r.ParentCustomerId;
req.ClientId = ClientId;
}
}
return(req);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
public M_Login getUserLogin(M_Login Usr)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
M_Login usr = new M_Login();
string pass = Encrypt_Decrypt.Encrypt(Usr.Password_, Password);
System.Data.Linq.ISingleResult <_getUserloginResult> loggedUser = datacontext._getUserlogin(Usr.User_ID, pass);
foreach (_getUserloginResult result in loggedUser)
{
if (result.UserId.Equals(Usr.User_ID) && result.Password.Equals(pass))
{
usr.User_ID = result.UserId;
usr.UserGroup_ID = result.UserGroupID;
usr.Is_Active = result.IsActive;
// usr.Is_Vat = result.IsVat;
usr.PassowordExpiry_Date = result.PassowordExpiryDate.ToString();
usr.Person_Name = result.PersonName;
usr.Customer_ID = result.ParentCustomerId;
if (usr.Is_Active == "N")
{
return(null);
}
else
{
return(usr);
}
}
}
return(null);
}
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
private List <M_Parameters> getEmailSendParamters()
{
try
{
List <M_Parameters> ParaList = new List <M_Parameters>();
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
System.Data.Linq.ISingleResult <DCISgeMailParametersResult> lst = datacontext.DCISgeMailParameters();
foreach (DCISgeMailParametersResult result in lst)
{
M_Parameters Para = new M_Parameters(result.ParameterCode, result.ParameterValue);
ParaList.Add(Para);
}
}
return(ParaList);
}
catch (Exception ex)
{
ErrorLog.LogError(ex);
return(null);
}
}
