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