//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"]); } } }