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(); } }