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)); }