public void BindDrpsite() { BLLCollection <Site_mst> col = new BLLCollection <Site_mst>(); BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); int custid = Convert.ToInt32(drpCustomer.SelectedValue); Site_mst ObjSite = new Site_mst(); col = ObjSite.Get_All(); foreach (Site_mst obj in col) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } DrpSite.DataTextField = "sitename"; DrpSite.DataValueField = "siteid"; DrpSite.DataSource = colSite1; DrpSite.DataBind(); ListItem item = new ListItem(); item.Text = Resources.MessageResource.errselectste.ToString(); item.Value = "0"; DrpSite.Items.Add(item); //DrpSite.SelectedValue = "0"; }
protected void BindDropDown() { BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); int custid; custid = Convert.ToInt16(drpCustomer.SelectedValue); colSite = objSite.Get_All(); foreach (Site_mst obj in colSite) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } drpSites.DataTextField = "sitename"; drpSites.DataValueField = "siteid"; drpSites.DataSource = colSite1; drpSites.DataBind(); ListItem item = new ListItem(); item.Text = "------------Select-------------"; item.Value = "0"; drpSites.Items.Add(item); drpSites.SelectedValue = "0"; //btnReset_Click(); }
protected void BindDropDownSiteRegionWise() { BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); int custid = Convert.ToInt16(drpRegion.SelectedValue); // Declare collection col as Site_mst to get all Sites from database // By Calling Function objSite.Get_All() assign to col object colSite = objSite.Get_All(); foreach (Site_mst obj in colSite) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } drpSites.DataTextField = "sitename"; drpSites.DataValueField = "siteid"; drpSites.DataSource = colSite1; drpSites.DataBind(); ListItem item = new ListItem(); item.Text = "------------Select-------------"; item.Value = "0"; drpSites.Items.Add(item); drpSites.SelectedValue = "0"; }
public void BindDrpSite() { BLLCollection <Site_mst> col = new BLLCollection <Site_mst>(); BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); int custid = Convert.ToInt32(drpCustomer.SelectedValue); col = objsite.Get_All(); foreach (Site_mst obj in col) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } drpsite.DataTextField = "SiteName"; drpsite.DataValueField = "siteid"; drpsite.DataSource = colSite1; drpsite.DataBind(); ListItem item = new ListItem(); item.Text = "-------------Select-------------"; item.Value = "0"; drpsite.Items.Add(item); drpsite.SelectedValue = "0"; }
// Event handler btnSearch_Click , To find user exist or not //protected void btnSearch_Click(object sender, EventArgs e) //{ // // Declare Local Variable Username to get username from textbox // string Username = txtUserName.Text.ToString().Trim(); // // Find User Exist in Database by Calling objUser.Get_UserLogin_By_UserName_Like() Function // objUser = objUser.Get_UserLogin_By_UserName_Like(Username); // // If UserId is Not Zero than User Exist // if (objUser.Userid != 0) // { // txtUserName.Text = objUser.Username.ToString().Trim(); // } // else // { // txtUserName.Text = ""; // } //} // Bind Grid of grdvwSite , on the basis of drop down value Selection protected void BindGrid() { // Declare Local Variable regionid to get regionid from drpRegion DropDown int custid; // Assign regionid to localvariable regionid from selected value of drop down custid = Convert.ToInt16(drpRegion.SelectedValue); // If region is Zero , ie All has been selected ,and bind all Sites Information to Grid if (custid == 0) { colSites = objSites.Get_All(); grdvwSite.DataSource = colSites; grdvwSite.DataBind(); } else { // Grid will bind only those sites ,which come under selected region BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); colSites = objSites.Get_All(); foreach (Site_mst obj in colSites) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } grdvwSite.DataSource = colSite1; grdvwSite.DataBind(); } }
public void BindDrpSite() { // Declare col as Collection of Site_mst Object to get all records from table BLLCollection <Site_mst> col = new BLLCollection <Site_mst>(); BLLCollection <Site_mst> colSite1 = new BLLCollection <Site_mst>(); int custid = Convert.ToInt16(drpCustomer.SelectedValue); // declare object objOrganization of Site_mst_mst Class to call function Get_All() to fetch all records from database // Assign all records to variable col col = objSite.Get_All(); foreach (Site_mst obj in col) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colSite1.Add(obj); } } drpSite.DataTextField = "SiteName"; drpSite.DataValueField = "siteid"; drpSite.DataSource = colSite1; drpSite.DataBind(); // Declare item as listItem to assign default value to drop down ListItem item = new ListItem(); item.Text = "--------------Select--------------"; item.Value = "0"; drpSite.Items.Add(item); drpSite.SelectedValue = "0"; }
protected void BindDropSite() { int userid; userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); foreach (UserToSiteMapping Obj in colUserToSite) { int siteid; Site_mst objSite1 = new Site_mst(); siteid = Obj.Siteid; objSite1 = objSite.Get_By_id(siteid); if (objSite1.Siteid != 0) { int custid = Convert.ToInt16(drpCustomer.SelectedValue); int flag = objCustToSite.Get_By_Id(custid, objSite1.Siteid); if (flag == 1) { colSite.Add(objSite1); } } } //} //drpSite.DataTextField = "sitename"; //drpSite.DataValueField = "siteid"; //drpSite.DataSource = colSite ; //drpSite.DataBind(); // if (colSite.Count == 0) // { // ListItem item = new ListItem(); // item.Text = "-------------Select-------------"; // item.Value = "0"; // drpSite.Items.Add(item); // } // } //} //protected void BindDropSite() //{ //colSite = objSite.Get_All(); drpSite.DataTextField = "sitename"; drpSite.DataValueField = "siteid"; drpSite.DataSource = colSite; drpSite.DataBind(); //ListItem item = new ListItem(); //item.Text = "-------------Select-------------"; //item.Value = "0"; //drpSite.Items.Add(item); //drpSite.SelectedValue = "0"; }
protected void BindDropSite() { string userName = ""; MembershipUser User = Membership.GetUser(); if (User != null) { userName = User.UserName.ToString(); } if (userName != "") { int userid; objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); if (objUser.Userid != 0) { userid = objUser.Userid; colUserToSite = ObjUserToSite.Get_All_By_userid(userid); foreach (UserToSiteMapping obj in colUserToSite) { int siteid; Site_mst objSite1 = new Site_mst(); siteid = obj.Siteid; objSite1 = objSite1.Get_By_id(siteid); if (objSite1.Siteid != 0) { int custid = Convert.ToInt16(drpCustomer.SelectedValue); int flag = objCustToSite.Get_By_Id(custid, objSite1.Siteid); if (flag == 1) { colSite.Add(objSite1); } } } } drpSite.DataTextField = "sitename"; drpSite.DataValueField = "siteid"; drpSite.DataSource = colSite; drpSite.DataBind(); if (colSite.Count == 0) { ListItem item = new ListItem(); item.Text = "-------------Select-------------"; item.Value = "0"; drpSite.Items.Add(item); } } }
public void BindGrid() { int custid; custid = Convert.ToInt16(drpRegion.SelectedValue); colservicewindow = objservicewindow.Get_All(); BLLCollection <ServiceWindow_mst> colservicewindow1 = new BLLCollection <ServiceWindow_mst>(); foreach (ServiceWindow_mst obj in colservicewindow) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { colservicewindow1.Add(obj); } } grdvwViewServiceWindow.DataSource = colservicewindow1; grdvwViewServiceWindow.DataBind(); }
public void BindGridRegion() { int custid = Convert.ToInt16(drpRegion.SelectedValue); // Declare collection col as Site_mst to get all Sites from database // By Calling Function objSite.Get_All() assign to col object col = objSite.Get_All(); // Bind GridView by using Datasource and Databind Properties BLLCollection <Site_mst> col1 = new BLLCollection <Site_mst>(); foreach (Site_mst obj in col) { int flag; flag = objCustToSite.Get_By_Id(custid, obj.Siteid); if (flag == 1) { col1.Add(obj); } } grdvwSite.DataSource = col1; grdvwSite.DataBind(); }