private void UpdateRecord()
{
dbo_DimDateClass oclsdbo_DimDate = new dbo_DimDateClass();
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
oclsdbo_DimDate.DateKey = System.Convert.ToInt32(Session["DateKey"]);
oclsdbo_DimDate = dbo_DimDateDataClass.Select_Record(oclsdbo_DimDate);
if (VerifyData() == true)
{
SetData(clsdbo_DimDate);
bool bSucess = false;
bSucess = dbo_DimDateDataClass.Update(oclsdbo_DimDate, clsdbo_DimDate);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimDate");
LoadGriddbo_DimDate();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Date ");
}
}
}
private void InsertRecord()
{
try {
TextBox txtNewDateKey = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDateKey");
TextBox txtNewFullDateAlternateKey = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFullDateAlternateKey");
TextBox txtNewDayNumberOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfWeek");
TextBox txtNewEnglishDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewEnglishDayNameOfWeek");
TextBox txtNewSpanishDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewSpanishDayNameOfWeek");
TextBox txtNewFrenchDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFrenchDayNameOfWeek");
TextBox txtNewDayNumberOfMonth = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfMonth");
TextBox txtNewDayNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfYear");
TextBox txtNewWeekNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewWeekNumberOfYear");
TextBox txtNewEnglishMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewEnglishMonthName");
TextBox txtNewSpanishMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewSpanishMonthName");
TextBox txtNewFrenchMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFrenchMonthName");
TextBox txtNewMonthNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewMonthNumberOfYear");
TextBox txtNewCalendarQuarter = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarQuarter");
TextBox txtNewCalendarYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarYear");
TextBox txtNewCalendarSemester = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarSemester");
TextBox txtNewFiscalQuarter = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalQuarter");
TextBox txtNewFiscalYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalYear");
TextBox txtNewFiscalSemester = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalSemester");
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
if (VerifyDataNew() == true)
{
clsdbo_DimDate.DateKey = System.Convert.ToInt32(txtNewDateKey.Text);
clsdbo_DimDate.FullDateAlternateKey = System.Convert.ToDateTime(txtNewFullDateAlternateKey.Text);
clsdbo_DimDate.DayNumberOfWeek = System.Convert.ToByte(txtNewDayNumberOfWeek.Text);
clsdbo_DimDate.EnglishDayNameOfWeek = System.Convert.ToString(txtNewEnglishDayNameOfWeek.Text);
clsdbo_DimDate.SpanishDayNameOfWeek = System.Convert.ToString(txtNewSpanishDayNameOfWeek.Text);
clsdbo_DimDate.FrenchDayNameOfWeek = System.Convert.ToString(txtNewFrenchDayNameOfWeek.Text);
clsdbo_DimDate.DayNumberOfMonth = System.Convert.ToByte(txtNewDayNumberOfMonth.Text);
clsdbo_DimDate.DayNumberOfYear = System.Convert.ToInt16(txtNewDayNumberOfYear.Text);
clsdbo_DimDate.WeekNumberOfYear = System.Convert.ToByte(txtNewWeekNumberOfYear.Text);
clsdbo_DimDate.EnglishMonthName = System.Convert.ToString(txtNewEnglishMonthName.Text);
clsdbo_DimDate.SpanishMonthName = System.Convert.ToString(txtNewSpanishMonthName.Text);
clsdbo_DimDate.FrenchMonthName = System.Convert.ToString(txtNewFrenchMonthName.Text);
clsdbo_DimDate.MonthNumberOfYear = System.Convert.ToByte(txtNewMonthNumberOfYear.Text);
clsdbo_DimDate.CalendarQuarter = System.Convert.ToByte(txtNewCalendarQuarter.Text);
clsdbo_DimDate.CalendarYear = System.Convert.ToInt16(txtNewCalendarYear.Text);
clsdbo_DimDate.CalendarSemester = System.Convert.ToByte(txtNewCalendarSemester.Text);
clsdbo_DimDate.FiscalQuarter = System.Convert.ToByte(txtNewFiscalQuarter.Text);
clsdbo_DimDate.FiscalYear = System.Convert.ToInt16(txtNewFiscalYear.Text);
clsdbo_DimDate.FiscalSemester = System.Convert.ToByte(txtNewFiscalSemester.Text);
bool bSucess = false;
bSucess = dbo_DimDateDataClass.Add(clsdbo_DimDate);
if (bSucess == true)
{
Session.Remove("dvdbo_DimDate");
LoadGriddbo_DimDate();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Date ");
}
}
} catch {
}
}
private void Edit()
{
try {
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
Label lblDateKey = (Label)grddbo_DimDate.Rows[grddbo_DimDate.EditIndex].FindControl("lblDateKey");
clsdbo_DimDate.DateKey = System.Convert.ToInt32(lblDateKey.Text);
clsdbo_DimDate = dbo_DimDateDataClass.Select_Record(clsdbo_DimDate);
LoadGriddbo_DimDate();
} catch {
}
}
private void DeleteRecord()
{
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
Label lblDateKey = (Label)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblDateKey");
clsdbo_DimDate.DateKey = System.Convert.ToInt32(lblDateKey.Text);
clsdbo_DimDate = dbo_DimDateDataClass.Select_Record(clsdbo_DimDate);
bool bSucess = false;
bSucess = dbo_DimDateDataClass.Delete(clsdbo_DimDate);
if (bSucess == true)
{
Session.Remove("dvdbo_DimDate");
LoadGriddbo_DimDate();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Dim Date ");
}
}
private void SetData(dbo_DimDateClass clsdbo_DimDate)
{
clsdbo_DimDate.DateKey = System.Convert.ToInt32(txtDateKey.Text);
clsdbo_DimDate.FullDateAlternateKey = System.Convert.ToDateTime(txtFullDateAlternateKey.Text);
clsdbo_DimDate.DayNumberOfWeek = System.Convert.ToByte(txtDayNumberOfWeek.Text);
clsdbo_DimDate.EnglishDayNameOfWeek = System.Convert.ToString(txtEnglishDayNameOfWeek.Text);
clsdbo_DimDate.SpanishDayNameOfWeek = System.Convert.ToString(txtSpanishDayNameOfWeek.Text);
clsdbo_DimDate.FrenchDayNameOfWeek = System.Convert.ToString(txtFrenchDayNameOfWeek.Text);
clsdbo_DimDate.DayNumberOfMonth = System.Convert.ToByte(txtDayNumberOfMonth.Text);
clsdbo_DimDate.DayNumberOfYear = System.Convert.ToInt16(txtDayNumberOfYear.Text);
clsdbo_DimDate.WeekNumberOfYear = System.Convert.ToByte(txtWeekNumberOfYear.Text);
clsdbo_DimDate.EnglishMonthName = System.Convert.ToString(txtEnglishMonthName.Text);
clsdbo_DimDate.SpanishMonthName = System.Convert.ToString(txtSpanishMonthName.Text);
clsdbo_DimDate.FrenchMonthName = System.Convert.ToString(txtFrenchMonthName.Text);
clsdbo_DimDate.MonthNumberOfYear = System.Convert.ToByte(txtMonthNumberOfYear.Text);
clsdbo_DimDate.CalendarQuarter = System.Convert.ToByte(txtCalendarQuarter.Text);
clsdbo_DimDate.CalendarYear = System.Convert.ToInt16(txtCalendarYear.Text);
clsdbo_DimDate.CalendarSemester = System.Convert.ToByte(txtCalendarSemester.Text);
clsdbo_DimDate.FiscalQuarter = System.Convert.ToByte(txtFiscalQuarter.Text);
clsdbo_DimDate.FiscalYear = System.Convert.ToInt16(txtFiscalYear.Text);
clsdbo_DimDate.FiscalSemester = System.Convert.ToByte(txtFiscalSemester.Text);
}
private void GetData()
{
ClearRecord();
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
clsdbo_DimDate.DateKey = System.Convert.ToInt32(Session["DateKey"]);
clsdbo_DimDate = dbo_DimDateDataClass.Select_Record(clsdbo_DimDate);
if ((clsdbo_DimDate != null))
{
try {
txtDateKey.Text = System.Convert.ToString(clsdbo_DimDate.DateKey);
txtFullDateAlternateKey.Text = System.Convert.ToDateTime(clsdbo_DimDate.FullDateAlternateKey).ToShortDateString();
txtDayNumberOfWeek.Text = System.Convert.ToString(clsdbo_DimDate.DayNumberOfWeek);
txtEnglishDayNameOfWeek.Text = System.Convert.ToString(clsdbo_DimDate.EnglishDayNameOfWeek);
txtSpanishDayNameOfWeek.Text = System.Convert.ToString(clsdbo_DimDate.SpanishDayNameOfWeek);
txtFrenchDayNameOfWeek.Text = System.Convert.ToString(clsdbo_DimDate.FrenchDayNameOfWeek);
txtDayNumberOfMonth.Text = System.Convert.ToString(clsdbo_DimDate.DayNumberOfMonth);
txtDayNumberOfYear.Text = System.Convert.ToString(clsdbo_DimDate.DayNumberOfYear);
txtWeekNumberOfYear.Text = System.Convert.ToString(clsdbo_DimDate.WeekNumberOfYear);
txtEnglishMonthName.Text = System.Convert.ToString(clsdbo_DimDate.EnglishMonthName);
txtSpanishMonthName.Text = System.Convert.ToString(clsdbo_DimDate.SpanishMonthName);
txtFrenchMonthName.Text = System.Convert.ToString(clsdbo_DimDate.FrenchMonthName);
txtMonthNumberOfYear.Text = System.Convert.ToString(clsdbo_DimDate.MonthNumberOfYear);
txtCalendarQuarter.Text = System.Convert.ToString(clsdbo_DimDate.CalendarQuarter);
txtCalendarYear.Text = System.Convert.ToString(clsdbo_DimDate.CalendarYear);
txtCalendarSemester.Text = System.Convert.ToString(clsdbo_DimDate.CalendarSemester);
txtFiscalQuarter.Text = System.Convert.ToString(clsdbo_DimDate.FiscalQuarter);
txtFiscalYear.Text = System.Convert.ToString(clsdbo_DimDate.FiscalYear);
txtFiscalSemester.Text = System.Convert.ToString(clsdbo_DimDate.FiscalSemester);
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Dim Date ");
}
}
}
private void InsertRecord()
{
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
if (VerifyData() == true)
{
SetData(clsdbo_DimDate);
bool bSucess = false;
bSucess = dbo_DimDateDataClass.Add(clsdbo_DimDate);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_DimDate");
LoadGriddbo_DimDate();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Dim Date ");
}
}
}
private Boolean VerifyDataNew()
{
TextBox txtNewDateKey = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDateKey");
TextBox txtNewFullDateAlternateKey = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFullDateAlternateKey");
TextBox txtNewDayNumberOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfWeek");
TextBox txtNewEnglishDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewEnglishDayNameOfWeek");
TextBox txtNewSpanishDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewSpanishDayNameOfWeek");
TextBox txtNewFrenchDayNameOfWeek = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFrenchDayNameOfWeek");
TextBox txtNewDayNumberOfMonth = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfMonth");
TextBox txtNewDayNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewDayNumberOfYear");
TextBox txtNewWeekNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewWeekNumberOfYear");
TextBox txtNewEnglishMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewEnglishMonthName");
TextBox txtNewSpanishMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewSpanishMonthName");
TextBox txtNewFrenchMonthName = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFrenchMonthName");
TextBox txtNewMonthNumberOfYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewMonthNumberOfYear");
TextBox txtNewCalendarQuarter = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarQuarter");
TextBox txtNewCalendarYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarYear");
TextBox txtNewCalendarSemester = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewCalendarSemester");
TextBox txtNewFiscalQuarter = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalQuarter");
TextBox txtNewFiscalYear = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalYear");
TextBox txtNewFiscalSemester = (TextBox)grddbo_DimDate.FooterRow.FindControl("txtNewFiscalSemester");
if (txtNewDateKey.Text == "")
{
ec.ShowMessage(" Date Key is Required. ", " Dbo. Dim Date ");
txtNewDateKey.Focus();
return(false);
}
if (txtNewDayNumberOfWeek.Text == "")
{
ec.ShowMessage(" Day Number Of Week is Required. ", " Dbo. Dim Date ");
txtNewDayNumberOfWeek.Focus();
return(false);
}
if (txtNewEnglishDayNameOfWeek.Text == "")
{
ec.ShowMessage(" English Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtNewEnglishDayNameOfWeek.Focus();
return(false);
}
if (txtNewSpanishDayNameOfWeek.Text == "")
{
ec.ShowMessage(" Spanish Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtNewSpanishDayNameOfWeek.Focus();
return(false);
}
if (txtNewFrenchDayNameOfWeek.Text == "")
{
ec.ShowMessage(" French Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtNewFrenchDayNameOfWeek.Focus();
return(false);
}
if (txtNewDayNumberOfMonth.Text == "")
{
ec.ShowMessage(" Day Number Of Month is Required. ", " Dbo. Dim Date ");
txtNewDayNumberOfMonth.Focus();
return(false);
}
if (txtNewDayNumberOfYear.Text == "")
{
ec.ShowMessage(" Day Number Of Year is Required. ", " Dbo. Dim Date ");
txtNewDayNumberOfYear.Focus();
return(false);
}
if (txtNewWeekNumberOfYear.Text == "")
{
ec.ShowMessage(" Week Number Of Year is Required. ", " Dbo. Dim Date ");
txtNewWeekNumberOfYear.Focus();
return(false);
}
if (txtNewEnglishMonthName.Text == "")
{
ec.ShowMessage(" English Month Name is Required. ", " Dbo. Dim Date ");
txtNewEnglishMonthName.Focus();
return(false);
}
if (txtNewSpanishMonthName.Text == "")
{
ec.ShowMessage(" Spanish Month Name is Required. ", " Dbo. Dim Date ");
txtNewSpanishMonthName.Focus();
return(false);
}
if (txtNewFrenchMonthName.Text == "")
{
ec.ShowMessage(" French Month Name is Required. ", " Dbo. Dim Date ");
txtNewFrenchMonthName.Focus();
return(false);
}
if (txtNewMonthNumberOfYear.Text == "")
{
ec.ShowMessage(" Month Number Of Year is Required. ", " Dbo. Dim Date ");
txtNewMonthNumberOfYear.Focus();
return(false);
}
if (txtNewCalendarQuarter.Text == "")
{
ec.ShowMessage(" Calendar Quarter is Required. ", " Dbo. Dim Date ");
txtNewCalendarQuarter.Focus();
return(false);
}
if (txtNewCalendarYear.Text == "")
{
ec.ShowMessage(" Calendar Year is Required. ", " Dbo. Dim Date ");
txtNewCalendarYear.Focus();
return(false);
}
if (txtNewCalendarSemester.Text == "")
{
ec.ShowMessage(" Calendar Semester is Required. ", " Dbo. Dim Date ");
txtNewCalendarSemester.Focus();
return(false);
}
if (txtNewFiscalQuarter.Text == "")
{
ec.ShowMessage(" Fiscal Quarter is Required. ", " Dbo. Dim Date ");
txtNewFiscalQuarter.Focus();
return(false);
}
if (txtNewFiscalYear.Text == "")
{
ec.ShowMessage(" Fiscal Year is Required. ", " Dbo. Dim Date ");
txtNewFiscalYear.Focus();
return(false);
}
if (txtNewFiscalSemester.Text == "")
{
ec.ShowMessage(" Fiscal Semester is Required. ", " Dbo. Dim Date ");
txtNewFiscalSemester.Focus();
return(false);
}
if (
txtNewDateKey.Text != ""
)
{
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
clsdbo_DimDate.DateKey = System.Convert.ToInt32(txtNewDateKey.Text);
clsdbo_DimDate = dbo_DimDateDataClass.Select_Record(clsdbo_DimDate);
if (clsdbo_DimDate != null)
{
ec.ShowMessage(" Record already exists. ", " Dbo. Dim Date ");
txtNewDateKey.Focus();
return(false);
}
}
return(true);
}
private void UpdateRecord()
{
try {
TextBox txtDateKey = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDateKey");
TextBox txtFullDateAlternateKey = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFullDateAlternateKey");
TextBox txtDayNumberOfWeek = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDayNumberOfWeek");
TextBox txtEnglishDayNameOfWeek = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishDayNameOfWeek");
TextBox txtSpanishDayNameOfWeek = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishDayNameOfWeek");
TextBox txtFrenchDayNameOfWeek = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchDayNameOfWeek");
TextBox txtDayNumberOfMonth = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDayNumberOfMonth");
TextBox txtDayNumberOfYear = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDayNumberOfYear");
TextBox txtWeekNumberOfYear = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtWeekNumberOfYear");
TextBox txtEnglishMonthName = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtEnglishMonthName");
TextBox txtSpanishMonthName = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtSpanishMonthName");
TextBox txtFrenchMonthName = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFrenchMonthName");
TextBox txtMonthNumberOfYear = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtMonthNumberOfYear");
TextBox txtCalendarQuarter = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCalendarQuarter");
TextBox txtCalendarYear = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCalendarYear");
TextBox txtCalendarSemester = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCalendarSemester");
TextBox txtFiscalQuarter = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFiscalQuarter");
TextBox txtFiscalYear = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFiscalYear");
TextBox txtFiscalSemester = (TextBox)grddbo_DimDate.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFiscalSemester");
dbo_DimDateClass oclsdbo_DimDate = new dbo_DimDateClass();
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
oclsdbo_DimDate.DateKey = System.Convert.ToInt32(txtDateKey.Text);
oclsdbo_DimDate = dbo_DimDateDataClass.Select_Record(oclsdbo_DimDate);
if (VerifyData() == true)
{
clsdbo_DimDate.DateKey = System.Convert.ToInt32(txtDateKey.Text);
clsdbo_DimDate.FullDateAlternateKey = System.Convert.ToDateTime(txtFullDateAlternateKey.Text);
clsdbo_DimDate.DayNumberOfWeek = System.Convert.ToByte(txtDayNumberOfWeek.Text);
clsdbo_DimDate.EnglishDayNameOfWeek = System.Convert.ToString(txtEnglishDayNameOfWeek.Text);
clsdbo_DimDate.SpanishDayNameOfWeek = System.Convert.ToString(txtSpanishDayNameOfWeek.Text);
clsdbo_DimDate.FrenchDayNameOfWeek = System.Convert.ToString(txtFrenchDayNameOfWeek.Text);
clsdbo_DimDate.DayNumberOfMonth = System.Convert.ToByte(txtDayNumberOfMonth.Text);
clsdbo_DimDate.DayNumberOfYear = System.Convert.ToInt16(txtDayNumberOfYear.Text);
clsdbo_DimDate.WeekNumberOfYear = System.Convert.ToByte(txtWeekNumberOfYear.Text);
clsdbo_DimDate.EnglishMonthName = System.Convert.ToString(txtEnglishMonthName.Text);
clsdbo_DimDate.SpanishMonthName = System.Convert.ToString(txtSpanishMonthName.Text);
clsdbo_DimDate.FrenchMonthName = System.Convert.ToString(txtFrenchMonthName.Text);
clsdbo_DimDate.MonthNumberOfYear = System.Convert.ToByte(txtMonthNumberOfYear.Text);
clsdbo_DimDate.CalendarQuarter = System.Convert.ToByte(txtCalendarQuarter.Text);
clsdbo_DimDate.CalendarYear = System.Convert.ToInt16(txtCalendarYear.Text);
clsdbo_DimDate.CalendarSemester = System.Convert.ToByte(txtCalendarSemester.Text);
clsdbo_DimDate.FiscalQuarter = System.Convert.ToByte(txtFiscalQuarter.Text);
clsdbo_DimDate.FiscalYear = System.Convert.ToInt16(txtFiscalYear.Text);
clsdbo_DimDate.FiscalSemester = System.Convert.ToByte(txtFiscalSemester.Text);
bool bSucess = false;
bSucess = dbo_DimDateDataClass.Update(oclsdbo_DimDate, clsdbo_DimDate);
if (bSucess == true)
{
Session.Remove("dvdbo_DimDate");
grddbo_DimDate.EditIndex = -1;
LoadGriddbo_DimDate();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Dim Date ");
}
}
} catch {
}
}
private Boolean VerifyData()
{
if (txtDateKey.Text == "")
{
ec.ShowMessage(" Date Key is Required. ", " Dbo. Dim Date ");
txtDateKey.Focus();
return(false);
}
if (txtDayNumberOfWeek.Text == "")
{
ec.ShowMessage(" Day Number Of Week is Required. ", " Dbo. Dim Date ");
txtDayNumberOfWeek.Focus();
return(false);
}
if (txtEnglishDayNameOfWeek.Text == "")
{
ec.ShowMessage(" English Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtEnglishDayNameOfWeek.Focus();
return(false);
}
if (txtSpanishDayNameOfWeek.Text == "")
{
ec.ShowMessage(" Spanish Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtSpanishDayNameOfWeek.Focus();
return(false);
}
if (txtFrenchDayNameOfWeek.Text == "")
{
ec.ShowMessage(" French Day Name Of Week is Required. ", " Dbo. Dim Date ");
txtFrenchDayNameOfWeek.Focus();
return(false);
}
if (txtDayNumberOfMonth.Text == "")
{
ec.ShowMessage(" Day Number Of Month is Required. ", " Dbo. Dim Date ");
txtDayNumberOfMonth.Focus();
return(false);
}
if (txtDayNumberOfYear.Text == "")
{
ec.ShowMessage(" Day Number Of Year is Required. ", " Dbo. Dim Date ");
txtDayNumberOfYear.Focus();
return(false);
}
if (txtWeekNumberOfYear.Text == "")
{
ec.ShowMessage(" Week Number Of Year is Required. ", " Dbo. Dim Date ");
txtWeekNumberOfYear.Focus();
return(false);
}
if (txtEnglishMonthName.Text == "")
{
ec.ShowMessage(" English Month Name is Required. ", " Dbo. Dim Date ");
txtEnglishMonthName.Focus();
return(false);
}
if (txtSpanishMonthName.Text == "")
{
ec.ShowMessage(" Spanish Month Name is Required. ", " Dbo. Dim Date ");
txtSpanishMonthName.Focus();
return(false);
}
if (txtFrenchMonthName.Text == "")
{
ec.ShowMessage(" French Month Name is Required. ", " Dbo. Dim Date ");
txtFrenchMonthName.Focus();
return(false);
}
if (txtMonthNumberOfYear.Text == "")
{
ec.ShowMessage(" Month Number Of Year is Required. ", " Dbo. Dim Date ");
txtMonthNumberOfYear.Focus();
return(false);
}
if (txtCalendarQuarter.Text == "")
{
ec.ShowMessage(" Calendar Quarter is Required. ", " Dbo. Dim Date ");
txtCalendarQuarter.Focus();
return(false);
}
if (txtCalendarYear.Text == "")
{
ec.ShowMessage(" Calendar Year is Required. ", " Dbo. Dim Date ");
txtCalendarYear.Focus();
return(false);
}
if (txtCalendarSemester.Text == "")
{
ec.ShowMessage(" Calendar Semester is Required. ", " Dbo. Dim Date ");
txtCalendarSemester.Focus();
return(false);
}
if (txtFiscalQuarter.Text == "")
{
ec.ShowMessage(" Fiscal Quarter is Required. ", " Dbo. Dim Date ");
txtFiscalQuarter.Focus();
return(false);
}
if (txtFiscalYear.Text == "")
{
ec.ShowMessage(" Fiscal Year is Required. ", " Dbo. Dim Date ");
txtFiscalYear.Focus();
return(false);
}
if (txtFiscalSemester.Text == "")
{
ec.ShowMessage(" Fiscal Semester is Required. ", " Dbo. Dim Date ");
txtFiscalSemester.Focus();
return(false);
}
if (
txtDateKey.Text != ""
)
{
dbo_DimDateClass clsdbo_DimDate = new dbo_DimDateClass();
clsdbo_DimDate.DateKey = System.Convert.ToInt32(txtDateKey.Text);
clsdbo_DimDate = dbo_DimDateDataClass.Select_Record(clsdbo_DimDate);
if (clsdbo_DimDate != null && (String)Session["Mode"] == "Add")
{
ec.ShowMessage(" Record already exists. ", " Dbo. Dim Date ");
txtDateKey.Focus();
return(false);
}
}
return(true);
}