public static string User_login_data(User_Login_form reg) { StringBuilder sb = new StringBuilder(); sb.Append("select * from USER_MOIBLE_NO where substr(MOBILE_NO,1,10)='" + reg.Mobile + "'or substr(MOBILE_NO,12,10)='" + reg.Mobile + "' or substr(MOBILE_NO,23,10)='" + reg.Mobile + "' or substr(MOBILE_NO,34,10)='" + reg.Mobile + "' or substr(MOBILE_NO,45,10)='" + reg.Mobile + "' "); return sb.ToString(); }
public ActionResult User_login(User_Login_form user_login) { try { if (ModelState.IsValid) { DataTable dt = user_login.User_Login_data(user_login); if (dt.Rows.Count == 0) { ModelState.AddModelError("", "you Mobile number is not registerd.plz register first to avail this service"); } else { user_complain_reg reg = new user_complain_reg(); DataTable dt1 = reg.User_detail(user_login); reg.CA_NO = dt.Rows[0]["CA_NO"].ToString(); ISUService service = new ISUService(); DataSet ds = new DataSet(); ds = service.Z_BAPI_CMS_ISU_CA_DISPLAY("000" + reg.CA_NO, "", "", "", "", ""); if (ds.Tables[0].Rows.Count == 0) { ModelState.AddModelError("", "Please Check your CA number."); } else { reg.Address = ds.Tables[0].Rows[0]["House_Number"].ToString() + " " + ds.Tables[0].Rows[0]["Street"].ToString() + " " + ds.Tables[0].Rows[0]["Street2"].ToString() + " " + ds.Tables[0].Rows[0]["Street3"].ToString() + " " + ds.Tables[0].Rows[0]["Street4"].ToString() + ", " + ds.Tables[0].Rows[0]["City"].ToString() + ", PostCode: " + ds.Tables[0].Rows[0]["Post_Code"].ToString() + " ."; reg.Consumer_name = ds.Tables[0].Rows[0]["Bp_Name"].ToString(); reg.Mob = user_login.Mobile; return RedirectToAction("user_complain_reg", reg); } } } } catch { ModelState.AddModelError("", "There is some problem in updation,plz try later"); } return View(); }
public DataTable User_login_data(User_Login_form user_login_detail) { try { Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbcmd = db.GetSqlStringCommand(Query.User_login_data(user_login_detail))) { DataTable dt = db.ExecuteDataSet(dbcmd).Tables[0]; return dt; } } catch (OleDbException e) { throw e; } }
public DataTable get_User_detail(User_Login_form reg_module) { try { Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbcmd = db.GetSqlStringCommand(Query.User_detail_Qry(reg_module))) { DataTable dt = db.ExecuteDataSet(dbcmd).Tables[0]; return dt; } } catch (OleDbException e) { throw e; } }
public DataTable User_Login_data(User_Login_form user_Login_detail) { try { User_registration reg = new User_registration(); DataTable dt = reg.User_login_data(user_Login_detail); return dt; } catch (OleDbException e) { throw e; } }
public DataTable User_detail(User_Login_form user_login) { try { User_detail reg = new User_detail(); DataTable dt = reg.get_User_detail(user_login); return dt; } catch (OleDbException e) { throw e; } }