//Select Constructor
public proposalchecklistpitchedroofCtl(Int32 id)
{
obj_con = new ConnectionCls();
proposalchecklistpitchedroofClass obj_pro = new proposalchecklistpitchedroofClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_pro.Proposalcheckpitchedroofid = Convert.ToInt32(dt.Rows[0]["Proposalcheckpitchedroofid"]);
obj_pro.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_pro.Iceandwatershield = Convert.ToString(dt.Rows[0]["Iceandwatershield"]);
obj_pro.Deck = Convert.ToString(dt.Rows[0]["Deck"]);
obj_pro.Noofdrains = Convert.ToInt32(dt.Rows[0]["Noofdrains"]);
obj_pro.Protrusions = Convert.ToString(dt.Rows[0]["Protrusions"]);
obj_pro.Vallerys = Convert.ToString(dt.Rows[0]["Vallerys"]);
obj_pro.Ridgecaps = Convert.ToString(dt.Rows[0]["Ridgecaps"]);
obj_pro.Asbestos = Convert.ToString(dt.Rows[0]["Asbestos"]);
obj_pro.Subroofs = Convert.ToString(dt.Rows[0]["Subroofs"]);
obj_pro.Rakingwallflashing = Convert.ToString(dt.Rows[0]["Rakingwallflashing"]);
obj_pro.Rakingwallcoping = Convert.ToString(dt.Rows[0]["Rakingwallcoping"]);
obj_pro.Railing = Convert.ToString(dt.Rows[0]["Railing"]);
obj_pro.Access = Convert.ToString(dt.Rows[0]["Access"]);
obj_pro.Chimneys = Convert.ToString(dt.Rows[0]["Chimneys"]);
obj_pro.Dumpsters = Convert.ToString(dt.Rows[0]["Dumpsters"]);
obj_pro.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_pro.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//Select Constructor
public buildingCtl(Int32 id)
{
obj_con = new ConnectionCls();
buildingClass obj_bui = new buildingClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_bui.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_bui.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]);
obj_bui.Buildingcode = Convert.ToString(dt.Rows[0]["Buildingcode"]);
obj_bui.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]);
obj_bui.Systemelementid = Convert.ToInt32(dt.Rows[0]["Systemelementid"]);
obj_bui.Systemtypeid = Convert.ToInt32(dt.Rows[0]["Systemtypeid"]);
obj_bui.Rating = Convert.ToInt32(dt.Rows[0]["Rating"]);
obj_bui.Details = Convert.ToString(dt.Rows[0]["Details"]);
obj_bui.Isdeficiencyrepair = Convert.ToBoolean(dt.Rows[0]["Isdeficiencyrepair"]);
obj_bui.Projectid = Convert.ToInt32(dt.Rows[0]["Projectid"]);
obj_bui.Servicecontractid = Convert.ToInt32(dt.Rows[0]["Servicecontractid"]);
obj_bui.Workorder = Convert.ToString(dt.Rows[0]["Workorder"]);
obj_bui.Compliance = Convert.ToString(dt.Rows[0]["Compliance"]);
obj_bui.Height = Convert.ToInt32(dt.Rows[0]["Height"]);
obj_bui.Width = Convert.ToInt32(dt.Rows[0]["Width"]);
obj_bui.Materialid = Convert.ToInt32(dt.Rows[0]["Materialid"]);
obj_bui.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_bui.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
obj_bui.Addressline1 = Convert.ToString(dt.Rows[0]["Addressline1"]);
obj_bui.Addressline2 = Convert.ToString(dt.Rows[0]["Addressline2"]);
obj_bui.Locationcity = Convert.ToString(dt.Rows[0]["Locationcity"]);
obj_bui.Stateid = Convert.ToInt32(dt.Rows[0]["Stateid"]);
obj_bui.Locationzip = Convert.ToString(dt.Rows[0]["Locationzip"]);
}
}
}
//Select Constructor
public proposalchecklistflatroofCtl(Int32 id)
{
obj_con = new ConnectionCls();
proposalchecklistflatroofClass obj_pro = new proposalchecklistflatroofClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_pro.Proposalchecklistid = Convert.ToInt32(dt.Rows[0]["Proposalchecklistid"]);
obj_pro.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_pro.Insualtion = Convert.ToString(dt.Rows[0]["Insualtion"]);
obj_pro.Deck = Convert.ToString(dt.Rows[0]["Deck"]);
obj_pro.Noofdrains = Convert.ToInt32(dt.Rows[0]["Noofdrains"]);
obj_pro.Protrusions = Convert.ToString(dt.Rows[0]["Protrusions"]);
obj_pro.Baseflashing = Convert.ToString(dt.Rows[0]["Baseflashing"]);
obj_pro.Counterflashing = Convert.ToString(dt.Rows[0]["Counterflashing"]);
obj_pro.Asbestos = Convert.ToString(dt.Rows[0]["Asbestos"]);
obj_pro.Subroofs = Convert.ToString(dt.Rows[0]["Subroofs"]);
obj_pro.Interiorparapet = Convert.ToString(dt.Rows[0]["Interiorparapet"]);
obj_pro.Coping = Convert.ToString(dt.Rows[0]["Coping"]);
obj_pro.Railings = Convert.ToString(dt.Rows[0]["Railings"]);
obj_pro.Access = Convert.ToString(dt.Rows[0]["Access"]);
obj_pro.Chimneys = Convert.ToString(dt.Rows[0]["Chimneys"]);
obj_pro.Dumpsters = Convert.ToString(dt.Rows[0]["Dumpsters"]);
obj_pro.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_pro.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//Select Constructor
public proposalchecklistexteriorwallsCtl(Int32 id)
{
obj_con = new ConnectionCls();
proposalchecklistexteriorwallsClass obj_pro = new proposalchecklistexteriorwallsClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_pro.Proposalcheckexteriorwallsid = Convert.ToInt32(dt.Rows[0]["Proposalcheckexteriorwallsid"]);
obj_pro.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_pro.Sidewalkbridge = Convert.ToString(dt.Rows[0]["Sidewalkbridge"]);
obj_pro.Scaffold = Convert.ToString(dt.Rows[0]["Scaffold"]);
obj_pro.Hoist = Convert.ToString(dt.Rows[0]["Hoist"]);
obj_pro.Noofdrops = Convert.ToInt32(dt.Rows[0]["Noofdrops"]);
obj_pro.Nooflintels = Convert.ToInt32(dt.Rows[0]["Nooflintels"]);
obj_pro.Qtycaulking = Convert.ToString(dt.Rows[0]["Qtycaulking"]);
obj_pro.Dutchmanrepairs = Convert.ToString(dt.Rows[0]["Dutchmanrepairs"]);
obj_pro.Nosillsreplacescapped = Convert.ToInt32(dt.Rows[0]["Nosillsreplacescapped"]);
obj_pro.Metalpanelreplaced = Convert.ToString(dt.Rows[0]["Metalpanelreplaced"]);
obj_pro.Stonereplacement = Convert.ToString(dt.Rows[0]["Stonereplacement"]);
obj_pro.Brickreplacement = Convert.ToString(dt.Rows[0]["Brickreplacement"]);
obj_pro.Chute = Convert.ToString(dt.Rows[0]["Chute"]);
obj_pro.Noofwythes = Convert.ToInt32(dt.Rows[0]["Noofwythes"]);
obj_pro.Dumpsters = Convert.ToString(dt.Rows[0]["Dumpsters"]);
obj_pro.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_pro.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
public void SendSMS(string id, string name, string sponserID, string mob, string pass, string email, string username, string Cust_Password, string Cust_Package)
{
try
{
string Cust_Package_amt;
//Cust_Package_amt = conCls.getScalerValue("select Product_Price from Product_chart where Product_Code ='" + Cust_Package + "'");
Cust_Package_amt = "0";
WebClient client = new WebClient();
DataSet ds = new DataSet();
ds = conCls.getdataSet("select Baseurl1,Baseurl2 from SMS_Services where Status=1");
DataTable dt = ds.Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string baseurl = dt.Rows[0][0].ToString() + mob + dt.Rows[0][1].ToString() + "Congratulations! Dear " + name + ",Thanks For Joining With Us Your userName (" + username + ") and Password: "******" - trans pws :" + pass + " with amount " + Cust_Package_amt + " for detail pls visit aps-mining.com";
Stream data = client.OpenRead(baseurl);
StreamReader reader = new StreamReader(data);
string s = reader.ReadToEnd();
data.Close();
reader.Close();
}
}
ds.Dispose();
var mailbody = new MailVerifyPopulatedBody();
string body = mailbody.PopulateBody(id, name, sponserID, mob, pass, email, username, Cust_Password);
DateTime letterdt = ConnectionCls.getIndianDateTime();
string dat = letterdt.ToShortDateString();
var toAddress = email;
string subject = "Verification Mail from aps-mining ";
MailMessage mailMsg = new MailMessage();
// To
mailMsg.To.Add(new MailAddress(email));
// From
mailMsg.From = new MailAddress("*****@*****.**", "Email Verification");
// Subject and multipart/alternative Body
mailMsg.Subject = subject;
string text = "text body";
string html = body;
mailMsg.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(text, null, MediaTypeNames.Text.Plain));
mailMsg.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(html, null, MediaTypeNames.Text.Html));
SmtpClient smtpClient1 = new SmtpClient("smtp.mailgun.org", Convert.ToInt32(587));
smtpClient1.EnableSsl = true;
System.Net.NetworkCredential credentials1 = new System.Net.NetworkCredential("*****@*****.**", "b5fe91c3d559323d663987a96d22fbcf");
smtpClient1.Credentials = credentials1;
smtpClient1.Send(mailMsg);
}
catch (Exception)
{
throw;
}
}
//Select Constructor
public materialCtl(Int32 id)
{
obj_con = new ConnectionCls();
materialClass obj_mat = new materialClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_mat.Materialid = Convert.ToInt32(dt.Rows[0]["Materialid"]);
obj_mat.Materialname = Convert.ToString(dt.Rows[0]["Materialname"]);
}
}
}
//Select Constructor
public labourCtl(Int32 id)
{
obj_con = new ConnectionCls();
labourClass obj_lab = new labourClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_lab.Labourid = Convert.ToInt32(dt.Rows[0]["Labourid"]);
obj_lab.Labourname = Convert.ToString(dt.Rows[0]["Labourname"]);
}
}
}
//Select Constructor
public institutiontypeCtl(Int32 id)
{
obj_con = new ConnectionCls();
institutiontypeClass obj_ins = new institutiontypeClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_ins.Institutiontypeid = Convert.ToInt32(dt.Rows[0]["Institutiontypeid"]);
obj_ins.Institutiontypename = Convert.ToString(dt.Rows[0]["Institutiontypename"]);
}
}
}
//Select Constructor
public buildingsystemCtl(Int32 id)
{
obj_con = new ConnectionCls();
buildingsystemClass obj_bui = new buildingsystemClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_bui.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]);
obj_bui.Buildingsystemname = Convert.ToString(dt.Rows[0]["Buildingsystemname"]);
}
}
}
//Select Constructor
public componentCtl(Int32 id)
{
obj_con = new ConnectionCls();
componentClass obj_com = new componentClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_com.Componentid = Convert.ToInt32(dt.Rows[0]["Componentid"]);
obj_com.Componentname = Convert.ToString(dt.Rows[0]["Componentname"]);
}
}
}
//Select Constructor
public jobstatusCtl(Int32 id)
{
obj_con = new ConnectionCls();
jobstatusClass obj_job = new jobstatusClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_job.Jobstatusid = Convert.ToInt32(dt.Rows[0]["Jobstatusid"]);
obj_job.Statusname = Convert.ToString(dt.Rows[0]["Statusname"]);
}
}
}
//Select Constructor
public BusinessCategoryCtl(Int32?id)
{
obj_con = new ConnectionCls();
BusinessCategoryClass obj_Bus = new BusinessCategoryClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Bus.Businesscategoryid = Convert.ToInt32(dt.Rows[0]["Businesscategoryid"]);
obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]);
obj_Bus.Categoryid = Convert.ToInt32(dt.Rows[0]["Categoryid"]);
}
}
}
//Select Constructor
public projectCtl(Int32 id)
{
obj_con = new ConnectionCls();
projectClass obj_pro = new projectClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_pro.Projectid = Convert.ToInt32(dt.Rows[0]["Projectid"]);
obj_pro.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]);
obj_pro.Projectname = Convert.ToString(dt.Rows[0]["Projectname"]);
}
}
}
//Select Constructor
public GeneralSettingsCtl(Int32?id)
{
obj_con = new ConnectionCls();
GeneralSettingsClass obj_Gen = new GeneralSettingsClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Gen.Generalsettings = Convert.ToInt32(dt.Rows[0]["Generalsettings"]);
obj_Gen.Key = Convert.ToString(dt.Rows[0]["Key"]);
obj_Gen.Descrpition = Convert.ToString(dt.Rows[0]["Descrpition"]);
}
}
}
//Select Constructor
public systemtypeCtl(Int32 id)
{
obj_con = new ConnectionCls();
systemtypeClass obj_sys = new systemtypeClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_sys.Systemelementtypeid = Convert.ToInt32(dt.Rows[0]["Systemelementtypeid"]);
obj_sys.Systemelementid = Convert.ToInt32(dt.Rows[0]["Systemelementid"]);
obj_sys.Systemelementtypename = Convert.ToString(dt.Rows[0]["Systemelementtypename"]);
}
}
}
//Select Constructor
public servicecontractCtl(Int32 id)
{
obj_con = new ConnectionCls();
servicecontractClass obj_ser = new servicecontractClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_ser.Servicecontractid = Convert.ToInt32(dt.Rows[0]["Servicecontractid"]);
obj_ser.Projectid = Convert.ToInt32(dt.Rows[0]["Projectid"]);
obj_ser.Servicecontractname = Convert.ToString(dt.Rows[0]["Servicecontractname"]);
}
}
}
//Select Constructor
public BusinessGalleryCtl(Int32?id)
{
obj_con = new ConnectionCls();
BusinessGalleryClass obj_Bus = new BusinessGalleryClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Bus.Businessgalleryid = Convert.ToInt32(dt.Rows[0]["Businessgalleryid"]);
obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]);
obj_Bus.Imagename = Convert.ToString(dt.Rows[0]["Imagename"]);
obj_Bus.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Bus.Sequence = Convert.ToInt32(dt.Rows[0]["Sequence"]);
}
}
}
//Select Constructor
public WebsiteBannerCtl(Int32?id)
{
obj_con = new ConnectionCls();
WebsiteBannerClass obj_Web = new WebsiteBannerClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Web.Websitebannerid = Convert.ToInt32(dt.Rows[0]["Websitebannerid"]);
obj_Web.Bannername = Convert.ToString(dt.Rows[0]["Bannername"]);
obj_Web.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Web.Sequence = Convert.ToInt32(dt.Rows[0]["Sequence"]);
obj_Web.Bannertextline1 = Convert.ToString(dt.Rows[0]["Bannertextline1"]);
obj_Web.Bannertextline2 = Convert.ToString(dt.Rows[0]["Bannertextline2"]);
}
}
}
//Select Constructor
public CountriesCtl(Int32?id)
{
obj_con = new ConnectionCls();
CountriesClass obj_Cou = new CountriesClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Cou.Countryid = Convert.ToInt32(dt.Rows[0]["Countryid"]);
obj_Cou.Countryname = Convert.ToString(dt.Rows[0]["Countryname"]);
obj_Cou.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Cou.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Cou.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Cou.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//Select Constructor
public usersCtl(Int32 id)
{
obj_con = new ConnectionCls();
usersClass obj_use = new usersClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_use.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_use.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_use.Password = Convert.ToString(dt.Rows[0]["Password"]);
obj_use.Devicetype = Convert.ToString(dt.Rows[0]["Devicetype"]);
obj_use.Deviceid = Convert.ToString(dt.Rows[0]["Deviceid"]);
obj_use.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
}
}
}
//Select Constructor
public locationCtl(Int32 id)
{
obj_con = new ConnectionCls();
locationClass obj_loc = new locationClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_loc.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]);
obj_loc.Clientid = Convert.ToInt32(dt.Rows[0]["Clientid"]);
obj_loc.Institutionid = Convert.ToInt32(dt.Rows[0]["Institutionid"]);
obj_loc.Building = Convert.ToString(dt.Rows[0]["Building"]);
obj_loc.Jobtypeid = Convert.ToInt32(dt.Rows[0]["Jobtypeid"]);
obj_loc.Jobstatusid = Convert.ToInt32(dt.Rows[0]["Jobstatusid"]);
obj_loc.Jobdetail = Convert.ToString(dt.Rows[0]["Jobdetail"]);
}
}
}
//Select Constructor
public LocationCtl(Int32?id)
{
obj_con = new ConnectionCls();
LocationClass obj_Loc = new LocationClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Loc.Locationid = Convert.ToInt32(dt.Rows[0]["Locationid"]);
obj_Loc.Locationname = Convert.ToString(dt.Rows[0]["Locationname"]);
obj_Loc.Locationurl = Convert.ToString(dt.Rows[0]["Locationurl"]);
obj_Loc.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Loc.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Loc.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Loc.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//Select Constructor
public ContactUsDataCtl(Int32?id)
{
obj_con = new ConnectionCls();
ContactUsDataClass obj_Con = new ContactUsDataClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Con.Contactusdataid = Convert.ToInt32(dt.Rows[0]["Contactusdataid"]);
obj_Con.Name = Convert.ToString(dt.Rows[0]["Name"]);
obj_Con.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_Con.Messagesubject = Convert.ToString(dt.Rows[0]["Messagesubject"]);
obj_Con.Detailedmessage = Convert.ToString(dt.Rows[0]["Detailedmessage"]);
obj_Con.Addeddatetime = Convert.ToDateTime(dt.Rows[0]["Addeddatetime"]);
obj_Con.Addedip = Convert.ToString(dt.Rows[0]["Addedip"]);
}
}
}
//Select Constructor
public workorderfollowupCtl(Int32 id)
{
obj_con = new ConnectionCls();
workorderfollowupClass obj_wor = new workorderfollowupClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_wor.Workorderfollowupid = Convert.ToInt32(dt.Rows[0]["Workorderfollowupid"]);
obj_wor.Workorderid = Convert.ToInt32(dt.Rows[0]["Workorderid"]);
obj_wor.Datecompleted = Convert.ToDateTime(dt.Rows[0]["Datecompleted"]);
obj_wor.Labour = Convert.ToInt32(dt.Rows[0]["Labour"]);
obj_wor.Partssuppies = Convert.ToString(dt.Rows[0]["Partssuppies"]);
obj_wor.Note = Convert.ToString(dt.Rows[0]["Note"]);
obj_wor.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_wor.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//Select Constructor
public buildingworkorderCtl(Int32 id)
{
obj_con = new ConnectionCls();
buildingworkorderClass obj_bui = new buildingworkorderClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_bui.Workorderid = Convert.ToInt32(dt.Rows[0]["Workorderid"]);
obj_bui.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_bui.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]);
obj_bui.Component = Convert.ToInt32(dt.Rows[0]["Component"]);
obj_bui.Description = Convert.ToString(dt.Rows[0]["Description"]);
obj_bui.Priority = Convert.ToString(dt.Rows[0]["Priority"]);
obj_bui.Requestor = Convert.ToString(dt.Rows[0]["Requestor"]);
obj_bui.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_bui.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
//Select Constructor
public AdminCtl(Int32?id)
{
obj_con = new ConnectionCls();
AdminClass obj_Adm = new AdminClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Adm.Adminid = Convert.ToInt32(dt.Rows[0]["Adminid"]);
obj_Adm.Name = Convert.ToString(dt.Rows[0]["Name"]);
obj_Adm.Username = Convert.ToString(dt.Rows[0]["Username"]);
obj_Adm.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_Adm.Password = Convert.ToString(dt.Rows[0]["Password"]);
obj_Adm.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Adm.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Adm.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Adm.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//Select Constructor
public CategoriesCtl(Int32?id)
{
obj_con = new ConnectionCls();
CategoriesClass obj_Cat = new CategoriesClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Cat.Categoryid = Convert.ToInt32(dt.Rows[0]["Categoryid"]);
obj_Cat.Categoryname = Convert.ToString(dt.Rows[0]["Categoryname"]);
obj_Cat.Parentcategoryid = Convert.ToInt32(dt.Rows[0]["Parentcategoryid"]);
obj_Cat.Categoryurl = Convert.ToString(dt.Rows[0]["Categoryurl"]);
obj_Cat.Isfeaturedcategory = Convert.ToBoolean(dt.Rows[0]["Isfeaturedcategory"]);
obj_Cat.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Cat.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
obj_Cat.Createdon = Convert.ToDateTime(dt.Rows[0]["Createdon"]);
obj_Cat.Deletedon = Convert.ToDateTime(dt.Rows[0]["Deletedon"]);
}
}
}
//Select Constructor
public clientCtl(Int32 id)
{
obj_con = new ConnectionCls();
clientClass obj_cli = new clientClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_cli.Clientid = Convert.ToInt32(dt.Rows[0]["Clientid"]);
obj_cli.Clientname = Convert.ToString(dt.Rows[0]["Clientname"]);
obj_cli.Clientcode = Convert.ToString(dt.Rows[0]["Clientcode"]);
obj_cli.Clientshortname = Convert.ToString(dt.Rows[0]["Clientshortname"]);
obj_cli.Addressline1 = Convert.ToString(dt.Rows[0]["Addressline1"]);
obj_cli.Addressline2 = Convert.ToString(dt.Rows[0]["Addressline2"]);
obj_cli.Locationcity = Convert.ToString(dt.Rows[0]["Locationcity"]);
obj_cli.Stateid = Convert.ToInt32(dt.Rows[0]["Stateid"]);
obj_cli.Locationzip = Convert.ToString(dt.Rows[0]["Locationzip"]);
obj_cli.Budgetstartmonth = Convert.ToInt32(dt.Rows[0]["Budgetstartmonth"]);
}
}
}
//Select Constructor
public BusinessReviewCtl(Int32?id)
{
obj_con = new ConnectionCls();
BusinessReviewClass obj_Bus = new BusinessReviewClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_Bus.Businessreviewid = Convert.ToInt32(dt.Rows[0]["Businessreviewid"]);
obj_Bus.Businessid = Convert.ToInt32(dt.Rows[0]["Businessid"]);
obj_Bus.Name = Convert.ToString(dt.Rows[0]["Name"]);
obj_Bus.Email = Convert.ToString(dt.Rows[0]["Email"]);
obj_Bus.Review = Convert.ToString(dt.Rows[0]["Review"]);
obj_Bus.Rating = Convert.ToString(dt.Rows[0]["Rating"]);
obj_Bus.Isactive = Convert.ToBoolean(dt.Rows[0]["Isactive"]);
obj_Bus.Addedon = Convert.ToDateTime(dt.Rows[0]["Addedon"]);
obj_Bus.Addedbyip = Convert.ToString(dt.Rows[0]["Addedbyip"]);
obj_Bus.Isdeleted = Convert.ToBoolean(dt.Rows[0]["Isdeleted"]);
}
}
}
//Select Constructor
public buildingdeficiencyrepairCtl(Int32 id)
{
obj_con = new ConnectionCls();
buildingdeficiencyrepairClass obj_bui = new buildingdeficiencyrepairClass();
using (DataTable dt = selectdatatable(id))
{
if (dt.Rows.Count > 0)
{
obj_bui.Buildingdeficiencyrepairid = Convert.ToInt32(dt.Rows[0]["Buildingdeficiencyrepairid"]);
obj_bui.Buildingid = Convert.ToInt32(dt.Rows[0]["Buildingid"]);
obj_bui.Description = Convert.ToString(dt.Rows[0]["Description"]);
obj_bui.Quantity = Convert.ToInt32(dt.Rows[0]["Quantity"]);
obj_bui.Units = Convert.ToInt32(dt.Rows[0]["Units"]);
obj_bui.Priority = Convert.ToString(dt.Rows[0]["Priority"]);
obj_bui.Note = Convert.ToString(dt.Rows[0]["Note"]);
obj_bui.Workareano = Convert.ToInt32(dt.Rows[0]["Workareano"]);
obj_bui.Userid = Convert.ToInt32(dt.Rows[0]["Userid"]);
obj_bui.Inserteddatetime = Convert.ToDateTime(dt.Rows[0]["Inserteddatetime"]);
}
}
}
