// management plan
public void Insert(ManagementPlan planObj)
{
string sqlStr = string.Format("Insert Into ManagementPlan (MP_Name, MP_Company, MP_Address) Values" +
"('{0}', '{1}', '{2}')",
planObj.Name, planObj.Company, planObj.Address);
using (SqlCommand cmd = new SqlCommand(sqlStr, SqlCn))
{
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Exception error = new Exception("Couldn't insert the Management Plan! " + ex.Message, ex);
throw error;
}
}
}
public void Update(ManagementPlan planObj, int id)
{
string sqlStr =
string.Format(
"Update ManagementPlan Set MP_Name = '{0}', MP_Company = '{1}', MP_Address = '{2}' Where MP_ID = '{3}'",
planObj.Name, planObj.Company, planObj.Address, id);
using (SqlCommand cmd = new SqlCommand(sqlStr, this.SqlCn))
{
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Exception error = new Exception("Couldn't update the Management Plan! " + ex.Message, ex);
throw error;
}
}
}
public void Update(ManagementPlan planObj, int id)
{
string sqlStr =
string.Format(
"Update ManagementPlan Set MP_Name = '{0}', MP_Company = '{1}', MP_Address = '{2}' Where MP_ID = '{3}'",
planObj.Name, planObj.Company, planObj.Address, id);
using (SqlCommand cmd = new SqlCommand(sqlStr, this.SqlCn))
{
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Exception error = new Exception("Couldn't update the Management Plan! " + ex.Message, ex);
throw error;
}
}
}
// management plan
public void Insert(ManagementPlan planObj)
{
string sqlStr = string.Format("Insert Into ManagementPlan (MP_Name, MP_Company, MP_Address) Values" +
"('{0}', '{1}', '{2}')",
planObj.Name, planObj.Company, planObj.Address);
using (SqlCommand cmd = new SqlCommand(sqlStr, SqlCn))
{
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Exception error = new Exception("Couldn't insert the Management Plan! " + ex.Message, ex);
throw error;
}
}
}
