private void UpdateRecord()
{
dbo_FactCallCenterClass oclsdbo_FactCallCenter = new dbo_FactCallCenterClass();
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
oclsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(Session["FactCallCenterID"]);
oclsdbo_FactCallCenter = dbo_FactCallCenterDataClass.Select_Record(oclsdbo_FactCallCenter);
if (VerifyData() == true)
{
SetData(clsdbo_FactCallCenter);
bool bSucess = false;
bSucess = dbo_FactCallCenterDataClass.Update(oclsdbo_FactCallCenter, clsdbo_FactCallCenter);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactCallCenter");
LoadGriddbo_FactCallCenter();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Call Center ");
}
}
}
private void InsertRecord()
{
try {
DropDownList txtNewDateKey = (DropDownList)grddbo_FactCallCenter.FooterRow.FindControl("txtNewDateKey");
TextBox txtNewWageType = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewWageType");
TextBox txtNewShift = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewShift");
TextBox txtNewLevelOneOperators = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewLevelOneOperators");
TextBox txtNewLevelTwoOperators = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewLevelTwoOperators");
TextBox txtNewTotalOperators = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewTotalOperators");
TextBox txtNewCalls = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewCalls");
TextBox txtNewAutomaticResponses = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewAutomaticResponses");
TextBox txtNewOrders = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewOrders");
TextBox txtNewIssuesRaised = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewIssuesRaised");
TextBox txtNewAverageTimePerIssue = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewAverageTimePerIssue");
TextBox txtNewServiceGrade = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewServiceGrade");
TextBox txtNewDate = (TextBox)grddbo_FactCallCenter.FooterRow.FindControl("txtNewDate");
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
if (VerifyDataNew() == true)
{
clsdbo_FactCallCenter.DateKey = System.Convert.ToInt32(txtNewDateKey.SelectedValue);
clsdbo_FactCallCenter.WageType = System.Convert.ToString(txtNewWageType.Text);
clsdbo_FactCallCenter.Shift = System.Convert.ToString(txtNewShift.Text);
clsdbo_FactCallCenter.LevelOneOperators = System.Convert.ToInt16(txtNewLevelOneOperators.Text);
clsdbo_FactCallCenter.LevelTwoOperators = System.Convert.ToInt16(txtNewLevelTwoOperators.Text);
clsdbo_FactCallCenter.TotalOperators = System.Convert.ToInt16(txtNewTotalOperators.Text);
clsdbo_FactCallCenter.Calls = System.Convert.ToInt32(txtNewCalls.Text);
clsdbo_FactCallCenter.AutomaticResponses = System.Convert.ToInt32(txtNewAutomaticResponses.Text);
clsdbo_FactCallCenter.Orders = System.Convert.ToInt32(txtNewOrders.Text);
clsdbo_FactCallCenter.IssuesRaised = System.Convert.ToInt16(txtNewIssuesRaised.Text);
clsdbo_FactCallCenter.AverageTimePerIssue = System.Convert.ToInt16(txtNewAverageTimePerIssue.Text);
clsdbo_FactCallCenter.ServiceGrade = System.Convert.ToDecimal(txtNewServiceGrade.Text);
if (string.IsNullOrEmpty(txtNewDate.Text))
{
clsdbo_FactCallCenter.Date = null;
}
else
{
clsdbo_FactCallCenter.Date = System.Convert.ToDateTime(txtNewDate.Text);
}
bool bSucess = false;
bSucess = dbo_FactCallCenterDataClass.Add(clsdbo_FactCallCenter);
if (bSucess == true)
{
Session.Remove("dvdbo_FactCallCenter");
LoadGriddbo_FactCallCenter();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Call Center ");
}
}
} catch {
}
}
private void Edit()
{
try {
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
Label lblFactCallCenterID = (Label)grddbo_FactCallCenter.Rows[grddbo_FactCallCenter.EditIndex].FindControl("lblFactCallCenterID");
clsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(lblFactCallCenterID.Text);
clsdbo_FactCallCenter = dbo_FactCallCenterDataClass.Select_Record(clsdbo_FactCallCenter);
Session["DateKey_SelectedValue"] = clsdbo_FactCallCenter.DateKey;
LoadGriddbo_FactCallCenter();
} catch {
}
}
private void DeleteRecord()
{
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
Label lblFactCallCenterID = (Label)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("lblFactCallCenterID");
clsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(lblFactCallCenterID.Text);
clsdbo_FactCallCenter = dbo_FactCallCenterDataClass.Select_Record(clsdbo_FactCallCenter);
bool bSucess = false;
bSucess = dbo_FactCallCenterDataClass.Delete(clsdbo_FactCallCenter);
if (bSucess == true)
{
Session.Remove("dvdbo_FactCallCenter");
LoadGriddbo_FactCallCenter();
}
else
{
ec.ShowMessage(" Delete failed. ", " Dbo. Fact Call Center ");
}
}
private void GetData()
{
ClearRecord();
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
clsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(Session["FactCallCenterID"]);
clsdbo_FactCallCenter = dbo_FactCallCenterDataClass.Select_Record(clsdbo_FactCallCenter);
if ((clsdbo_FactCallCenter != null))
{
try {
txtFactCallCenterID.Text = System.Convert.ToString(clsdbo_FactCallCenter.FactCallCenterID);
txtDateKey.SelectedValue = System.Convert.ToString(clsdbo_FactCallCenter.DateKey);
txtWageType.Text = System.Convert.ToString(clsdbo_FactCallCenter.WageType);
txtShift.Text = System.Convert.ToString(clsdbo_FactCallCenter.Shift);
txtLevelOneOperators.Text = System.Convert.ToString(clsdbo_FactCallCenter.LevelOneOperators);
txtLevelTwoOperators.Text = System.Convert.ToString(clsdbo_FactCallCenter.LevelTwoOperators);
txtTotalOperators.Text = System.Convert.ToString(clsdbo_FactCallCenter.TotalOperators);
txtCalls.Text = System.Convert.ToString(clsdbo_FactCallCenter.Calls);
txtAutomaticResponses.Text = System.Convert.ToString(clsdbo_FactCallCenter.AutomaticResponses);
txtOrders.Text = System.Convert.ToString(clsdbo_FactCallCenter.Orders);
txtIssuesRaised.Text = System.Convert.ToString(clsdbo_FactCallCenter.IssuesRaised);
txtAverageTimePerIssue.Text = System.Convert.ToString(clsdbo_FactCallCenter.AverageTimePerIssue);
txtServiceGrade.Text = System.Convert.ToString(clsdbo_FactCallCenter.ServiceGrade);
if (clsdbo_FactCallCenter.Date == null)
{
txtDate.Text = DateTime.Now.ToString();
}
else
{
txtDate.Text = System.Convert.ToDateTime(clsdbo_FactCallCenter.Date).ToShortDateString();
}
}
catch (Exception ex)
{
ec.ShowMessage(ex.Message, " Dbo. Fact Call Center ");
}
}
}
private void SetData(dbo_FactCallCenterClass clsdbo_FactCallCenter)
{
clsdbo_FactCallCenter.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue);
clsdbo_FactCallCenter.WageType = System.Convert.ToString(txtWageType.Text);
clsdbo_FactCallCenter.Shift = System.Convert.ToString(txtShift.Text);
clsdbo_FactCallCenter.LevelOneOperators = System.Convert.ToInt16(txtLevelOneOperators.Text);
clsdbo_FactCallCenter.LevelTwoOperators = System.Convert.ToInt16(txtLevelTwoOperators.Text);
clsdbo_FactCallCenter.TotalOperators = System.Convert.ToInt16(txtTotalOperators.Text);
clsdbo_FactCallCenter.Calls = System.Convert.ToInt32(txtCalls.Text);
clsdbo_FactCallCenter.AutomaticResponses = System.Convert.ToInt32(txtAutomaticResponses.Text);
clsdbo_FactCallCenter.Orders = System.Convert.ToInt32(txtOrders.Text);
clsdbo_FactCallCenter.IssuesRaised = System.Convert.ToInt16(txtIssuesRaised.Text);
clsdbo_FactCallCenter.AverageTimePerIssue = System.Convert.ToInt16(txtAverageTimePerIssue.Text);
clsdbo_FactCallCenter.ServiceGrade = System.Convert.ToDecimal(txtServiceGrade.Text);
if (string.IsNullOrEmpty(txtDate.Text))
{
clsdbo_FactCallCenter.Date = null;
}
else
{
clsdbo_FactCallCenter.Date = System.Convert.ToDateTime(txtDate.Text);
}
}
private void InsertRecord()
{
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
if (VerifyData() == true)
{
SetData(clsdbo_FactCallCenter);
bool bSucess = false;
bSucess = dbo_FactCallCenterDataClass.Add(clsdbo_FactCallCenter);
if (bSucess == true)
{
pnlForm.Visible = false;
pnlSave.Visible = false;
pnlGrid.Visible = true;
lblMode.InnerText = "";
Session.Remove("dvdbo_FactCallCenter");
LoadGriddbo_FactCallCenter();
}
else
{
ec.ShowMessage(" Insert failed. ", " Dbo. Fact Call Center ");
}
}
}
public static bool Delete(dbo_FactCallCenterClass clsdbo_FactCallCenter)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [dbo].[FactCallCenter] "
+ "WHERE "
+ " [FactCallCenterID] = @OldFactCallCenterID "
+ " AND [DateKey] = @OldDateKey "
+ " AND [WageType] = @OldWageType "
+ " AND [Shift] = @OldShift "
+ " AND [LevelOneOperators] = @OldLevelOneOperators "
+ " AND [LevelTwoOperators] = @OldLevelTwoOperators "
+ " AND [TotalOperators] = @OldTotalOperators "
+ " AND [Calls] = @OldCalls "
+ " AND [AutomaticResponses] = @OldAutomaticResponses "
+ " AND [Orders] = @OldOrders "
+ " AND [IssuesRaised] = @OldIssuesRaised "
+ " AND [AverageTimePerIssue] = @OldAverageTimePerIssue "
+ " AND [ServiceGrade] = @OldServiceGrade "
+ " AND ((@OldDate IS NULL AND [Date] IS NULL) OR [Date] = @OldDate) "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldFactCallCenterID", clsdbo_FactCallCenter.FactCallCenterID);
deleteCommand.Parameters.AddWithValue("@OldDateKey", clsdbo_FactCallCenter.DateKey);
deleteCommand.Parameters.AddWithValue("@OldWageType", clsdbo_FactCallCenter.WageType);
deleteCommand.Parameters.AddWithValue("@OldShift", clsdbo_FactCallCenter.Shift);
deleteCommand.Parameters.AddWithValue("@OldLevelOneOperators", clsdbo_FactCallCenter.LevelOneOperators);
deleteCommand.Parameters.AddWithValue("@OldLevelTwoOperators", clsdbo_FactCallCenter.LevelTwoOperators);
deleteCommand.Parameters.AddWithValue("@OldTotalOperators", clsdbo_FactCallCenter.TotalOperators);
deleteCommand.Parameters.AddWithValue("@OldCalls", clsdbo_FactCallCenter.Calls);
deleteCommand.Parameters.AddWithValue("@OldAutomaticResponses", clsdbo_FactCallCenter.AutomaticResponses);
deleteCommand.Parameters.AddWithValue("@OldOrders", clsdbo_FactCallCenter.Orders);
deleteCommand.Parameters.AddWithValue("@OldIssuesRaised", clsdbo_FactCallCenter.IssuesRaised);
deleteCommand.Parameters.AddWithValue("@OldAverageTimePerIssue", clsdbo_FactCallCenter.AverageTimePerIssue);
deleteCommand.Parameters.AddWithValue("@OldServiceGrade", clsdbo_FactCallCenter.ServiceGrade);
if (clsdbo_FactCallCenter.Date.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldDate", clsdbo_FactCallCenter.Date);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldDate", DBNull.Value);
}
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool Update(dbo_FactCallCenterClass olddbo_FactCallCenterClass,
dbo_FactCallCenterClass newdbo_FactCallCenterClass)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string updateStatement
= "UPDATE "
+ " [dbo].[FactCallCenter] "
+ "SET "
+ " [DateKey] = @NewDateKey "
+ " ,[WageType] = @NewWageType "
+ " ,[Shift] = @NewShift "
+ " ,[LevelOneOperators] = @NewLevelOneOperators "
+ " ,[LevelTwoOperators] = @NewLevelTwoOperators "
+ " ,[TotalOperators] = @NewTotalOperators "
+ " ,[Calls] = @NewCalls "
+ " ,[AutomaticResponses] = @NewAutomaticResponses "
+ " ,[Orders] = @NewOrders "
+ " ,[IssuesRaised] = @NewIssuesRaised "
+ " ,[AverageTimePerIssue] = @NewAverageTimePerIssue "
+ " ,[ServiceGrade] = @NewServiceGrade "
+ " ,[Date] = @NewDate "
+ "WHERE "
+ " [FactCallCenterID] = @OldFactCallCenterID "
+ " AND [DateKey] = @OldDateKey "
+ " AND [WageType] = @OldWageType "
+ " AND [Shift] = @OldShift "
+ " AND [LevelOneOperators] = @OldLevelOneOperators "
+ " AND [LevelTwoOperators] = @OldLevelTwoOperators "
+ " AND [TotalOperators] = @OldTotalOperators "
+ " AND [Calls] = @OldCalls "
+ " AND [AutomaticResponses] = @OldAutomaticResponses "
+ " AND [Orders] = @OldOrders "
+ " AND [IssuesRaised] = @OldIssuesRaised "
+ " AND [AverageTimePerIssue] = @OldAverageTimePerIssue "
+ " AND [ServiceGrade] = @OldServiceGrade "
+ " AND ((@OldDate IS NULL AND [Date] IS NULL) OR [Date] = @OldDate) "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewDateKey", newdbo_FactCallCenterClass.DateKey);
updateCommand.Parameters.AddWithValue("@NewWageType", newdbo_FactCallCenterClass.WageType);
updateCommand.Parameters.AddWithValue("@NewShift", newdbo_FactCallCenterClass.Shift);
updateCommand.Parameters.AddWithValue("@NewLevelOneOperators", newdbo_FactCallCenterClass.LevelOneOperators);
updateCommand.Parameters.AddWithValue("@NewLevelTwoOperators", newdbo_FactCallCenterClass.LevelTwoOperators);
updateCommand.Parameters.AddWithValue("@NewTotalOperators", newdbo_FactCallCenterClass.TotalOperators);
updateCommand.Parameters.AddWithValue("@NewCalls", newdbo_FactCallCenterClass.Calls);
updateCommand.Parameters.AddWithValue("@NewAutomaticResponses", newdbo_FactCallCenterClass.AutomaticResponses);
updateCommand.Parameters.AddWithValue("@NewOrders", newdbo_FactCallCenterClass.Orders);
updateCommand.Parameters.AddWithValue("@NewIssuesRaised", newdbo_FactCallCenterClass.IssuesRaised);
updateCommand.Parameters.AddWithValue("@NewAverageTimePerIssue", newdbo_FactCallCenterClass.AverageTimePerIssue);
updateCommand.Parameters.AddWithValue("@NewServiceGrade", newdbo_FactCallCenterClass.ServiceGrade);
if (newdbo_FactCallCenterClass.Date.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewDate", newdbo_FactCallCenterClass.Date);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDate", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@OldFactCallCenterID", olddbo_FactCallCenterClass.FactCallCenterID);
updateCommand.Parameters.AddWithValue("@OldDateKey", olddbo_FactCallCenterClass.DateKey);
updateCommand.Parameters.AddWithValue("@OldWageType", olddbo_FactCallCenterClass.WageType);
updateCommand.Parameters.AddWithValue("@OldShift", olddbo_FactCallCenterClass.Shift);
updateCommand.Parameters.AddWithValue("@OldLevelOneOperators", olddbo_FactCallCenterClass.LevelOneOperators);
updateCommand.Parameters.AddWithValue("@OldLevelTwoOperators", olddbo_FactCallCenterClass.LevelTwoOperators);
updateCommand.Parameters.AddWithValue("@OldTotalOperators", olddbo_FactCallCenterClass.TotalOperators);
updateCommand.Parameters.AddWithValue("@OldCalls", olddbo_FactCallCenterClass.Calls);
updateCommand.Parameters.AddWithValue("@OldAutomaticResponses", olddbo_FactCallCenterClass.AutomaticResponses);
updateCommand.Parameters.AddWithValue("@OldOrders", olddbo_FactCallCenterClass.Orders);
updateCommand.Parameters.AddWithValue("@OldIssuesRaised", olddbo_FactCallCenterClass.IssuesRaised);
updateCommand.Parameters.AddWithValue("@OldAverageTimePerIssue", olddbo_FactCallCenterClass.AverageTimePerIssue);
updateCommand.Parameters.AddWithValue("@OldServiceGrade", olddbo_FactCallCenterClass.ServiceGrade);
if (olddbo_FactCallCenterClass.Date.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldDate", olddbo_FactCallCenterClass.Date);
}
else
{
updateCommand.Parameters.AddWithValue("@OldDate", DBNull.Value);
}
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static bool Add(dbo_FactCallCenterClass clsdbo_FactCallCenter)
{
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string insertStatement
= "INSERT "
+ " [dbo].[FactCallCenter] "
+ " ( "
+ " [DateKey] "
+ " ,[WageType] "
+ " ,[Shift] "
+ " ,[LevelOneOperators] "
+ " ,[LevelTwoOperators] "
+ " ,[TotalOperators] "
+ " ,[Calls] "
+ " ,[AutomaticResponses] "
+ " ,[Orders] "
+ " ,[IssuesRaised] "
+ " ,[AverageTimePerIssue] "
+ " ,[ServiceGrade] "
+ " ,[Date] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @DateKey "
+ " ,@WageType "
+ " ,@Shift "
+ " ,@LevelOneOperators "
+ " ,@LevelTwoOperators "
+ " ,@TotalOperators "
+ " ,@Calls "
+ " ,@AutomaticResponses "
+ " ,@Orders "
+ " ,@IssuesRaised "
+ " ,@AverageTimePerIssue "
+ " ,@ServiceGrade "
+ " ,@Date "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@DateKey", clsdbo_FactCallCenter.DateKey);
insertCommand.Parameters.AddWithValue("@WageType", clsdbo_FactCallCenter.WageType);
insertCommand.Parameters.AddWithValue("@Shift", clsdbo_FactCallCenter.Shift);
insertCommand.Parameters.AddWithValue("@LevelOneOperators", clsdbo_FactCallCenter.LevelOneOperators);
insertCommand.Parameters.AddWithValue("@LevelTwoOperators", clsdbo_FactCallCenter.LevelTwoOperators);
insertCommand.Parameters.AddWithValue("@TotalOperators", clsdbo_FactCallCenter.TotalOperators);
insertCommand.Parameters.AddWithValue("@Calls", clsdbo_FactCallCenter.Calls);
insertCommand.Parameters.AddWithValue("@AutomaticResponses", clsdbo_FactCallCenter.AutomaticResponses);
insertCommand.Parameters.AddWithValue("@Orders", clsdbo_FactCallCenter.Orders);
insertCommand.Parameters.AddWithValue("@IssuesRaised", clsdbo_FactCallCenter.IssuesRaised);
insertCommand.Parameters.AddWithValue("@AverageTimePerIssue", clsdbo_FactCallCenter.AverageTimePerIssue);
insertCommand.Parameters.AddWithValue("@ServiceGrade", clsdbo_FactCallCenter.ServiceGrade);
if (clsdbo_FactCallCenter.Date.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Date", clsdbo_FactCallCenter.Date);
}
else
{
insertCommand.Parameters.AddWithValue("@Date", DBNull.Value);
}
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public static dbo_FactCallCenterClass Select_Record(dbo_FactCallCenterClass clsdbo_FactCallCenterPara)
{
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
SqlConnection connection = AdventureWorksDW2012DataClass.GetConnection();
string selectStatement
= "SELECT "
+ " [FactCallCenterID] "
+ " ,[DateKey] "
+ " ,[WageType] "
+ " ,[Shift] "
+ " ,[LevelOneOperators] "
+ " ,[LevelTwoOperators] "
+ " ,[TotalOperators] "
+ " ,[Calls] "
+ " ,[AutomaticResponses] "
+ " ,[Orders] "
+ " ,[IssuesRaised] "
+ " ,[AverageTimePerIssue] "
+ " ,[ServiceGrade] "
+ " ,[Date] "
+ "FROM "
+ " [dbo].[FactCallCenter] "
+ "WHERE "
+ " [FactCallCenterID] = @FactCallCenterID "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@FactCallCenterID", clsdbo_FactCallCenterPara.FactCallCenterID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(reader["FactCallCenterID"]);
clsdbo_FactCallCenter.DateKey = System.Convert.ToInt32(reader["DateKey"]);
clsdbo_FactCallCenter.WageType = System.Convert.ToString(reader["WageType"]);
clsdbo_FactCallCenter.Shift = System.Convert.ToString(reader["Shift"]);
clsdbo_FactCallCenter.LevelOneOperators = System.Convert.ToInt16(reader["LevelOneOperators"]);
clsdbo_FactCallCenter.LevelTwoOperators = System.Convert.ToInt16(reader["LevelTwoOperators"]);
clsdbo_FactCallCenter.TotalOperators = System.Convert.ToInt16(reader["TotalOperators"]);
clsdbo_FactCallCenter.Calls = System.Convert.ToInt32(reader["Calls"]);
clsdbo_FactCallCenter.AutomaticResponses = System.Convert.ToInt32(reader["AutomaticResponses"]);
clsdbo_FactCallCenter.Orders = System.Convert.ToInt32(reader["Orders"]);
clsdbo_FactCallCenter.IssuesRaised = System.Convert.ToInt16(reader["IssuesRaised"]);
clsdbo_FactCallCenter.AverageTimePerIssue = System.Convert.ToInt16(reader["AverageTimePerIssue"]);
clsdbo_FactCallCenter.ServiceGrade = System.Convert.ToDecimal(reader["ServiceGrade"]);
clsdbo_FactCallCenter.Date = reader["Date"] is DBNull ? null : (DateTime?)reader["Date"];
}
else
{
clsdbo_FactCallCenter = null;
}
reader.Close();
}
catch (SqlException)
{
return(clsdbo_FactCallCenter);
}
finally
{
connection.Close();
}
return(clsdbo_FactCallCenter);
}
private void UpdateRecord()
{
try {
TextBox txtFactCallCenterID = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtFactCallCenterID");
DropDownList txtDateKey = (DropDownList)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDateKey");
TextBox txtWageType = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtWageType");
TextBox txtShift = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtShift");
TextBox txtLevelOneOperators = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtLevelOneOperators");
TextBox txtLevelTwoOperators = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtLevelTwoOperators");
TextBox txtTotalOperators = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtTotalOperators");
TextBox txtCalls = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtCalls");
TextBox txtAutomaticResponses = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAutomaticResponses");
TextBox txtOrders = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtOrders");
TextBox txtIssuesRaised = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtIssuesRaised");
TextBox txtAverageTimePerIssue = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtAverageTimePerIssue");
TextBox txtServiceGrade = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtServiceGrade");
TextBox txtDate = (TextBox)grddbo_FactCallCenter.Rows[Convert.ToInt32(Session["Row"])].FindControl("txtDate");
dbo_FactCallCenterClass oclsdbo_FactCallCenter = new dbo_FactCallCenterClass();
dbo_FactCallCenterClass clsdbo_FactCallCenter = new dbo_FactCallCenterClass();
oclsdbo_FactCallCenter.FactCallCenterID = System.Convert.ToInt32(txtFactCallCenterID.Text);
oclsdbo_FactCallCenter = dbo_FactCallCenterDataClass.Select_Record(oclsdbo_FactCallCenter);
if (VerifyData() == true)
{
clsdbo_FactCallCenter.DateKey = System.Convert.ToInt32(txtDateKey.SelectedValue);
clsdbo_FactCallCenter.WageType = System.Convert.ToString(txtWageType.Text);
clsdbo_FactCallCenter.Shift = System.Convert.ToString(txtShift.Text);
clsdbo_FactCallCenter.LevelOneOperators = System.Convert.ToInt16(txtLevelOneOperators.Text);
clsdbo_FactCallCenter.LevelTwoOperators = System.Convert.ToInt16(txtLevelTwoOperators.Text);
clsdbo_FactCallCenter.TotalOperators = System.Convert.ToInt16(txtTotalOperators.Text);
clsdbo_FactCallCenter.Calls = System.Convert.ToInt32(txtCalls.Text);
clsdbo_FactCallCenter.AutomaticResponses = System.Convert.ToInt32(txtAutomaticResponses.Text);
clsdbo_FactCallCenter.Orders = System.Convert.ToInt32(txtOrders.Text);
clsdbo_FactCallCenter.IssuesRaised = System.Convert.ToInt16(txtIssuesRaised.Text);
clsdbo_FactCallCenter.AverageTimePerIssue = System.Convert.ToInt16(txtAverageTimePerIssue.Text);
clsdbo_FactCallCenter.ServiceGrade = System.Convert.ToDecimal(txtServiceGrade.Text);
if (string.IsNullOrEmpty(txtDate.Text))
{
clsdbo_FactCallCenter.Date = null;
}
else
{
clsdbo_FactCallCenter.Date = System.Convert.ToDateTime(txtDate.Text);
}
bool bSucess = false;
bSucess = dbo_FactCallCenterDataClass.Update(oclsdbo_FactCallCenter, clsdbo_FactCallCenter);
if (bSucess == true)
{
Session.Remove("dvdbo_FactCallCenter");
grddbo_FactCallCenter.EditIndex = -1;
LoadGriddbo_FactCallCenter();
}
else
{
ec.ShowMessage(" Update failed. ", " Dbo. Fact Call Center ");
}
}
} catch {
}
}
