public Boolean Update(equipment id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@equipment_id", id.equipment_id);
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
cmd.ExecuteReader();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
con.Close();
}
}
public equipment Insert(equipment id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.equipment_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return(id);
}
public equipment Insert_equipment_select(int ID)
{
equipment = equipment.Select(ID);
Insert_resource_ID_txt.Text = Convert.ToString(equipment.resource_ID);
Insert_vendor_id_txt.Text = Convert.ToString(equipment.vendor_id);
Insert_Description_txt.Text = Convert.ToString(equipment.Description);
Insert_costType_txt.Text = Convert.ToString(equipment.costType);
Insert_costRate_txt.Text = Convert.ToString(equipment.costRate);
Insert_capacity_txt.Text = Convert.ToString(equipment.capacity);
Insert_make_txt.Text = Convert.ToString(equipment.make);
Insert_model_txt.Text = Convert.ToString(equipment.model);
Insert_operatorName_txt.Text = Convert.ToString(equipment.operatorName);
Insert_startDate_txt.Text = Convert.ToString(equipment.startDate);
Insert_endDate_txt.Text = Convert.ToString(equipment.endDate);
return(equipment);
}
public equipment Delete_equipment_select(int ID)
{
equipment = equipment.Select(ID);
Delete_equipment_id_txt_lbl.Text = Convert.ToString(equipment.equipment_id);
Delete_resource_ID_txt_lbl.Text = Convert.ToString(equipment.resource_ID);
Delete_vendor_id_txt_lbl.Text = Convert.ToString(equipment.vendor_id);
Delete_Description_txt_lbl.Text = Convert.ToString(equipment.Description);
Delete_costType_txt_lbl.Text = Convert.ToString(equipment.costType);
Delete_costRate_txt_lbl.Text = Convert.ToString(equipment.costRate);
Delete_capacity_txt_lbl.Text = Convert.ToString(equipment.capacity);
Delete_make_txt_lbl.Text = Convert.ToString(equipment.make);
Delete_model_txt_lbl.Text = Convert.ToString(equipment.model);
Delete_operatorName_txt_lbl.Text = Convert.ToString(equipment.operatorName);
Delete_startDate_txt_lbl.Text = Convert.ToString(equipment.startDate);
Delete_endDate_txt_lbl.Text = Convert.ToString(equipment.endDate);
return equipment;
}
public equipment equipment_insert()
{
equipment.resource_ID = Convert.ToInt32(Insert_resource_ID_txt.Text);
equipment.vendor_id = Convert.ToInt32(Insert_vendor_id_txt.Text);
equipment.Description = Insert_Description_txt.Text;
equipment.costType = Insert_costType_txt.Text;
equipment.costRate = Convert.ToDecimal(Insert_costRate_txt.Text);
equipment.capacity = Convert.ToInt32(Insert_capacity_txt.Text);
equipment.make = Insert_make_txt.Text;
equipment.model = Insert_model_txt.Text;
equipment.operatorName = Insert_operatorName_txt.Text;
equipment.startDate = Convert.ToDateTime(Insert_startDate_txt.Text);
equipment.endDate = Convert.ToDateTime(Insert_endDate_txt.Text);
equipment = equipment.Insert(equipment);
Insert_equipment_GridView.DataBind();
Update_equipment_GridView.DataBind();
Delete_equipment_GridView.DataBind();
return(equipment);
}
public equipment equipment_update(int ID)
{
equipment = equipment.Select(ID);
equipment.equipment_id = Convert.ToInt32(Update_equipment_id_txt.Text);
equipment.resource_ID = Convert.ToInt32(Update_resource_ID_txt.Text);
equipment.vendor_id = Convert.ToInt32(Update_vendor_id_txt.Text);
equipment.Description = Update_Description_txt.Text;
equipment.costType = Update_costType_txt.Text;
equipment.costRate = Convert.ToDecimal(Update_costRate_txt.Text);
equipment.capacity = Convert.ToInt32(Update_capacity_txt.Text);
equipment.make = Update_make_txt.Text;
equipment.model = Update_model_txt.Text;
equipment.operatorName = Update_operatorName_txt.Text;
equipment.startDate = Convert.ToDateTime(Update_startDate_txt.Text);
equipment.endDate = Convert.ToDateTime(Update_endDate_txt.Text);
equipment.Update(equipment);
Insert_equipment_GridView.DataBind();
Update_equipment_GridView.DataBind();
Delete_equipment_GridView.DataBind();
return(equipment);
}
/////////////////////////
////////////////////////
///////////////////////
//////////////////////
/////////////////////
//Update Tab Methods
protected void Update_Select_Record(object sender, EventArgs e)
{
equipment = Update_equipment_select(Convert.ToInt32(Update_equipment_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
equipment = equipment_update(Convert.ToInt32(Update_equipment_GridView.SelectedValue));
}
/////////////////////////
////////////////////////
///////////////////////
//////////////////////
/////////////////////
//Insert Tab Methods
protected void Insert_Select_Record(object sender, EventArgs e)
{
equipment = Insert_equipment_select(Convert.ToInt32(Insert_equipment_GridView.SelectedValue));
}
protected void INSERT(object sender, EventArgs e)
{
equipment = equipment_insert();
}
public Boolean Update(equipment id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_UPDATE_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@equipment_id", id.equipment_id);
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
cmd.ExecuteReader();
con.Close();
return true;
}
catch (Exception ex)
{
return false;
}
finally
{
con.Close();
}
}
public equipment Select(int id)
{
equipment equipment = new equipment();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@equipment_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
equipment.equipment_id = rdr.GetInt32(0);
}
else
{
equipment.equipment_id = 0;
}
if (!rdr.IsDBNull(1))
{
equipment.resource_ID = rdr.GetInt32(1);
}
else
{
equipment.resource_ID = 0;
}
if (!rdr.IsDBNull(2))
{
equipment.vendor_id = rdr.GetInt32(2);
}
else
{
equipment.vendor_id = 0;
}
if (!rdr.IsDBNull(3))
{
equipment.Description = rdr.GetString(3);
}
else
{
equipment.Description = " ";
}
if (!rdr.IsDBNull(4))
{
equipment.costType = rdr.GetString(4);
}
else
{
equipment.costType = " ";
}
if (!rdr.IsDBNull(5))
{
equipment.costRate = rdr.GetDecimal(5);
}
else
{
equipment.costRate = 0;
}
if (!rdr.IsDBNull(6))
{
equipment.capacity = rdr.GetInt32(6);
}
else
{
equipment.capacity = 0;
}
if (!rdr.IsDBNull(7))
{
equipment.make = rdr.GetString(7);
}
else
{
equipment.make = " ";
}
if (!rdr.IsDBNull(8))
{
equipment.model = rdr.GetString(8);
}
else
{
equipment.model = " ";
}
if (!rdr.IsDBNull(9))
{
equipment.operatorName = rdr.GetString(9);
}
else
{
equipment.operatorName = " ";
}
if (!rdr.IsDBNull(10))
{
equipment.startDate = rdr.GetDateTime(10);
}
else
{
equipment.startDate = DateTime.Now;
}
if (!rdr.IsDBNull(11))
{
equipment.endDate = rdr.GetDateTime(11);
}
else
{
equipment.endDate = DateTime.Now;
}
}
else
{
equipment.SetColumnDefaults();
}
}
catch (Exception ex)
{
equipment.SetColumnDefaults();
return equipment;
}
finally
{
con.Close();
}
return equipment;
}
public equipment Select(int id)
{
equipment equipment = new equipment();
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_SELECT_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@equipment_id", id);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
if (!rdr.IsDBNull(0))
{
equipment.equipment_id = rdr.GetInt32(0);
}
else
{
equipment.equipment_id = 0;
}
if (!rdr.IsDBNull(1))
{
equipment.resource_ID = rdr.GetInt32(1);
}
else
{
equipment.resource_ID = 0;
}
if (!rdr.IsDBNull(2))
{
equipment.vendor_id = rdr.GetInt32(2);
}
else
{
equipment.vendor_id = 0;
}
if (!rdr.IsDBNull(3))
{
equipment.Description = rdr.GetString(3);
}
else
{
equipment.Description = " ";
}
if (!rdr.IsDBNull(4))
{
equipment.costType = rdr.GetString(4);
}
else
{
equipment.costType = " ";
}
if (!rdr.IsDBNull(5))
{
equipment.costRate = rdr.GetDecimal(5);
}
else
{
equipment.costRate = 0;
}
if (!rdr.IsDBNull(6))
{
equipment.capacity = rdr.GetInt32(6);
}
else
{
equipment.capacity = 0;
}
if (!rdr.IsDBNull(7))
{
equipment.make = rdr.GetString(7);
}
else
{
equipment.make = " ";
}
if (!rdr.IsDBNull(8))
{
equipment.model = rdr.GetString(8);
}
else
{
equipment.model = " ";
}
if (!rdr.IsDBNull(9))
{
equipment.operatorName = rdr.GetString(9);
}
else
{
equipment.operatorName = " ";
}
if (!rdr.IsDBNull(10))
{
equipment.startDate = rdr.GetDateTime(10);
}
else
{
equipment.startDate = DateTime.Now;
}
if (!rdr.IsDBNull(11))
{
equipment.endDate = rdr.GetDateTime(11);
}
else
{
equipment.endDate = DateTime.Now;
}
}
else
{
equipment.SetColumnDefaults();
}
}
catch (Exception ex)
{
equipment.SetColumnDefaults();
return(equipment);
}
finally
{
con.Close();
}
return(equipment);
}
public equipment equipment_insert()
{
equipment.resource_ID = Convert.ToInt32(Insert_resource_ID_txt.Text);
equipment.vendor_id = Convert.ToInt32(Insert_vendor_id_txt.Text);
equipment.Description = Insert_Description_txt.Text;
equipment.costType = Insert_costType_txt.Text;
equipment.costRate = Convert.ToDecimal(Insert_costRate_txt.Text);
equipment.capacity = Convert.ToInt32(Insert_capacity_txt.Text);
equipment.make = Insert_make_txt.Text;
equipment.model = Insert_model_txt.Text;
equipment.operatorName = Insert_operatorName_txt.Text;
equipment.startDate = Convert.ToDateTime(Insert_startDate_txt.Text);
equipment.endDate = Convert.ToDateTime(Insert_endDate_txt.Text);
equipment = equipment.Insert(equipment);
Insert_equipment_GridView.DataBind();
Update_equipment_GridView.DataBind();
Delete_equipment_GridView.DataBind();
return equipment;
}
protected void INSERT(object sender, EventArgs e)
{
equipment = equipment_insert();
}
/////////////////////////
////////////////////////
///////////////////////
//////////////////////
/////////////////////
//Update Tab Methods
protected void Update_Select_Record(object sender, EventArgs e)
{
equipment = Update_equipment_select(Convert.ToInt32(Update_equipment_GridView.SelectedValue));
}
/////////////////////////
////////////////////////
///////////////////////
//////////////////////
/////////////////////
//Insert Tab Methods
protected void Insert_Select_Record(object sender, EventArgs e)
{
equipment = Insert_equipment_select(Convert.ToInt32(Insert_equipment_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
equipment = equipment_update(Convert.ToInt32(Update_equipment_GridView.SelectedValue));
}
public equipment equipment_update(int ID)
{
equipment = equipment.Select(ID);
equipment.equipment_id = Convert.ToInt32(Update_equipment_id_txt.Text);
equipment.resource_ID = Convert.ToInt32(Update_resource_ID_txt.Text);
equipment.vendor_id = Convert.ToInt32(Update_vendor_id_txt.Text);
equipment.Description = Update_Description_txt.Text;
equipment.costType = Update_costType_txt.Text;
equipment.costRate = Convert.ToDecimal(Update_costRate_txt.Text);
equipment.capacity = Convert.ToInt32(Update_capacity_txt.Text);
equipment.make = Update_make_txt.Text;
equipment.model = Update_model_txt.Text;
equipment.operatorName = Update_operatorName_txt.Text;
equipment.startDate = Convert.ToDateTime(Update_startDate_txt.Text);
equipment.endDate = Convert.ToDateTime(Update_endDate_txt.Text);
equipment.Update(equipment);
Insert_equipment_GridView.DataBind();
Update_equipment_GridView.DataBind();
Delete_equipment_GridView.DataBind();
return equipment;
}
public equipment Insert(equipment id)
{
string ConnectionString = IDManager.connection();
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SP_DMCS_INSERT_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
cmd.ExecuteReader();
con.Close();
con.Open();
cmd = new SqlCommand("SP_DMCS_GET_EQUIPMENT", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@resource_ID", id.resource_ID);
cmd.Parameters.AddWithValue("@vendor_id", id.vendor_id);
cmd.Parameters.AddWithValue("@Description", id.Description);
cmd.Parameters.AddWithValue("@costType", id.costType);
cmd.Parameters.AddWithValue("@costRate", id.costRate);
cmd.Parameters.AddWithValue("@capacity", id.capacity);
cmd.Parameters.AddWithValue("@make", id.make);
cmd.Parameters.AddWithValue("@model", id.model);
cmd.Parameters.AddWithValue("@operatorName", id.operatorName);
cmd.Parameters.AddWithValue("@startDate", id.startDate);
cmd.Parameters.AddWithValue("@endDate", id.endDate);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
id.equipment_id = rdr.GetInt32(0);
}
}
catch (Exception ex)
{
id.SetColumnDefaults();
}
finally
{
con.Close();
}
return id;
}
