private void GetData()
{
ClearRecord();
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
clsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(Session["DBVersion"]);
clsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(clsdbo_AdventureWorksDWBuildVersion);
if ((clsdbo_AdventureWorksDWBuildVersion != null))
{
try {
if (clsdbo_AdventureWorksDWBuildVersion.DBVersion == null)
{
txtDBVersion.Text = default(string);
}
else
{
txtDBVersion.Text = System.Convert.ToString(clsdbo_AdventureWorksDWBuildVersion.DBVersion);
}
if (clsdbo_AdventureWorksDWBuildVersion.VersionDate == null)
{
txtVersionDate.Text = DateTime.Now.ToString();
}
else
{
txtVersionDate.Text = System.Convert.ToDateTime(clsdbo_AdventureWorksDWBuildVersion.VersionDate).ToShortDateString();
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Adventure Works D W Build Version ");
}
}
}
private void UpdateRecord()
{
dbo_AdventureWorksDWBuildVersionClass oclsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
oclsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(Session["DBVersion"]);
oclsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(oclsdbo_AdventureWorksDWBuildVersion);
if (VerifyData() == true)
{
SetData(clsdbo_AdventureWorksDWBuildVersion);
bool bSucess = false;
bSucess = dbo_AdventureWorksDWBuildVersionDataClass.Update(oclsdbo_AdventureWorksDWBuildVersion, clsdbo_AdventureWorksDWBuildVersion);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_AdventureWorksDWBuildVersion");
LoadGriddbo_AdventureWorksDWBuildVersion();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Adventure Works D W Build Version ");
}
}
}
public static bool Add(dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[AdventureWorksDWBuildVersion] "
+ " ( "
+ " [DBVersion] "
+ " ,[VersionDate] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @DBVersion "
+ " ,@VersionDate "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
if (clsdbo_AdventureWorksDWBuildVersion.DBVersion != null)
{
insertCommand.Parameters.AddWithValue("@DBVersion", clsdbo_AdventureWorksDWBuildVersion.DBVersion);
}
else
{
insertCommand.Parameters.AddWithValue("@DBVersion", DBNull.Value);
}
if (clsdbo_AdventureWorksDWBuildVersion.VersionDate.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@VersionDate", clsdbo_AdventureWorksDWBuildVersion.VersionDate);
}
else
{
insertCommand.Parameters.AddWithValue("@VersionDate", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void Edit()
{
try {
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
Label lblDBVersion = (Label)grddbo_AdventureWorksDWBuildVersion.Rows[grddbo_AdventureWorksDWBuildVersion.EditIndex].FindControl("lblDBVersion");
clsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(lblDBVersion.Text);
clsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(clsdbo_AdventureWorksDWBuildVersion);
LoadGriddbo_AdventureWorksDWBuildVersion();
} catch {
}
}
public static bool Delete(dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[AdventureWorksDWBuildVersion] "
+ "WHERE "
+ " ((@OldDBVersion IS NULL AND [DBVersion] IS NULL) OR [DBVersion] = @OldDBVersion) "
+ " AND ((@OldVersionDate IS NULL AND [VersionDate] IS NULL) OR [VersionDate] = @OldVersionDate) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
if (clsdbo_AdventureWorksDWBuildVersion.DBVersion != null)
{
deleteCommand.Parameters.AddWithValue("@OldDBVersion", clsdbo_AdventureWorksDWBuildVersion.DBVersion);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldDBVersion", DBNull.Value);
}
if (clsdbo_AdventureWorksDWBuildVersion.VersionDate.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldVersionDate", clsdbo_AdventureWorksDWBuildVersion.VersionDate);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldVersionDate", DBNull.Value);
}
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
private void UpdateRecord()
{
try {
TextBox txtDBVersion = (TextBox)grddbo_AdventureWorksDWBuildVersion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDBVersion");
TextBox txtVersionDate = (TextBox)grddbo_AdventureWorksDWBuildVersion.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtVersionDate");
dbo_AdventureWorksDWBuildVersionClass oclsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
oclsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(txtDBVersion.Text);
oclsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(oclsdbo_AdventureWorksDWBuildVersion);
if (VerifyData() == true)
{
if (string.IsNullOrEmpty(txtDBVersion.Text))
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = txtDBVersion.Text;
}
if (string.IsNullOrEmpty(txtVersionDate.Text))
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = System.Convert.ToDateTime(txtVersionDate.Text);
}
bool bSucess = false;
bSucess = dbo_AdventureWorksDWBuildVersionDataClass.Update(oclsdbo_AdventureWorksDWBuildVersion, clsdbo_AdventureWorksDWBuildVersion);
if (bSucess == true)
{
Session.Remove("dvdbo_AdventureWorksDWBuildVersion");
grddbo_AdventureWorksDWBuildVersion.EditIndex = -1;
LoadGriddbo_AdventureWorksDWBuildVersion();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Adventure Works D W Build Version ");
}
}
} catch {
}
}
private Boolean VerifyData()
{
if (
txtDBVersion.Text != ""
)
{
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
clsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(txtDBVersion.Text);
clsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(clsdbo_AdventureWorksDWBuildVersion);
if (clsdbo_AdventureWorksDWBuildVersion != null && (String)Session["Mode"] == "Add")
{
ec.ShowMessage(" Record already exists. ", " Dbo. Adventure Works D W Build Version ");
txtDBVersion.Focus();
return(false);
}
}
return(true);
}
private void SetData(dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion)
{
if (string.IsNullOrEmpty(txtDBVersion.Text))
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = txtDBVersion.Text;
}
if (string.IsNullOrEmpty(txtVersionDate.Text))
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = System.Convert.ToDateTime(txtVersionDate.Text);
}
}
public static dbo_AdventureWorksDWBuildVersionClass Select_Record(dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersionPara)
{
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [DBVersion] "
+ " ,[VersionDate] "
+ "FROM "
+ " [dbo].[AdventureWorksDWBuildVersion] "
+ "WHERE "
+ " [DBVersion] = @DBVersion "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@DBVersion", clsdbo_AdventureWorksDWBuildVersionPara.DBVersion);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = reader["DBVersion"] is DBNull ? null : reader["DBVersion"].ToString();
clsdbo_AdventureWorksDWBuildVersion.VersionDate = reader["VersionDate"] is DBNull ? null : (DateTime?)reader["VersionDate"];
}
else
{
clsdbo_AdventureWorksDWBuildVersion = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_AdventureWorksDWBuildVersion);
}
finally
{
connection.Close();
}
return(clsdbo_AdventureWorksDWBuildVersion);
}
private void DeleteRecord()
{
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
Label lblDBVersion = (Label)grddbo_AdventureWorksDWBuildVersion.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblDBVersion");
clsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(lblDBVersion.Text);
clsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(clsdbo_AdventureWorksDWBuildVersion);
bool bSucess = false;
bSucess = dbo_AdventureWorksDWBuildVersionDataClass.Delete(clsdbo_AdventureWorksDWBuildVersion);
if (bSucess == true)
{
Session.Remove("dvdbo_AdventureWorksDWBuildVersion");
LoadGriddbo_AdventureWorksDWBuildVersion();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Adventure Works D W Build Version ");
}
}
private Boolean VerifyDataNew()
{
TextBox txtNewDBVersion = (TextBox)grddbo_AdventureWorksDWBuildVersion.FooterRow.FindControl("txtNewDBVersion");
TextBox txtNewVersionDate = (TextBox)grddbo_AdventureWorksDWBuildVersion.FooterRow.FindControl("txtNewVersionDate");
if (
txtNewDBVersion.Text != ""
)
{
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
clsdbo_AdventureWorksDWBuildVersion.DBVersion = System.Convert.ToString(txtNewDBVersion.Text);
clsdbo_AdventureWorksDWBuildVersion = dbo_AdventureWorksDWBuildVersionDataClass.Select_Record(clsdbo_AdventureWorksDWBuildVersion);
if (clsdbo_AdventureWorksDWBuildVersion != null)
{
ec.ShowMessage(" Record already exists. ", " Dbo. Adventure Works D W Build Version ");
txtNewDBVersion.Focus();
return(false);
}
}
return(true);
}
private void InsertRecord()
{
try {
TextBox txtNewDBVersion = (TextBox)grddbo_AdventureWorksDWBuildVersion.FooterRow.FindControl("txtNewDBVersion");
TextBox txtNewVersionDate = (TextBox)grddbo_AdventureWorksDWBuildVersion.FooterRow.FindControl("txtNewVersionDate");
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
if (VerifyDataNew() == true)
{
if (string.IsNullOrEmpty(txtNewDBVersion.Text))
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.DBVersion = txtNewDBVersion.Text;
}
if (string.IsNullOrEmpty(txtNewVersionDate.Text))
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = null;
}
else
{
clsdbo_AdventureWorksDWBuildVersion.VersionDate = System.Convert.ToDateTime(txtNewVersionDate.Text);
}
bool bSucess = false;
bSucess = dbo_AdventureWorksDWBuildVersionDataClass.Add(clsdbo_AdventureWorksDWBuildVersion);
if (bSucess == true)
{
Session.Remove("dvdbo_AdventureWorksDWBuildVersion");
LoadGriddbo_AdventureWorksDWBuildVersion();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Adventure Works D W Build Version ");
}
}
} catch {
}
}
private void InsertRecord()
{
dbo_AdventureWorksDWBuildVersionClass clsdbo_AdventureWorksDWBuildVersion = new dbo_AdventureWorksDWBuildVersionClass();
if (VerifyData() == true)
{
SetData(clsdbo_AdventureWorksDWBuildVersion);
bool bSucess = false;
bSucess = dbo_AdventureWorksDWBuildVersionDataClass.Add(clsdbo_AdventureWorksDWBuildVersion);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_AdventureWorksDWBuildVersion");
LoadGriddbo_AdventureWorksDWBuildVersion();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Adventure Works D W Build Version ");
}
}
}
public static bool Update(dbo_AdventureWorksDWBuildVersionClass olddbo_AdventureWorksDWBuildVersionClass,
dbo_AdventureWorksDWBuildVersionClass newdbo_AdventureWorksDWBuildVersionClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[AdventureWorksDWBuildVersion] "
+ "SET "
+ " [DBVersion] = @NewDBVersion "
+ " ,[VersionDate] = @NewVersionDate "
+ "WHERE "
+ " ((@OldDBVersion IS NULL AND [DBVersion] IS NULL) OR [DBVersion] = @OldDBVersion) "
+ " AND ((@OldVersionDate IS NULL AND [VersionDate] IS NULL) OR [VersionDate] = @OldVersionDate) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
if (newdbo_AdventureWorksDWBuildVersionClass.DBVersion != null)
{
updateCommand.Parameters.AddWithValue("@NewDBVersion", newdbo_AdventureWorksDWBuildVersionClass.DBVersion);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDBVersion", DBNull.Value);
}
if (newdbo_AdventureWorksDWBuildVersionClass.VersionDate.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewVersionDate", newdbo_AdventureWorksDWBuildVersionClass.VersionDate);
}
else
{
updateCommand.Parameters.AddWithValue("@NewVersionDate", DBNull.Value);
}
if (olddbo_AdventureWorksDWBuildVersionClass.DBVersion != null)
{
updateCommand.Parameters.AddWithValue("@OldDBVersion", olddbo_AdventureWorksDWBuildVersionClass.DBVersion);
}
else
{
updateCommand.Parameters.AddWithValue("@OldDBVersion", DBNull.Value);
}
if (olddbo_AdventureWorksDWBuildVersionClass.VersionDate.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldVersionDate", olddbo_AdventureWorksDWBuildVersionClass.VersionDate);
}
else
{
updateCommand.Parameters.AddWithValue("@OldVersionDate", DBNull.Value);
}
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
