private void UpdateRecord() { dbo_DimPromotionClass oclsdbo_DimPromotion = new dbo_DimPromotionClass(); dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); oclsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(Session["PromotionKey"]); oclsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(oclsdbo_DimPromotion); if (VerifyData() == true) { SetData(clsdbo_DimPromotion); bool bSucess = false; bSucess = dbo_DimPromotionDataClass.Update(oclsdbo_DimPromotion, clsdbo_DimPromotion); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimPromotion"); LoadGriddbo_DimPromotion(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Promotion "); } } }
private void Edit() { try { dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); Label lblPromotionKey = (Label)grddbo_DimPromotion.Rows[grddbo_DimPromotion.EditIndex].FindControl("lblPromotionKey"); clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(lblPromotionKey.Text); clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion); LoadGriddbo_DimPromotion(); } catch { } }
private void DeleteRecord() { dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); Label lblPromotionKey = (Label)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblPromotionKey"); clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(lblPromotionKey.Text); clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion); bool bSucess = false; bSucess = dbo_DimPromotionDataClass.Delete(clsdbo_DimPromotion); if (bSucess == true) { Session.Remove("dvdbo_DimPromotion"); LoadGriddbo_DimPromotion(); } else { ec.ShowMessage(" Delete failed. ", " Dbo. Dim Promotion "); } }
private void InsertRecord() { dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); if (VerifyData() == true) { SetData(clsdbo_DimPromotion); bool bSucess = false; bSucess = dbo_DimPromotionDataClass.Add(clsdbo_DimPromotion); if (bSucess == true) { pnlForm.Visible = false; pnlSave.Visible = false; pnlGrid.Visible = true; lblMode.InnerText = ""; Session.Remove("dvdbo_DimPromotion"); LoadGriddbo_DimPromotion(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Promotion "); } } }
private void UpdateRecord() { try { TextBox txtPromotionKey = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPromotionKey"); TextBox txtPromotionAlternateKey = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtPromotionAlternateKey"); TextBox txtEnglishPromotionName = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionName"); TextBox txtSpanishPromotionName = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionName"); TextBox txtFrenchPromotionName = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionName"); TextBox txtDiscountPct = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDiscountPct"); TextBox txtEnglishPromotionType = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionType"); TextBox txtSpanishPromotionType = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionType"); TextBox txtFrenchPromotionType = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionType"); TextBox txtEnglishPromotionCategory = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishPromotionCategory"); TextBox txtSpanishPromotionCategory = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishPromotionCategory"); TextBox txtFrenchPromotionCategory = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchPromotionCategory"); TextBox txtStartDate = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtStartDate"); TextBox txtEndDate = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEndDate"); TextBox txtMinQty = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMinQty"); TextBox txtMaxQty = (TextBox)grddbo_DimPromotion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMaxQty"); dbo_DimPromotionClass oclsdbo_DimPromotion = new dbo_DimPromotionClass(); dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); oclsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(txtPromotionKey.Text); oclsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(oclsdbo_DimPromotion); if (VerifyData() == true) { if (string.IsNullOrEmpty(txtPromotionAlternateKey.Text)) { clsdbo_DimPromotion.PromotionAlternateKey = null; } else { clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtPromotionAlternateKey.Text); } if (string.IsNullOrEmpty(txtEnglishPromotionName.Text)) { clsdbo_DimPromotion.EnglishPromotionName = null; } else { clsdbo_DimPromotion.EnglishPromotionName = txtEnglishPromotionName.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionName.Text)) { clsdbo_DimPromotion.SpanishPromotionName = null; } else { clsdbo_DimPromotion.SpanishPromotionName = txtSpanishPromotionName.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionName.Text)) { clsdbo_DimPromotion.FrenchPromotionName = null; } else { clsdbo_DimPromotion.FrenchPromotionName = txtFrenchPromotionName.Text; } if (string.IsNullOrEmpty(txtDiscountPct.Text)) { clsdbo_DimPromotion.DiscountPct = null; } else { clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtDiscountPct.Text); } if (string.IsNullOrEmpty(txtEnglishPromotionType.Text)) { clsdbo_DimPromotion.EnglishPromotionType = null; } else { clsdbo_DimPromotion.EnglishPromotionType = txtEnglishPromotionType.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionType.Text)) { clsdbo_DimPromotion.SpanishPromotionType = null; } else { clsdbo_DimPromotion.SpanishPromotionType = txtSpanishPromotionType.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionType.Text)) { clsdbo_DimPromotion.FrenchPromotionType = null; } else { clsdbo_DimPromotion.FrenchPromotionType = txtFrenchPromotionType.Text; } if (string.IsNullOrEmpty(txtEnglishPromotionCategory.Text)) { clsdbo_DimPromotion.EnglishPromotionCategory = null; } else { clsdbo_DimPromotion.EnglishPromotionCategory = txtEnglishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionCategory.Text)) { clsdbo_DimPromotion.SpanishPromotionCategory = null; } else { clsdbo_DimPromotion.SpanishPromotionCategory = txtSpanishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionCategory.Text)) { clsdbo_DimPromotion.FrenchPromotionCategory = null; } else { clsdbo_DimPromotion.FrenchPromotionCategory = txtFrenchPromotionCategory.Text; } clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtStartDate.Text); if (string.IsNullOrEmpty(txtEndDate.Text)) { clsdbo_DimPromotion.EndDate = null; } else { clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtEndDate.Text); } if (string.IsNullOrEmpty(txtMinQty.Text)) { clsdbo_DimPromotion.MinQty = null; } else { clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtMinQty.Text); } if (string.IsNullOrEmpty(txtMaxQty.Text)) { clsdbo_DimPromotion.MaxQty = null; } else { clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtMaxQty.Text); } bool bSucess = false; bSucess = dbo_DimPromotionDataClass.Update(oclsdbo_DimPromotion, clsdbo_DimPromotion); if (bSucess == true) { Session.Remove("dvdbo_DimPromotion"); grddbo_DimPromotion.EditIndex = -1; LoadGriddbo_DimPromotion(); } else { ec.ShowMessage(" Update failed. ", " Dbo. Dim Promotion "); } } } catch { } }
private void InsertRecord() { try { TextBox txtNewPromotionAlternateKey = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewPromotionAlternateKey"); TextBox txtNewEnglishPromotionName = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionName"); TextBox txtNewSpanishPromotionName = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionName"); TextBox txtNewFrenchPromotionName = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionName"); TextBox txtNewDiscountPct = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewDiscountPct"); TextBox txtNewEnglishPromotionType = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionType"); TextBox txtNewSpanishPromotionType = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionType"); TextBox txtNewFrenchPromotionType = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionType"); TextBox txtNewEnglishPromotionCategory = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEnglishPromotionCategory"); TextBox txtNewSpanishPromotionCategory = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewSpanishPromotionCategory"); TextBox txtNewFrenchPromotionCategory = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewFrenchPromotionCategory"); TextBox txtNewStartDate = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewStartDate"); TextBox txtNewEndDate = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewEndDate"); TextBox txtNewMinQty = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewMinQty"); TextBox txtNewMaxQty = (TextBox)grddbo_DimPromotion.FooterRow.FindControl("txtNewMaxQty"); dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); if (VerifyDataNew() == true) { if (string.IsNullOrEmpty(txtNewPromotionAlternateKey.Text)) { clsdbo_DimPromotion.PromotionAlternateKey = null; } else { clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtNewPromotionAlternateKey.Text); } if (string.IsNullOrEmpty(txtNewEnglishPromotionName.Text)) { clsdbo_DimPromotion.EnglishPromotionName = null; } else { clsdbo_DimPromotion.EnglishPromotionName = txtNewEnglishPromotionName.Text; } if (string.IsNullOrEmpty(txtNewSpanishPromotionName.Text)) { clsdbo_DimPromotion.SpanishPromotionName = null; } else { clsdbo_DimPromotion.SpanishPromotionName = txtNewSpanishPromotionName.Text; } if (string.IsNullOrEmpty(txtNewFrenchPromotionName.Text)) { clsdbo_DimPromotion.FrenchPromotionName = null; } else { clsdbo_DimPromotion.FrenchPromotionName = txtNewFrenchPromotionName.Text; } if (string.IsNullOrEmpty(txtNewDiscountPct.Text)) { clsdbo_DimPromotion.DiscountPct = null; } else { clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtNewDiscountPct.Text); } if (string.IsNullOrEmpty(txtNewEnglishPromotionType.Text)) { clsdbo_DimPromotion.EnglishPromotionType = null; } else { clsdbo_DimPromotion.EnglishPromotionType = txtNewEnglishPromotionType.Text; } if (string.IsNullOrEmpty(txtNewSpanishPromotionType.Text)) { clsdbo_DimPromotion.SpanishPromotionType = null; } else { clsdbo_DimPromotion.SpanishPromotionType = txtNewSpanishPromotionType.Text; } if (string.IsNullOrEmpty(txtNewFrenchPromotionType.Text)) { clsdbo_DimPromotion.FrenchPromotionType = null; } else { clsdbo_DimPromotion.FrenchPromotionType = txtNewFrenchPromotionType.Text; } if (string.IsNullOrEmpty(txtNewEnglishPromotionCategory.Text)) { clsdbo_DimPromotion.EnglishPromotionCategory = null; } else { clsdbo_DimPromotion.EnglishPromotionCategory = txtNewEnglishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtNewSpanishPromotionCategory.Text)) { clsdbo_DimPromotion.SpanishPromotionCategory = null; } else { clsdbo_DimPromotion.SpanishPromotionCategory = txtNewSpanishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtNewFrenchPromotionCategory.Text)) { clsdbo_DimPromotion.FrenchPromotionCategory = null; } else { clsdbo_DimPromotion.FrenchPromotionCategory = txtNewFrenchPromotionCategory.Text; } clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtNewStartDate.Text); if (string.IsNullOrEmpty(txtNewEndDate.Text)) { clsdbo_DimPromotion.EndDate = null; } else { clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtNewEndDate.Text); } if (string.IsNullOrEmpty(txtNewMinQty.Text)) { clsdbo_DimPromotion.MinQty = null; } else { clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtNewMinQty.Text); } if (string.IsNullOrEmpty(txtNewMaxQty.Text)) { clsdbo_DimPromotion.MaxQty = null; } else { clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtNewMaxQty.Text); } bool bSucess = false; bSucess = dbo_DimPromotionDataClass.Add(clsdbo_DimPromotion); if (bSucess == true) { Session.Remove("dvdbo_DimPromotion"); LoadGriddbo_DimPromotion(); } else { ec.ShowMessage(" Insert failed. ", " Dbo. Dim Promotion "); } } } catch { } }
private void SetData(dbo_DimPromotionClass clsdbo_DimPromotion) { if (string.IsNullOrEmpty(txtPromotionAlternateKey.Text)) { clsdbo_DimPromotion.PromotionAlternateKey = null; } else { clsdbo_DimPromotion.PromotionAlternateKey = System.Convert.ToInt32(txtPromotionAlternateKey.Text); } if (string.IsNullOrEmpty(txtEnglishPromotionName.Text)) { clsdbo_DimPromotion.EnglishPromotionName = null; } else { clsdbo_DimPromotion.EnglishPromotionName = txtEnglishPromotionName.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionName.Text)) { clsdbo_DimPromotion.SpanishPromotionName = null; } else { clsdbo_DimPromotion.SpanishPromotionName = txtSpanishPromotionName.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionName.Text)) { clsdbo_DimPromotion.FrenchPromotionName = null; } else { clsdbo_DimPromotion.FrenchPromotionName = txtFrenchPromotionName.Text; } if (string.IsNullOrEmpty(txtDiscountPct.Text)) { clsdbo_DimPromotion.DiscountPct = null; } else { clsdbo_DimPromotion.DiscountPct = System.Convert.ToDecimal(txtDiscountPct.Text); } if (string.IsNullOrEmpty(txtEnglishPromotionType.Text)) { clsdbo_DimPromotion.EnglishPromotionType = null; } else { clsdbo_DimPromotion.EnglishPromotionType = txtEnglishPromotionType.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionType.Text)) { clsdbo_DimPromotion.SpanishPromotionType = null; } else { clsdbo_DimPromotion.SpanishPromotionType = txtSpanishPromotionType.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionType.Text)) { clsdbo_DimPromotion.FrenchPromotionType = null; } else { clsdbo_DimPromotion.FrenchPromotionType = txtFrenchPromotionType.Text; } if (string.IsNullOrEmpty(txtEnglishPromotionCategory.Text)) { clsdbo_DimPromotion.EnglishPromotionCategory = null; } else { clsdbo_DimPromotion.EnglishPromotionCategory = txtEnglishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtSpanishPromotionCategory.Text)) { clsdbo_DimPromotion.SpanishPromotionCategory = null; } else { clsdbo_DimPromotion.SpanishPromotionCategory = txtSpanishPromotionCategory.Text; } if (string.IsNullOrEmpty(txtFrenchPromotionCategory.Text)) { clsdbo_DimPromotion.FrenchPromotionCategory = null; } else { clsdbo_DimPromotion.FrenchPromotionCategory = txtFrenchPromotionCategory.Text; } clsdbo_DimPromotion.StartDate = System.Convert.ToDateTime(txtStartDate.Text); if (string.IsNullOrEmpty(txtEndDate.Text)) { clsdbo_DimPromotion.EndDate = null; } else { clsdbo_DimPromotion.EndDate = System.Convert.ToDateTime(txtEndDate.Text); } if (string.IsNullOrEmpty(txtMinQty.Text)) { clsdbo_DimPromotion.MinQty = null; } else { clsdbo_DimPromotion.MinQty = System.Convert.ToInt32(txtMinQty.Text); } if (string.IsNullOrEmpty(txtMaxQty.Text)) { clsdbo_DimPromotion.MaxQty = null; } else { clsdbo_DimPromotion.MaxQty = System.Convert.ToInt32(txtMaxQty.Text); } }
private void GetData() { ClearRecord(); dbo_DimPromotionClass clsdbo_DimPromotion = new dbo_DimPromotionClass(); clsdbo_DimPromotion.PromotionKey = System.Convert.ToInt32(Session["PromotionKey"]); clsdbo_DimPromotion = dbo_DimPromotionDataClass.Select_Record(clsdbo_DimPromotion); if ((clsdbo_DimPromotion != null)) { try { txtPromotionKey.Text = System.Convert.ToString(clsdbo_DimPromotion.PromotionKey); if (clsdbo_DimPromotion.PromotionAlternateKey == null) { txtPromotionAlternateKey.Text = default(string); } else { txtPromotionAlternateKey.Text = System.Convert.ToString(clsdbo_DimPromotion.PromotionAlternateKey); } if (clsdbo_DimPromotion.EnglishPromotionName == null) { txtEnglishPromotionName.Text = default(string); } else { txtEnglishPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionName); } if (clsdbo_DimPromotion.SpanishPromotionName == null) { txtSpanishPromotionName.Text = default(string); } else { txtSpanishPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionName); } if (clsdbo_DimPromotion.FrenchPromotionName == null) { txtFrenchPromotionName.Text = default(string); } else { txtFrenchPromotionName.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionName); } if (clsdbo_DimPromotion.DiscountPct == null) { txtDiscountPct.Text = default(string); } else { txtDiscountPct.Text = System.Convert.ToString(clsdbo_DimPromotion.DiscountPct); } if (clsdbo_DimPromotion.EnglishPromotionType == null) { txtEnglishPromotionType.Text = default(string); } else { txtEnglishPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionType); } if (clsdbo_DimPromotion.SpanishPromotionType == null) { txtSpanishPromotionType.Text = default(string); } else { txtSpanishPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionType); } if (clsdbo_DimPromotion.FrenchPromotionType == null) { txtFrenchPromotionType.Text = default(string); } else { txtFrenchPromotionType.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionType); } if (clsdbo_DimPromotion.EnglishPromotionCategory == null) { txtEnglishPromotionCategory.Text = default(string); } else { txtEnglishPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.EnglishPromotionCategory); } if (clsdbo_DimPromotion.SpanishPromotionCategory == null) { txtSpanishPromotionCategory.Text = default(string); } else { txtSpanishPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.SpanishPromotionCategory); } if (clsdbo_DimPromotion.FrenchPromotionCategory == null) { txtFrenchPromotionCategory.Text = default(string); } else { txtFrenchPromotionCategory.Text = System.Convert.ToString(clsdbo_DimPromotion.FrenchPromotionCategory); } txtStartDate.Text = System.Convert.ToDateTime(clsdbo_DimPromotion.StartDate).ToShortDateString(); if (clsdbo_DimPromotion.EndDate == null) { txtEndDate.Text = DateTime.Now.ToString(); } else { txtEndDate.Text = System.Convert.ToDateTime(clsdbo_DimPromotion.EndDate).ToShortDateString(); } if (clsdbo_DimPromotion.MinQty == null) { txtMinQty.Text = default(string); } else { txtMinQty.Text = System.Convert.ToString(clsdbo_DimPromotion.MinQty); } if (clsdbo_DimPromotion.MaxQty == null) { txtMaxQty.Text = default(string); } else { txtMaxQty.Text = System.Convert.ToString(clsdbo_DimPromotion.MaxQty); } } catch (Exception ex) { ec.ShowMessage(ex.Message, " Dbo. Dim Promotion "); } } }