protected void btnSaveModel_ServerClick(object sender, EventArgs e)
{
ModelObject obj = new ModelObject();
obj.Model_Name = txtModelName.Value;
obj.Vehicle_Type = lstVehicleType.Value;
obj.Manufacturer_Name = lstManufacturerName.Value;
obj.Disable = chkBoxModelDisable.Checked;
ManageModel modelObj = new ManageModel();
bool success = modelObj.insert(obj, ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
}
protected void btnSaveModel_ServerClick(object sender, EventArgs e)
{
ModelObject obj = new ModelObject();
obj.Manufacturer_Name = lstManufacturerName.Value;
obj.Model_Name = txtModelName.Value;
obj.Vehicle_Type = lstVehicleType.Value;
obj.Disable = chkBoxModelDisable.Checked;
ManageModel ModelObj = new ManageModel();
bool success = ModelObj.updateAModel(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"]));
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
Session.Remove("rowIndex");
}
public Boolean updateAModel(string connectionString, ModelObject modelObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateModel", insertParameters(modelObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@Model_ID", rowIndex));
int rowsUpdated = cmdIns.ExecuteNonQuery();
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
public List<SqlParameter> insertParameters(ModelObject modelObj)
{
List<SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@Model_Name", modelObj.Model_Name));
insertParamsArray.Add(new SqlParameter("@Vehicle_Type", modelObj.Vehicle_Type));
insertParamsArray.Add(new SqlParameter("@Manufacturer_Name", modelObj.Manufacturer_Name));
insertParamsArray.Add(new SqlParameter("@Disable", modelObj.Disable));
return insertParamsArray;
}
public bool insert(ModelObject modelObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertModel", insertParameters(modelObj), conn);
int rowsUpdated = cmdIns.ExecuteNonQuery();
// cmdIns.Parameters.Clear();
// cmdIns.CommandText = "SELECT @@IDENTITY";
// // Get the last inserted id.
// int insertID = Convert.ToInt32(cmdIns.ExecuteScalar());
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
