protected void SaveDealership_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["FuneralConnection"].ToString(); // connection string
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand checkDealership = new SqlCommand("SELECT COUNT(*) FROM [dbo].[Dealerships] WHERE ([DealershipName] = @DealershipName)", con);
checkDealership.Parameters.AddWithValue("@DealershipName", txtDealershipName.Text);
int DealershipExist = (int)checkDealership.ExecuteScalar();
if (DealershipExist > 0)
{
//Dealership exist
ShowMessage(ref lblMessage, MessageType.Warning, "Dealership Already Exists");
lblMessage.Visible = true;
ClearFields();
}
else
{
//Dealership doesn't exist.
model = new DealershipModel();
model.DealershipName = txtDealershipName.Text;
model.LandLine = txtLandLine.Text;
//model.Email = txtEmail.Text;
DealershipBAL.SaveDealership(model);
ShowMessage(ref lblMessage, MessageType.Success, "Dealership Saved Successfully");
lblMessage.Visible = true;
ClearFields();
}
}
public static int SaveDealership(DealershipModel model)
{
string query = "SaveDealership";
DbParameter[] ObjParam = new DbParameter[3];
ObjParam[0] = new DbParameter("@DealershipId", DbParameter.DbType.Int, 0, model.DealershipId);
ObjParam[1] = new DbParameter("@DealershipName", DbParameter.DbType.NVarChar, 50, model.DealershipName);
ObjParam[2] = new DbParameter("@LandLine", DbParameter.DbType.NVarChar, 50, model.LandLine);
// ObjParam[3] = new DbParameter("@Email", DbParameter.DbType.NVarChar, 0, model.Email);
return(Convert.ToInt32(DbConnection.GetScalarValue(CommandType.StoredProcedure, query, ObjParam)));
}
public static int SaveDealership(DealershipModel model)
{
return(DealershipDAL.SaveDealership(model));
}
