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 static string User_Web_comp_reg(user_complain_reg user_complain, string[] detail) { StringBuilder sd = new StringBuilder(); sd.Append(" insert into OMS_NC_IN(CA_NO,CALLER_NAME,CONSUMER_NAME,CONSUMER_NO,ADDRESS,TYPE_OF_FAULT,COMP_REASON,COMP_OPEN_BY,POLE_ID,EQUIPMENT_ID,COMPANY,CIRCLE,DIVISION,SUB_DIVISION,SUB_STATION,COMP_CENTER)values('" + user_complain.CA_NO + "','" + user_complain.Consumer_name + "','" + user_complain.Consumer_name + "' "); sd.Append(" ,'" + user_complain.Mob + "','" + user_complain.Address + "'," + user_complain.typeoffault + ",'" + user_complain.Remark + "','Web_comp','" + detail[0] + "','" + detail[1] + "','" + detail[2] + "','" + detail[3] + "','" + detail[4] + "','" + detail[5] + "','" + detail[6] + "'," + detail[7] + " ) "); return sd.ToString(); }
public void User_comp_clear(user_complain_reg reg) { reg.Mob = 0; reg.Remark = ""; reg.Address = ""; reg.CA_NO = ""; reg.Consumer_name = ""; }
public ActionResult User_complain_reg(user_complain_reg reg) { try { if (ModelState.IsValid) { string CA_NO = reg.CA_NO.ToString(); DataTable dt = reg.User_prev_comp_status(CA_NO); if (dt.Rows.Count != 0) { ModelState.AddModelError("", "Your Complain is already registered.Your Complain number is '" + dt.Rows[0]["COMP_NO"].ToString() + "' "); } else { get_LT_network_detail LT_Network = new get_LT_network_detail(); string[] detail = new string[10]; DataTable dt1 = LT_Network.get_network_detail(CA_NO); String Sub_station_code = dt1.Rows[0]["Substion_id"].ToString(); Service1 gis_service = new Service1(); DataSet ds = new DataSet(); ds = gis_service._Substation_Div_details(Sub_station_code); detail[0] = dt1.Rows[0]["POLE_NO"].ToString(); detail[1] = dt1.Rows[0]["DT_CODE"].ToString(); detail[2] = ds.Tables[0].Rows[0]["Company"].ToString(); detail[3] = ds.Tables[0].Rows[0]["Circle"].ToString(); detail[4] = ds.Tables[0].Rows[0]["DIVISION_1"].ToString(); detail[5] = ds.Tables[0].Rows[0]["SUBDIVISIO"].ToString(); detail[6] = Sub_station_code; complaints_center comp_cent = new complaints_center(); DataTable Center = comp_cent.get_complaints_center(detail[5]); detail[7] = Center.Rows[0]["COMP_CEN_ID"].ToString(); reg.User_Web_comp_reg(reg, detail); DataTable dt2 = reg.Get_complaint_NO(CA_NO); ModelState.AddModelError("", "Your Complain is registered.Your Complain number is '" + dt2.Rows[0]["COMP_NO"].ToString() + "' "); } } } catch { ModelState.AddModelError("", "There is some problem in complain registration,plz try later"); } fault_type(); User_comp_clear(reg); return View(); }
public ActionResult user_complain_reg(user_complain_reg reg) { fault_type(); return View(reg); }
public void User_Web_comp_reg(user_complain_reg user_complain, string[] detail) { try { Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbcmd = db.GetSqlStringCommand(Query.User_Web_comp_reg(user_complain,detail))) { db.ExecuteDataSet(dbcmd); } } catch (OleDbException e) { throw e; } }
public void User_Web_comp_reg(user_complain_reg user_complain, string[] detail) { try { User_Complain_reg reg = new User_Complain_reg(); reg.User_Web_comp_reg(user_complain, detail); } catch (OleDbException e) { throw e; } }