public static string User_reg_Qry(User_reg_Model reg)
{
StringBuilder sb = new StringBuilder();
sb.Append("Insert into User_Moible_No values('" + reg.CA_NO + "','" + reg.Mob1 + "," + reg.Mob2 + "," + reg.Mob3 + "," + reg.Mob4 + "," + reg.Mob5 + "') ");
return sb.ToString();
}
public int User_Mobile_reg(User_reg_Model reg_module)
{
try
{
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbcmd = db.GetSqlStringCommand(Query.User_reg_Qry(reg_module)))
{
int i = Convert.ToInt16(db.ExecuteNonQuery(dbcmd));
return i;
}
}
catch (OleDbException e)
{
throw e;
}
}
public ActionResult Register(User_reg_Model reg_module)
{
if (ModelState.IsValid)
{
try
{
reg_module.User_reg(reg_module);
ModelState.AddModelError("", "Successful Registration");
reg_module.CA_NO = "";
reg_module.Mob1 = 0;
reg_module.Mob2 = 0;
reg_module.Mob3 = 0;
reg_module.Mob4 = 0;
reg_module.Mob5 = 0;
return View();
}
catch (Exception e)
{
ModelState.AddModelError("", "Already registered.please update your contact details ");
}
}
return View();
}
public void User_reg(User_reg_Model reg_module)
{
try
{
User_registration reg = new User_registration();
reg.User_Mobile_reg(reg_module);
}
catch (OleDbException e) { throw e; }
}