private void bindLstServiceProvider() { ManageServiceProvider manageServiceProvider = new ManageServiceProvider(); var lstSPs = manageServiceProvider.getServiceProviderList(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString); lstServiceProvider.DataSource= lstSPs; lstServiceProvider.DataTextField = "SP_Name"; lstServiceProvider.DataValueField = "SP_ID"; lstServiceProvider.DataBind(); }
protected void btnSaveServiceProvider_ServerClick(object sender, EventArgs e) { ServiceProviderObject obj = new ServiceProviderObject(); obj.SP_Name = txtServiceProviderName.Value; obj.SP_address= txtServiceProviderAddress.Value; obj.Telephone = txtServiceProviderTelephone.Value; obj.Category = Convert.ToInt32(lstCategory.Value); obj.Disable = chkBoxModelDisable.Checked; ManageServiceProvider ManageServiceProviderObj = new ManageServiceProvider(); bool success = ManageServiceProviderObj.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString); if (success) { divSuccess.Visible = true; } else divFailure.Visible = true; }
protected void grdServiceProvider_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = int.Parse(e.CommandArgument.ToString()); Session.Add("rowIndex", rowIndex); ManageServiceProvider ServiceProviderObj = new ManageServiceProvider(); DataTable dt = ServiceProviderObj.getAServiceProvider(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtServiceProviderName.Value = DBUtility.readDBString(dr, "SP_Name"); lstCategory.Value = DBUtility.readDBString(dr, "ServiceProviderCategory_Name"); txtServiceProviderAddress.Value = DBUtility.readDBString(dr, "SP_address"); txtServiceProviderTelephone.Value = DBUtility.readDBString(dr, "Telephone"); if (dr["Disable"] != null && !dr.IsNull("Disable")) { chkBoxModelDisable.Checked = Convert.ToBoolean(dr["Disable"]); } } }
protected void btnSaveServiceProvider_ServerClick(object sender, EventArgs e) { ServiceProviderObject obj = new ServiceProviderObject(); obj.SP_Name = txtServiceProviderName.Value; obj.SP_address = txtServiceProviderAddress.Value; obj.Telephone = txtServiceProviderTelephone.Value; obj.Category = Convert.ToInt32(lstCategory.Items.FindByValue(lstCategory.Value).Value); obj.Disable = chkBoxModelDisable.Checked; ManageServiceProvider ServiceProviderObj = new ManageServiceProvider(); bool success = ServiceProviderObj.updateAServiceProvider(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"])); if (success) { divSuccess.Visible = true; } else divFailure.Visible = true; Session.Remove("rowIndex"); }
protected void grdServiceProvider_Load(object sender, EventArgs e) { ManageServiceProvider ServiceProviderObj = new ManageServiceProvider(); grdServiceProvider.DataSource = ServiceProviderObj.getServiceProviders(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString); grdServiceProvider.DataBind(); }