protected void SubBusinessUnit_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow && SubBusinessUnitGridView.EditIndex == e.Row.RowIndex) { SubBusinessUnitReportingChild li = new SubBusinessUnitReportingChild(); //Find the DropDownList in the Row DropDownList ddlSubBusinessUnitManagerNameList = (e.Row.FindControl("SubBusinessUnitManagerName") as DropDownList); ddlSubBusinessUnitManagerNameList.DataSource = li.SubBusinessUnitManagerNameList().Tables[0]; ddlSubBusinessUnitManagerNameList.DataTextField = "SubBusinessUnitManagerName"; ddlSubBusinessUnitManagerNameList.DataValueField = "SubBusinessUnitManagerName"; ddlSubBusinessUnitManagerNameList.DataBind(); //Add Default Item in the DropDownList ddlSubBusinessUnitManagerNameList.Items.Insert(0, new ListItem("Select One")); //Select the Country of Customer in DropDownList string subBusinessUnitManagerNames = (e.Row.FindControl("lblSubBusinessUnitManagerName") as Label).Text; ListItem item = ddlSubBusinessUnitManagerNameList.Items.FindByValue(subBusinessUnitManagerNames); if (item != null) { ddlSubBusinessUnitManagerNameList.SelectedValue = subBusinessUnitManagerNames; } //Find the DropDownList in the Row DropDownList ddlBusinessUnitNameList = (e.Row.FindControl("BusinessUnitName") as DropDownList); ddlBusinessUnitNameList.DataSource = li.BusinessUnitNameist().Tables[0]; ddlBusinessUnitNameList.DataTextField = "BusinessUnitName"; ddlBusinessUnitNameList.DataValueField = "BusinessUnitName"; ddlBusinessUnitNameList.DataBind(); //Add Default Item in the DropDownList ddlBusinessUnitNameList.Items.Insert(0, new ListItem("Select One")); //Select the Country of Customer in DropDownList string businessUnitNames = (e.Row.FindControl("lblBusinessUnitName") as Label).Text; ddlBusinessUnitNameList.Items.FindByValue(businessUnitNames).Selected = true; //Find the DropDownList in the Row DropDownList ddlCompanyNameList = (e.Row.FindControl("CompanyName") as DropDownList); ddlCompanyNameList.DataSource = li.CompanyNameList().Tables[0]; ddlCompanyNameList.DataTextField = "CompanyName"; ddlCompanyNameList.DataValueField = "CompanyName"; ddlCompanyNameList.DataBind(); //Add Default Item in the DropDownList ddlCompanyNameList.Items.Insert(0, new ListItem("Select One")); //Select the Country of Customer in DropDownList string companyNames = (e.Row.FindControl("lblCompanyName") as Label).Text; ddlCompanyNameList.Items.FindByValue(companyNames).Selected = true; } }
public DataSet UpdateSKPickingBoard(SubBusinessUnitReportingChild li, int memberships) { DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString()); SqlCommand sqlCmd = new SqlCommand("dbo.Web_SR_UpdateSubBusinessUnits", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; // if (memberships == 1 || memberships == 2) // { sqlCmd.Parameters.Add("@SubBusinessUnitID", SqlDbType.Int).Value = li.SubBusinessUnitID; sqlCmd.Parameters.Add("@EffectiveDate", SqlDbType.DateTime).Value = li.EffectiveDate; if (li.ExpirationDate != DateTime.MinValue) { sqlCmd.Parameters.Add("@ExpirationDate", SqlDbType.DateTime).Value = li.ExpirationDate; } sqlCmd.Parameters.Add("@SubBusinessUnitCode", SqlDbType.Int).Value = li.SubBusinessUnitCode; sqlCmd.Parameters.Add("@SubBusinessUnitName", SqlDbType.NVarChar).Value = li.SubBusinessUnitName; sqlCmd.Parameters.Add("@SubBusinessUnitManagerName", SqlDbType.NVarChar).Value = li.SubBusinessUnitManagerName; sqlCmd.Parameters.Add("@BusinessUnitName", SqlDbType.NVarChar).Value = li.BusinessUnitName; sqlCmd.Parameters.Add("@CompanyName", SqlDbType.NVarChar).Value = li.CompanyName; if (String.IsNullOrEmpty(HttpContext.Current.User.Identity.Name)) { sqlCmd.Parameters.Add("@UpdateUser", SqlDbType.VarChar).Value = "sysadmin"; } else { sqlCmd.Parameters.Add("@UpdateUser", SqlDbType.VarChar).Value = HttpContext.Current.User.Identity.Name; } // } try { sqlConn.Open(); using (SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd)) { adapter.Fill(ds); } } catch (Exception ex) { throw ex; } return(ds); }
protected void btnexcelDownload_Click(object sender, EventArgs e) { ModalPopupExtender2.Hide(); SubBusinessUnitReportingChild obj = new SubBusinessUnitReportingChild(); DataSet ds = obj.GetSKPickingBoard2("Select One", "Select One", "Select One", "Select One"); WorkbookEngine we = new WorkbookEngine(); foreach (DataRow dr in ds.Tables[0].Rows) { if (!dr.IsNull("ExpirationDate")) { dr.Delete(); } //DateTime expirationDate = Convert.ToDateTime(dr["ExpirationDate"].ToString()); } we.ExportDataSetToExcel(ds.Tables[0], "SubBusinessUnit Reporting"); }
private void BindGridView() { int count; SubBusinessUnitReportingChild obj = new SubBusinessUnitReportingChild(); string subBusinessUnitName = ddlSubBusinessUnitName.SelectedValue.ToString(); string subBusinessUnitManagerName = ddlSubBusinessUnitManagerName.SelectedValue.ToString(); string businessUnitName = ddlBusinessUnitName.SelectedValue.ToString(); string companyName = ddlCompanyName.SelectedValue.ToString(); DataSet ds = obj.GetSKPickingBoard2(subBusinessUnitName, businessUnitName, companyName, subBusinessUnitManagerName);//, companyName);// fromDate, toDate, period, fromQuantity, toQuantity, fromAmount, toAmount, adjustmentType, countryName, subBusinessUnitName, companyName, subSegmentName, accountSubTypeName, subCategoryName, rblMeasurementSystemText); SubBusinessUnitGridView.DataSource = ds.Tables[0]; SubBusinessUnitGridView.DataBind(); count = ds.Tables[0].Rows.Count; if (count > 1) { lblRecordCount.Text = "Record Count: " + count; } else { lblRecordCount.Text = "Record Count: " + count; } }
protected void SubBusinessUnit_RowUpdating(object sender, GridViewUpdateEventArgs e) { if (Page.IsValid) { SubBusinessUnitReportingChild li = new SubBusinessUnitReportingChild(); GridViewRow row = SubBusinessUnitGridView.Rows[e.RowIndex]; string display = ""; bool isFormFilled = true; try { li.SubBusinessUnitID = Convert.ToInt32(SubBusinessUnitGridView.DataKeys[e.RowIndex].Values[0]); if (((TextBox)row.FindControl("SubBusinessUnitCode")).Text != string.Empty) { li.SubBusinessUnitCode = Convert.ToInt32(((TextBox)row.FindControl("SubBusinessUnitCode")).Text); } else { display = "Sub Business Unit Code cannot be empty"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (((TextBox)row.FindControl("SubBusinessUnitName")).Text != string.Empty) { li.SubBusinessUnitName = Convert.ToString(((TextBox)row.FindControl("SubBusinessUnitName")).Text); } else { display = "Sub Business Unit Name cannot be empty"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (((DropDownList)row.FindControl("SubBusinessUnitManagerName")).SelectedValue != "Select One") { li.SubBusinessUnitManagerName = ((DropDownList)row.FindControl("SubBusinessUnitManagerName")).SelectedValue; } //else //{ // display = "Select Sub Business Unit Manager Name from dropdown"; // ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); // isFormFilled = false; //} if (((DropDownList)row.FindControl("BusinessUnitName")).SelectedValue != "Select One") { li.BusinessUnitName = ((DropDownList)row.FindControl("BusinessUnitName")).SelectedValue; } else { display = "Select Business Unit Name from dropdown"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (((DropDownList)row.FindControl("CompanyName")).SelectedValue != "Select One") { li.CompanyName = ((DropDownList)row.FindControl("CompanyName")).SelectedValue; } else { display = "Select Company Name from dropdown"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (!String.IsNullOrEmpty(Convert.ToString((Request.Form[row.FindControl("EffectiveDate").UniqueID])))) { li.EffectiveDate = Convert.ToDateTime((Request.Form[row.FindControl("EffectiveDate").UniqueID])); } else { display = "Effective Date cannot be empty"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (!String.IsNullOrEmpty(Convert.ToString((Request.Form[row.FindControl("ExpirationDate").UniqueID])))) { li.ExpirationDate = Convert.ToDateTime((Request.Form[row.FindControl("ExpirationDate").UniqueID])); } //else //{ // display = "Expiration Date cannot be empty"; // ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); // isFormFilled = false; //} if (li.ExpirationDate != DateTime.MinValue) { if (li.ExpirationDate < li.EffectiveDate) { display = "Expiration Date must be after Effective date"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } } if (isFormFilled) { if (memberships == 1 || memberships == 2) { DataSet result = li.UpdateSKPickingBoard(li, memberships); string res = Convert.ToString(result.Tables[0].Rows[0].ItemArray[0]); if (res.Equals("Duplicate SubBusinessUnitCode")) { display = "Sub Business Unit Code already exists in the database"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); } else if (res.Equals("Duplicate SubBusinessUnitName")) { display = "Sub Business Unit Name already exists in the database"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); } else if (res.Equals("Success")) { } } else { display = "You must be a member of Consolidated Sales Reporting – Admin or Consolidated Sales Reporting – Finance groups to make changes."; ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true); } } } catch (Exception ex) { throw ex; } SubBusinessUnitGridView.EditIndex = -1; BindGridView(); } }
protected void btnSaveNewSubBusinessUnit_Click(object sender, EventArgs e) { bool isFormFilled = true; string display = ""; SubBusinessUnitReportingChild li = new SubBusinessUnitReportingChild(); string subBusinessUnitCode = newSubBusinessUnitCode.Text; string subBusinessUnitName = newSubBusinessUnitName.Text; string subBusinessUnitManagerName = newSubBusinessUnitManagerName.Text; string businessUnitName = newBusinessUnitName.Text; string companyName = newCompanyName.Text; string subSegmentName = newSubSegmentName.Text; string effectiveDate = Request.Form[newEffectiveDate.UniqueID]; if (String.IsNullOrEmpty(effectiveDate) || String.IsNullOrEmpty(subBusinessUnitCode) || String.IsNullOrEmpty(subBusinessUnitName) || String.IsNullOrEmpty(subBusinessUnitManagerName) || String.IsNullOrEmpty(businessUnitName) || String.IsNullOrEmpty(companyName)) { display = "Please select all the mandatory fields "; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } if (isFormFilled) { if (memberships == 1 || memberships == 2) { DataSet result = li.AddNewSubBusinessUnit(subBusinessUnitCode, subBusinessUnitName, subSegmentName, subBusinessUnitManagerName, businessUnitName, companyName, effectiveDate); string res = Convert.ToString(result.Tables[0].Rows[0].ItemArray[0]); if (res.Equals("Duplicate SubBusinessUnitCode")) { display = "Sub Business Unit Code already exists in the database"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } else if (res.Equals("Duplicate SubBusinessUnitName")) { display = "Sub Business Unit Name already exists in the database"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = false; } else if (res.Equals("Success")) { display = "A new SubBusinessUnit is successfully added in the database"; ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + display + "');", true); isFormFilled = true; } if (isFormFilled) { newSubBusinessUnitCode.Text = ""; newSubBusinessUnitName.Text = ""; ddlSubBusinessUnitManagerName.DataSource = li.SubBusinessUnitManagerNameList().Tables[0]; ddlSubBusinessUnitManagerName.DataTextField = "SubBusinessUnitManagerName"; ddlSubBusinessUnitManagerName.DataBind(); ddlBusinessUnitName.DataSource = li.BusinessUnitNameist().Tables[0]; ddlBusinessUnitName.DataTextField = "BusinessUnitName"; ddlBusinessUnitName.DataBind(); ddlCompanyName.DataSource = li.CompanyNameList().Tables[0]; ddlCompanyName.DataTextField = "CompanyName"; ddlCompanyName.DataBind(); BindGridView(); } } else { display = "You must be a member of Consolidated Sales Reporting – Admin or Consolidated Sales Reporting – Finance groups to Add new SubBusinessUnit."; ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true); } } }
protected void Page_Load(object sender, EventArgs e) { VBFunctions.ADFunctions obj = new VBFunctions.ADFunctions(); string userID = obj.GetUserName(); // string dirEntry = obj.GetDirectoryEntry(); memberships = obj.VerifyGroupMemberships("LDAP://192.168.100.3/ou=Cooper Network Users,dc=coopersurgical1,dc=com", "webapps", "Yankees#1", userID); if (!Page.IsPostBack) { if (memberships == 1 || memberships == 2 || memberships == 3) { SubBusinessUnitReportingChild li = new SubBusinessUnitReportingChild(); DataTable table = new DataTable(); ddlSubBusinessUnitName.DataSource = li.SubBusinessUnitNameList().Tables[0]; ddlSubBusinessUnitName.DataTextField = "SubBusinessUnitName"; ddlSubBusinessUnitName.DataBind(); ddlSubBusinessUnitManagerName.DataSource = li.SubBusinessUnitManagerNameList().Tables[0]; ddlSubBusinessUnitManagerName.DataTextField = "SubBusinessUnitManagerName"; ddlSubBusinessUnitManagerName.DataBind(); ddlBusinessUnitName.DataSource = li.BusinessUnitNameist().Tables[0]; ddlBusinessUnitName.DataTextField = "BusinessUnitName"; ddlBusinessUnitName.DataBind(); ddlBusinessUnitName.DataSource = li.BusinessUnitNameist().Tables[0]; ddlBusinessUnitName.DataTextField = "BusinessUnitName"; ddlBusinessUnitName.DataBind(); ddlCompanyName.DataSource = li.CompanyNameList().Tables[0]; ddlCompanyName.DataTextField = "CompanyName"; ddlCompanyName.DataBind(); newCompanyName.DataSource = li.CompanyEffectiveNameList().Tables[0]; newCompanyName.DataTextField = "CompanyName"; newCompanyName.DataBind(); newBusinessUnitName.DataSource = li.BusinessUnitEffectiveNameist().Tables[0]; newBusinessUnitName.DataTextField = "BusinessUnitName"; newBusinessUnitName.DataBind(); newSubSegmentName.DataSource = li.SubSegmentNameEffectiveList().Tables[0]; newSubSegmentName.DataTextField = "SubSegmentName"; newSubSegmentName.DataBind(); newSubBusinessUnitManagerName.DataSource = li.SubBusinessUnitManagerNameList().Tables[0]; newSubBusinessUnitManagerName.DataTextField = "SubBusinessUnitManagerName"; newSubBusinessUnitManagerName.DataBind(); BindGridView(); } else { string display = "You must be a member of 'Consolidated Sales Reporting – Admin' or 'Consolidated Sales Reporting – Finance' or 'Consolidated Sales Reporting – Commission' groups to View the page."; ClientScript.RegisterStartupScript(this.GetType(), "yourMessage", "alert('" + display + "');", true); } } }