public int RegisterPinCode(PincodeRegistration pinCode)
{
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
var pincodeId = -1;
using (SqlConnection con = new SqlConnection(connectionString))
{
var sql = "insert into pinmast (station, loc, inc, pwd, pinc, area, stype) values(@station, @loc, @incharge, @pwd, @pincode, @area, @stationType) select SCOPE_IDENTITY()";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@station", pinCode.StationName);
cmd.Parameters.AddWithValue("@loc", pinCode.Location);
cmd.Parameters.AddWithValue("@incharge", pinCode.Incharge);
cmd.Parameters.AddWithValue("@pwd", pinCode.Password);
cmd.Parameters.AddWithValue("@pincode", pinCode.Pincode);
cmd.Parameters.AddWithValue("@area", pinCode.Area);
cmd.Parameters.AddWithValue("@stationType", pinCode.StationType);
con.Open();
pincodeId = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
}
return(pincodeId);
}
public ActionResult RegisterPincode(PincodeViewModel pincodeModel)
{
var admin = new ASTIAdmin();
var pinCode = new PincodeRegistration();
pinCode.Area = pincodeModel.Area;
pinCode.Incharge = pincodeModel.Incharge;
pinCode.Location = pincodeModel.Location;
pinCode.Password = pincodeModel.Password;
pinCode.Pincode = pincodeModel.Pincode;
pinCode.StationName = pincodeModel.StationName;
pinCode.StationType = pincodeModel.StationType;
var pinCodeId = admin.RegisterPinCode(pinCode);
ViewBag.IsPincodeRegistered = true;
return(View());
}
public int RegisterPinCode(PincodeRegistration pinCode)
{
var admin = new ASTIAdminDAL();
return(admin.RegisterPinCode(pinCode));
}