public MainOfficeType GetDetails(int mainOfficeTypeID)
{
MainOfficeType mainOfficeType = new MainOfficeType();
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeTypeID)
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_GetDetails", CommandType.StoredProcedure, parametersMainOfficeType))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
mainOfficeType.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0;
mainOfficeType.ContractualEmployeesNumber = (row["ContractualEmployeesNumber"] != DBNull.Value) ? Convert.ToInt64(row["ContractualEmployeesNumber"]) : 0;
mainOfficeType.Title = row["Title"].ToString();
mainOfficeType.TotalScore = (row["TotalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScore"]) : 0;
mainOfficeType.TotalScoreCat1 = (row["TotalScoreCat1"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat1"]) : 0;
mainOfficeType.TotalScoreCat2 = (row["TotalScoreCat2"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat2"]) : 0;
}
}
return(mainOfficeType);
}
public List <MainOfficeType> SearchLike(MainOfficeType mainOfficeType)
{
List <MainOfficeType> listMainOfficeType = new List <MainOfficeType>();
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID),
new SqlParameter("@ContractualEmployeesNumber", mainOfficeType.ContractualEmployeesNumber),
new SqlParameter("@Title", mainOfficeType.Title),
new SqlParameter("@TotalScore", mainOfficeType.TotalScore),
new SqlParameter("@TotalScoreCat1", mainOfficeType.TotalScoreCat1),
new SqlParameter("@TotalScoreCat2", mainOfficeType.TotalScoreCat2),
};
using (DataTable table = SqlDBHelper.ExecuteParamerizedSelectCommand("MainOfficeType_SearchLike", CommandType.StoredProcedure, parametersMainOfficeType))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
MainOfficeType tmpMainOfficeType = new MainOfficeType();
tmpMainOfficeType.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0;
tmpMainOfficeType.ContractualEmployeesNumber = (row["ContractualEmployeesNumber"] != DBNull.Value) ? Convert.ToInt64(row["ContractualEmployeesNumber"]) : 0;
tmpMainOfficeType.Title = row["Title"].ToString();
tmpMainOfficeType.TotalScore = (row["TotalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScore"]) : 0;
tmpMainOfficeType.TotalScoreCat1 = (row["TotalScoreCat1"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat1"]) : 0;
tmpMainOfficeType.TotalScoreCat2 = (row["TotalScoreCat2"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat2"]) : 0;
listMainOfficeType.Add(tmpMainOfficeType);
}
}
}
return(listMainOfficeType);
}
public List <MainOfficeType> GetListAll()
{
List <MainOfficeType> listMainOfficeType = null;
using (DataTable table = SqlDBHelper.ExecuteSelectCommand("MainOfficeType_GetListAll", CommandType.StoredProcedure))
{
if (table.Rows.Count > 0)
{
listMainOfficeType = new List <MainOfficeType>();
foreach (DataRow row in table.Rows)
{
MainOfficeType mainOfficeType = new MainOfficeType();
mainOfficeType.MainOfficeTypeID = (row["MainOfficeTypeID"] != DBNull.Value) ? Convert.ToInt32(row["MainOfficeTypeID"]) : 0;
mainOfficeType.ContractualEmployeesNumber = (row["ContractualEmployeesNumber"] != DBNull.Value) ? Convert.ToInt64(row["ContractualEmployeesNumber"]) : 0;
mainOfficeType.Title = row["Title"].ToString();
mainOfficeType.TotalScore = (row["TotalScore"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScore"]) : 0;
mainOfficeType.TotalScoreCat1 = (row["TotalScoreCat1"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat1"]) : 0;
mainOfficeType.TotalScoreCat2 = (row["TotalScoreCat2"] != DBNull.Value) ? Convert.ToDecimal(row["TotalScoreCat2"]) : 0;
listMainOfficeType.Add(mainOfficeType);
}
}
}
return(listMainOfficeType);
}
protected void Page_Load(object sender, EventArgs e)
{
string mainOfficeTypeID = Request.QueryString["mainOfficeTypeID"] as string;
if (mainOfficeTypeID == null)
{
Response.Redirect("Z_MainOfficeTypeDefault.aspx");
}
try
{
mainOfficeTypeMainOfficeTypeID = Convert.ToInt32(mainOfficeTypeID.Trim());
mainOfficeTypeHandler = new MainOfficeTypeHandler();
MainOfficeType mainOfficeType = mainOfficeTypeHandler.GetDetails(mainOfficeTypeMainOfficeTypeID);
lblMainOfficeTypeID.Text = mainOfficeType.MainOfficeTypeID.ToString();
lblContractualEmployeesNumber.Text = mainOfficeType.ContractualEmployeesNumber.ToString();
lblTitle.Text = mainOfficeType.Title.ToString();
lblTotalScore.Text = mainOfficeType.TotalScore.ToString();
lblTotalScoreCat1.Text = mainOfficeType.TotalScoreCat1.ToString();
lblTotalScoreCat2.Text = mainOfficeType.TotalScoreCat2.ToString();
}
catch (Exception)
{
Response.Redirect("Z_MainOfficeTypeDefault.aspx");
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblMainOfficeTypeID = GridView1.Rows[e.RowIndex].FindControl("lblMainOfficeTypeID") as Label;
Label lblContractualEmployeesNumber = GridView1.Rows[e.RowIndex].FindControl("lblContractualEmployeesNumber") as Label;
TextBox txtTitle = GridView1.Rows[e.RowIndex].FindControl("txtTitle") as TextBox;
TextBox txtTotalScore = GridView1.Rows[e.RowIndex].FindControl("txtTotalScore") as TextBox;
TextBox txtTotalScoreCat1 = GridView1.Rows[e.RowIndex].FindControl("txtTotalScoreCat1") as TextBox;
TextBox txtTotalScoreCat2 = GridView1.Rows[e.RowIndex].FindControl("txtTotalScoreCat2") as TextBox;
if (lblMainOfficeTypeID != null && lblContractualEmployeesNumber != null && txtTitle != null && txtTotalScore != null && txtTotalScoreCat1 != null && txtTotalScoreCat2 != null)
{
MainOfficeType mainOfficeType = new MainOfficeType();
mainOfficeType.MainOfficeTypeID = Convert.ToInt32(lblMainOfficeTypeID.Text.Trim());
mainOfficeType.ContractualEmployeesNumber = Convert.ToInt64(lblContractualEmployeesNumber.Text.Trim());
mainOfficeType.Title = txtTitle.Text;
//Let us now update the database
if (mainOfficeTypeHandler.Update(mainOfficeType) == true)
{
lblResult.Text = "Record Updated Successfully";
}
else
{
lblResult.Text = "Failed to Update record";
}
//end the editing and bind with updated records.
GridView1.EditIndex = -1;
BindData();
}
}
public bool Exists(MainOfficeType mainOfficeType)
{
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID)
};
return(SqlDBHelper.ExecuteScalar("MainOfficeType_Exists", CommandType.StoredProcedure, parametersMainOfficeType) > 0);
}
public bool Update(MainOfficeType mainOfficeType)
{
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@MainOfficeTypeID", mainOfficeType.MainOfficeTypeID),
new SqlParameter("@Title", mainOfficeType.Title),
new SqlParameter("@TotalScore", (mainOfficeType.TotalScore != null) ? mainOfficeType.TotalScore : (object)DBNull.Value),
new SqlParameter("@TotalScoreCat1", (mainOfficeType.TotalScoreCat1 != null) ? mainOfficeType.TotalScoreCat1 : (object)DBNull.Value),
new SqlParameter("@TotalScoreCat2", (mainOfficeType.TotalScoreCat2 != null) ? mainOfficeType.TotalScoreCat2 : (object)DBNull.Value)
};
return(SqlDBHelper.ExecuteNonQuery("MainOfficeType_Update", CommandType.StoredProcedure, parametersMainOfficeType));
}
public Int64 Insert(MainOfficeType mainOfficeType)
{
SqlParameter[] parametersMainOfficeType = new SqlParameter[]
{
new SqlParameter("@Title", mainOfficeType.Title),
new SqlParameter("@TotalScore", (mainOfficeType.TotalScore != null) ? mainOfficeType.TotalScore : (object)DBNull.Value),
new SqlParameter("@TotalScoreCat1", (mainOfficeType.TotalScoreCat1 != null) ? mainOfficeType.TotalScoreCat1 : (object)DBNull.Value),
new SqlParameter("@TotalScoreCat2", (mainOfficeType.TotalScoreCat2 != null) ? mainOfficeType.TotalScoreCat2 : (object)DBNull.Value)
};
mainOfficeType.MainOfficeTypeID = Convert.ToInt32(SqlDBHelper.ExecuteScalar("MainOfficeType_Insert", CommandType.StoredProcedure, parametersMainOfficeType));
return(mainOfficeType.MainOfficeTypeID);
}
protected void btnYES_Click(object sender, EventArgs e)
{
MainOfficeType mainOfficeType = new MainOfficeType();
mainOfficeType.Title = txtTitle.Text;
MainOfficeTypeHandler mainOfficeTypeHandler = new MainOfficeTypeHandler();
if (mainOfficeTypeHandler.Insert(mainOfficeType) > 0)
{
Response.Redirect("Z_MainOfficeTypeDefault.aspx");
}
}
