public ActionResult CreaeIns(Installment_Form ins, FormCollection form)
{
if (!ModelState.IsValid)
{
ViewData["Message"] = "Invalid Input";
ViewData["MsgType"] = "warning";
return(View("CreateInstallment"));
}
else
{
string insert =
@"INSERT INTO [Installment](FullName, Email,DOB,Age,ContactNo,Salary,Dependencies,PermonthInstallment,InerestRae,NoOfYear) VALUES
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}',{7},{8},{9})";
if (DButil.ExecSQL(insert, ins.FullName, ins.Email, ins.DOB, ins.age, ins.ContactNo, ins.Salary, ins.Dependencies, ins.PermonthInstallment, ins.InerestRae, ins.NoOfYear) == 1)
{
ViewData["Message"] = "Installment Successfully Registered";
ViewData["MsgType"] = "success";
}
else
{
ViewData["Message"] = DButil.DB_Message;
ViewData["MsgType"] = "danger";
}
return(View("CreateInstallment"));
}
}
public ActionResult Create(User usr, FormCollection form)
{
if (!ModelState.IsValid)
{
ViewData["Message"] = "Invalid Input";
ViewData["MsgType"] = "warning";
return(View("UserRegister"));
}
else
{
string insert =
@"INSERT INTO [User](UserID, UserPw, FullName, Email,DOB,Age,ContactNo) VALUES
('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')";
if (DButil.ExecSQL(insert, usr.UserID, usr.UserPw, usr.FullName, usr.Email, usr.DOB, usr.age, usr.ContactNo) == 1)
{
ViewData["Message"] = "User Successfully Registered";
ViewData["MsgType"] = "success";
}
else
{
ViewData["Message"] = DButil.DB_Message;
ViewData["MsgType"] = "danger";
}
return(View("Register"));
}
}