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 CreateInstallment()
{
var ds = DButil.GetTable("SELECT * FROM [User] WHERE UserID = '{0}'", userid);
Installment_Form ins = new Installment_Form();
ins.FullName = ds.Rows[0]["FullName"].ToString();
ins.DOB = ds.Rows[0]["DOB"].ToString();
ins.ContactNo = ds.Rows[0]["ContactNo"].ToString();
ins.Email = ds.Rows[0]["Email"].ToString();
ins.age = ds.Rows[0]["age"].ToString();
return(View(ins));
}