public virtual CloudAccountDA.ContactMasterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.ContactMasterDataTable dataTable = new CloudAccountDA.ContactMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.ContactMasterDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
protected void Page_Load(object sender, EventArgs e) { this._objContactMasterDt = this._objContactMasterBll.GetAllDetail(); if (this._objContactMasterDt.Rows.Count > 0) { //string str = this._objContactMasterDt.Rows.get_Item(0).get_Item("Phone1").ToString(); string str = this._objContactMasterDt.Rows[0]["Phone1"].ToString(); string str2 = this._objContactMasterDt.Rows[0]["Email1"].ToString(); string str3 = string.Concat((string[])new string[] { "<li>Call Us Now. : <a href=\"tele:", str, "\">", str, "</a></li><li>Get In Touch. : <a href=\"mailto:", str2, "\">", str2, "</a></li>" }); this.lblContact.Text = str3; } }
private void GotoPage() { this.objContactMasterDT = this.objContactMasterBll.GetAllDetail(); if (this.objContactMasterDT.Rows.Count > 0) { this.hfContact.Value = this.objContactMasterDT.Rows[0]["ContactID"].ToString(); this.Response.Redirect("~/BillTransact/ContactMaster.aspx?cmd=add&ID=" + this.hfContact.Value); } else { this.Response.Redirect("~/BillTransact/ContactMaster.aspx?cmd=add"); } }
public virtual CloudAccountDA.ContactMasterDataTable GetDataByContactID(int?ContactID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (ContactID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = ContactID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.ContactMasterDataTable dataTable = new CloudAccountDA.ContactMasterDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
protected void Page_Load(object sender, EventArgs e) { this._objContactMasterDt = this._objContactMasterBll.GetAllDetail(); if (this._objContactMasterDt.Rows.Count > 0) { string str1 = this._objContactMasterDt.Rows[0]["Phone1"].ToString(); string str2 = this._objContactMasterDt.Rows[0]["Email1"].ToString(); } this.objFreePackageSettingsDT = this.objFreePackageSettingsBll.GetAllDetail(); if (this.objFreePackageSettingsDT.Rows.Count <= 0) { return; } this.btnSubmit.Text = "Try it Free for " + this.objFreePackageSettingsDT.Rows[0]["FreePackageDays"] + " Days"; }
private void SetRecord(string iD) { this.objContactMasterDT = this.objContactMasterBll.GetDataByContactID(int.Parse(iD)); if (this.objContactMasterDT.Rows.Count <= 0) { return; } this.hfContact.Value = this.objContactMasterDT.Rows[0]["ContactID"].ToString(); this.txtCompanyName.Text = this.objContactMasterDT.Rows[0]["CompanyName"].ToString(); this.txtContactPerson.Text = this.objContactMasterDT.Rows[0]["ContactPerson"].ToString(); this.txtAddress1.Text = this.objContactMasterDT.Rows[0]["Address1"].ToString(); this.txtAddress2.Text = this.objContactMasterDT.Rows[0]["Address2"].ToString(); this.txtAddress3.Text = this.objContactMasterDT.Rows[0]["Address3"].ToString(); this.txtAddress4.Text = this.objContactMasterDT.Rows[0]["Address4"].ToString(); this.txtZipCode.Text = this.objContactMasterDT.Rows[0]["ZipCode"].ToString(); this.txtPhone1.Text = this.objContactMasterDT.Rows[0]["Phone1"].ToString(); this.txtPhone2.Text = this.objContactMasterDT.Rows[0]["Phone2"].ToString(); this.txtMobile1.Text = this.objContactMasterDT.Rows[0]["Mobile1"].ToString(); this.txtMobile2.Text = this.objContactMasterDT.Rows[0]["Mobile2"].ToString(); this.txtFax1.Text = this.objContactMasterDT.Rows[0]["Fax1"].ToString(); this.txtFax2.Text = this.objContactMasterDT.Rows[0]["Fax2"].ToString(); this.txtEmail1.Text = this.objContactMasterDT.Rows[0]["Email1"].ToString(); this.txtEmail2.Text = this.objContactMasterDT.Rows[0]["Email2"].ToString(); this.txtWebsite.Text = this.objContactMasterDT.Rows[0]["Website"].ToString(); this.txtGoogleMapCode.Text = this.objContactMasterDT.Rows[0]["GoogleMapCode"].ToString(); this.chkStatus.Checked = this.objContactMasterDT.Rows[0]["Status"].ToString() == "True"; this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryName(this.objContactMasterDT.Rows[0]["Country"].ToString()); if (this.objCountryMasterDT.Rows.Count > 0) { this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString()); this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString(); } this.objStateMasterDT = this.objStateMasterBll.GetDataByStateName(this.objContactMasterDT.Rows[0]["State"].ToString()); if (this.objStateMasterDT.Rows.Count > 0) { this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString()); this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString(); } this.objCityMasterDT = this.objCityMasterBll.GetDataByCityName(this.objContactMasterDT.Rows[0]["City"].ToString()); if (this.objCityMasterDT.Rows.Count <= 0) { return; } this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString()); this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { this._objContactMasterDt = this._objContactMasterBll.GetAllDetail(); if (this._objContactMasterDt.Rows.Count > 0) { string str1 = this._objContactMasterDt.Rows[0]["Phone1"].ToString(); string str2 = this._objContactMasterDt.Rows[0]["Email1"].ToString(); this.lblContact.Text = "<li>Call Us Now. : <a href=\"tele:" + str1 + "\">" + str1 + "</a></li><li>Get In Touch. : <a href=\"mailto:" + str2 + "\">" + str2 + "</a></li>"; } MembershipUser user = Membership.GetUser(); if (user != null) { string str = user.ToString(); if (Roles.IsUserInRole(str, "Admin")) { this.objCompanyLoginMasterDT = this.objCompanyLoginMasterBll.GetDataByCompanyLoginName(str); if (this.objCompanyLoginMasterDT.Rows.Count > 0) { this.hfCompanyID.Value = this.objCompanyLoginMasterDT.Rows[0]["CompanyID"].ToString(); } } else if (Roles.IsUserInRole(str, "Employee")) { this.objStaffMasterDT = this.objStaffMasterBll.GetDataByStaffUserName(str); if (this.objStaffMasterDT.Rows.Count > 0) { this.hfCompanyID.Value = this.objStaffMasterDT.Rows[0]["CompanyID"].ToString(); } } } this.objCompanyPackageMasterDT = this.objCompanyPackageMasterBll.GetDataByCompanyActivePackage(int.Parse(this.hfCompanyID.Value)); if (this.objCompanyPackageMasterDT.Rows.Count <= 0) { return; } this.lblBack.Visible = (DateTime.Parse(DateTime.Parse(this.objCompanyPackageMasterDT.Rows[0]["PackageEndDate"].ToString()).ToShortDateString()) - DateTime.Parse(DateTime.UtcNow.ToShortDateString())).TotalDays > 0.0; }
public virtual int Update(CloudAccountDA.ContactMasterDataTable dataTable) { return(this.Adapter.Update(dataTable)); }