public DocumentController() { _premierBusiness = new PremierBusiness(); _docBusiness = new DocumentBusiness(); _signBusiness = new SignatureBusiness(); db = new DataProvider(); }
public void AddTemplateDefaut(int mISN = 0) { _logger.Info("---Start AddTemplateDefaut---"); try { var parameters = new Hashtable(); parameters.Add("@MemberISN", mISN); // var check = new DataProvider().ExecuteQuery("select Count(*) from Vw_DebtExt_Document where MemberISN=@LeadISN and docLastAction='2'", parameters); //if (ConvertObjectToInt(check) < 2) var check = _db.Vw_DebtExt_Document.Where(m => m.MemberISN == mISN && m.docLastAction == "2").Count(); if (check >= 2) return; var templateId = ConfigurationManager.AppSettings["TeamplateISN_CreateLead"]; var dsTemplateName = new DataProvider().ExecuteQuery("Select TemplateISN, tplName, tplFile From DebtTemplate Where TemplateISN in (" + templateId + ")"); if (dsTemplateName.Rows.Count > 0) { foreach (DataRow row in dsTemplateName.Rows) { var tempISN = row["TemplateISN"].ToString(); var templateName = row["tplName"].ToString(); var fileName = row["tplFile"].ToString(); var docISN = DocumentEdit(0, mISN, fileName, null, "1", null, null, templateName, 2, -mISN); if (docISN > 0) { var folder = GetTemplatePath(Convert.ToInt32(tempISN), null); folder = Path.Combine(ConfigurationManager.AppSettings["UploadFolder"], folder); var pathFull = Path.Combine(folder, fileName); if (System.IO.File.Exists(pathFull)) { var pathSave = Path.Combine(ConfigurationManager.AppSettings["UploadFolder"], this.GetDocumentsPath(docISN, null)); if (!Directory.Exists(pathSave)) Directory.CreateDirectory(pathSave); System.IO.File.Copy(pathFull, Path.Combine(pathSave, fileName)); } } } } _logger.Info("---End AddTemplateDefaut---"); } catch (Exception ex) { _logger.Error(ex, ex.Message); } }
public ProfileController() { _data = new DataProvider("tbone", "tbone"); }
DateTime GetLastRequest(int MemberISN) { string query = "select cvsDate from[Conversation] where ConversationISN in (select val_number from MemberExt3 where AttributeISN = 564 and MemberISN = @MemberISN)"; var dataProvider = new DataProvider(); var parameters = new Hashtable(); parameters.Add("MemberISN", MemberISN); var tb = dataProvider.ExecuteQuery(query, parameters); if(tb.Rows.Count > 0) { return Convert.ToDateTime(tb.Rows[0][0]); } return new DateTime(); }
public void GetMyProfile(int MemberISN) { var db = new PremierEntities(); //var userInfos = db.xp_debtuser_getinfo(MemberISN); //var userInfo = userInfos.FirstOrDefault(); var query = "xp_debtuser_getinfo"; var parameters = new Hashtable(); parameters.Add("MemberISN", MemberISN); var dataProvider = new DataProvider(); var rsInt = 0; var ds = dataProvider.ExecuteStoreProcedure(query, parameters, out rsInt ) ; try { this.UserName = ds.Tables[0].Rows[0]["memUserName"].ToString(); this.LastRequest = GetLastRequest(MemberISN); this.FirstName = ds.Tables[0].Rows[0]["memFirstName"].ToString(); this.LastName = ds.Tables[0].Rows[0]["memLastName"].ToString(); this.HomePhone = ds.Tables[0].Rows[0]["memHomePhone"].ToString(); this.WorkPhone = ds.Tables[0].Rows[0]["memWorkPhone"].ToString(); this.CellPhone = ds.Tables[0].Rows[0]["memPhone"].ToString(); this.FaxNumber = ds.Tables[0].Rows[0]["memFax"].ToString(); this.ClientID = ds.Tables[0].Rows[0]["memFax"].ToString(); this.Email = ds.Tables[0].Rows[0]["memEmail"].ToString(); this.DealerISN = Convert.ToInt32(ds.Tables[0].Rows[0]["DealerISN"]); var attrRow = ds.Tables[1].Select("attID = 'BestTimeOfCall'"); this.BestTimeToContact = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'MarriedStatus'"); this._Married = attrRow.Length == 0 ? -1 : Convert.ToInt32(attrRow[0]["attValue"]); this.Address = ds.Tables[0].Rows[0]["memAddress"].ToString(); this.City = ds.Tables[0].Rows[0]["memCity"].ToString(); this._State = ds.Tables[0].Rows[0]["memState"].ToString(); this.Zip = ds.Tables[0].Rows[0]["memZip"].ToString(); attrRow = ds.Tables[1].Select("attID = 'Language'"); this.Language = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoFirstName'"); this.CoFirstName = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoLastName'"); this.CoLastName = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoAddress'"); this.CoAddress = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoCity'"); this.CoCity = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoState'"); this._CoState = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoZip'"); this.CoZip = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'CoEmail'"); this.CoEmail = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'IsCoClient'"); this.IsCoClient = attrRow.Length == 0 ? string.Empty : attrRow[0]["attValue"].ToString(); attrRow = ds.Tables[1].Select("attID = 'ClientRequiredMFALogin'"); this.IsMFARequired = attrRow.Length == 0 ? true : Convert.ToBoolean(attrRow[0]["attValue"]); } catch (Exception ex) { StatusGetData = ex.ToString(); } }
public SignatureBusiness() { _data = new DataProvider(); }