/// <summary> /// Get Data From Database /// <para>Use it when to retive data through a stored procedure</para> /// </summary> public vmRecoverUser Get_CmnUserRecovery(vmRecoverUser model) { vmRecoverUser recoveredUser = null; string spQuery = string.Empty; try { if (model != null) { using (GenericFactoryFor_RecUser = new vmRecoveryUser_GF()) { Hashtable ht = new Hashtable(); ht.Add("RecoverEmail", model.RecoverEmail.Trim()); spQuery = "[Get_CmnUserRecovery]"; recoveredUser = GenericFactoryFor_RecUser.ExecuteCommandSingle(spQuery, ht); } } } catch (Exception e) { e.ToString(); } return(recoveredUser); }
/// <summary> /// Get Data From Database /// <para>Use it when to retive data through a stored procedure</para> /// </summary> public vmAuthenticatedUser Get_CmnUserAuthentication(vmLoginUser model) { vmAuthenticatedUser objAuthUser = null; string spQuery = string.Empty; try { if (model != null) { using (GenericFactoryFor_AuthUser = new vmAuthenticatedUser_GF()) { Hashtable ht = new Hashtable(); ht.Add("UserLogin", model.UserLogin.Trim()); ht.Add("Password", model.Password.Trim()); spQuery = "[Get_CmnUserAuthentication]"; objAuthUser = GenericFactoryFor_AuthUser.ExecuteCommandSingle(spQuery, ht); } } } catch (Exception e) { e.ToString(); } return(objAuthUser); }
public vmQuotation GetQuotationMasterById(int?QuotationId, int CompanyID) { vmQuotation lstQuotation = null; GFactory_GF_Quotation = new vmQuotation_GF(); string spQuery = string.Empty; try { Hashtable ht = new Hashtable(); ht.Add("QuotationID", QuotationId); ht.Add("CompanyId", CompanyID); spQuery = "[dbo].[Get_PurchaseQuotationMaster]"; lstQuotation = GFactory_GF_Quotation.ExecuteCommandSingle(spQuery, ht); } catch (Exception e) { e.ToString(); } return(lstQuotation);; //try //{ // using (_ctxCmn = new ERP_Entities()) // { // lstQuotation = (from qcm in _ctxCmn.PurchaseQuotationMasters.Where(s => s.IsDeleted == false && s.QuotationID == QuotationId && s.CompanyID == CompanyID) // join re in _ctxCmn.InvRequisitionMasters on qcm.RequisitionID equals re.RequisitionID // join org in _ctxCmn.CmnUsers on qcm.PartyID equals org.UserID // join cm in _ctxCmn.CmnComboes on qcm.QuotationTypeID equals cm.ComboID // join curr in _ctxCmn.AccCurrencyInfoes on qcm.CurrencyID equals curr.Id // select new vmQuotation // { // RequisitionNo = re.RequisitionNo, // RequisitionID = re.RequisitionID, // QuotationID = qcm.QuotationID, // QuotationNo = qcm.QuotationNo, // QuotationDate = qcm.QuotationDate, // SPRDate = re.RequisitionDate, // DeliveryDate = qcm.DeliveryDate, // UserID = org.UserID, // UserFullName = org.UserFullName, // ComboID = cm.ComboID, // ComboName = cm.ComboName, // CurrencyID = qcm.CurrencyID, // Currency = curr.CurrencyName, // Remarks = qcm.Remarks // }); // } //} //catch (Exception ex) //{ // ex.ToString(); //} }
public vmIssueMaster GetIssueMasterByIssueId(int?IssueId, int CompanyID) { GenericFactory_GF_Issue = new vmIssueMaster_GF(); vmIssueMaster lstIssue = null; string spQuery = string.Empty; try { Hashtable ht = new Hashtable(); ht.Add("IssueId", IssueId); ht.Add("CompanyID", CompanyID); spQuery = "[dbo].[Get_InvIssueInfoByIssueId]"; lstIssue = GenericFactory_GF_Issue.ExecuteCommandSingle(spQuery, ht); } catch (Exception e) { e.ToString(); } return(lstIssue); }
/// <summary> /// Save Data To Database /// <para>Use it when save data through a stored procedure</para> /// </summary> public vmUser SaveUser(vmUser model, List <vmCompany> companyList) { vmUser result = null; try { if (model != null && model.UserGroupID > 0) { Hashtable ht = new Hashtable(); ht.Add("CompanyID", model.CompanyID); ht.Add("LoggedUser", model.LoggedUser); //Login Account ht.Add("LoginID", model.LoginID ?? null); ht.Add("Email", model.LoginEmail); ht.Add("Phone", model.LoginPhone ?? null); //User Type ht.Add("UserTypeID", model.UserTypeID); ht.Add("UserGroupID", model.UserGroupID); ht.Add("UserTitleID", model.UserTitleID); //User Info ht.Add("UserFirstName", model.UserFirstName ?? null); ht.Add("UserMiddleName", model.UserMiddleName ?? null); ht.Add("UserLastName", model.UserLastName ?? null); ht.Add("GenderID", model.GenderID); ht.Add("ReligionID", model.ReligionID); ht.Add("FathersName", model.FathersName ?? null); ht.Add("MothersName", model.MothersName ?? null); ht.Add("SpouseNane", model.SpouseNane ?? null); //User Parmanent Address ht.Add("ParAddress1", model.ParAddress1 ?? ""); ht.Add("ParAddress2", model.ParAddress2 ?? ""); ht.Add("ParCountryID", model.ParCountryID); ht.Add("ParStateID", model.ParStateID); ht.Add("ParCityID", model.ParCityID); //User Present Address ht.Add("PreAddress1", model.PreAddress1 ?? ""); ht.Add("PreAddress2", model.PreAddress2 ?? ""); ht.Add("PreCountryID", model.PreCountryID); ht.Add("PreStateID", model.PreStateID); ht.Add("PreCityID", model.PreCityID); //User Identity ht.Add("UniqueIdentity", model.UniqueIdentity); ht.Add("BloodGroup", model.BloodGroup ?? ""); ht.Add("Height", model.Height); ht.Add("DOB", model.DOB); ht.Add("PassportNO", model.PassportNO); ht.Add("NID", model.NID); ht.Add("ImageUrl", model.ImageUrl ?? ""); ht.Add("FingerUrl", model.FingerUrl ?? ""); ht.Add("SignatureUrl", model.SignatUrl ?? ""); //Open User Login Account ht.Add("IsOnlineAccount", model.IsOnlineAccount); //User Job Contract ht.Add("DesignationID", model.DesignationID); ht.Add("DepartmentID", model.DepartmentID); ht.Add("JobContractTypeID", model.JobContractTypeID); //for CmnACCIntegration ht.Add("AcDetailID", model.AcDetailID); if (model.UserID > 0) { using (GenericFactoryFor_User = new vmUser_GF()) { ht.Add("UserID", model.UserID); string spQuery = "[Put_CmnUser]"; result = GenericFactoryFor_User.ExecuteCommandSingle(spQuery, ht); if (result != null && companyList.Count > 0) { UpdateUserWiseCompany(model.UserID ?? 0, model.LoggedUser, companyList); } } } else { using (GenericFactoryFor_User = new vmUser_GF()) { string spQuery = "[Set_CmnUser]"; result = GenericFactoryFor_User.ExecuteCommandSingle(spQuery, ht); } if (result != null && companyList.Count > 0) { SaveUserWiseCompany(result.UserID ?? 0, model.LoggedUser, companyList); } } } } catch (Exception e) { e.ToString(); } return(result); }