protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
public void InsertBranch(Entities.Campus c1, Entities.ZipCodes z1)
{
using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertBranch]"))
{
s1.AddParameter("@campusName", System.Data.SqlDbType.NVarChar, c1.campusName);
s1.AddParameter("@address", System.Data.SqlDbType.NVarChar, c1.address);
s1.AddParameter("@zipCode", System.Data.SqlDbType.Int, c1.zipCode);
s1.AddParameter("@phone1", System.Data.SqlDbType.NVarChar, c1.phone1);
s1.AddParameter("@phone2", System.Data.SqlDbType.NVarChar, c1.phone2);
s1.AddParameter("@phone3", System.Data.SqlDbType.NVarChar, c1.phone3);
s1.AddParameter("@principal", System.Data.SqlDbType.NVarChar, c1.principal);
s1.AddParameter("@cityName", System.Data.SqlDbType.NVarChar, z1.cityName);
s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, c1.email);
s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, c1.isActive);
s1.Execute();
}
}
