public Models.CircleUser get_circle() { CircleUser cu = new CircleUser(); List <Circle> lst_circle = new List <Circle>(); try { SqlConnection con = null; con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString()); con.Open(); SqlCommand cmd1 = new SqlCommand("select * from circle_master", con); cmd1.CommandType = CommandType.Text; SqlDataReader rdr1 = cmd1.ExecuteReader(); while (rdr1.Read()) { Circle rq = new Circle(); rq.Circle_name = Convert.ToString(rdr1["CIRCLE_NAME"].ToString()); rq.CircleID = Convert.ToInt32(rdr1["ID"].ToString()); lst_circle.Add(rq); } cu.CircleCollection = lst_circle; rdr1.Close(); con.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(cu); }
public ActionResult Index() { List <CircleUser> lstMstCircleuser = new List <CircleUser>(); try { DataTable dtMstCircleusr = objDbTrx.GetCircleUser(); if (dtMstCircleusr.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtMstCircleusr.Rows.Count; iCnt++) { CircleUser objMstCircleUsr = new CircleUser(); // objMstCircleUsr.circlename = Convert.ToInt16(dtMstCircleusr.Rows[iCnt]["ID"].ToString()); objMstCircleUsr.CircleUserID = Convert.ToInt16(dtMstCircleusr.Rows[iCnt]["CIRCLE_ID"].ToString()); objMstCircleUsr.circleName = dtMstCircleusr.Rows[iCnt]["CIRCLE_NAME"].ToString(); objMstCircleUsr.MobileNo = dtMstCircleusr.Rows[iCnt]["MOBILE_NO"].ToString(); objMstCircleUsr.CircleOfficerName = dtMstCircleusr.Rows[iCnt]["CIRCLE_OFFICER_NAME"].ToString(); objMstCircleUsr.EmailId = dtMstCircleusr.Rows[iCnt]["EMAIL_ID"].ToString(); objMstCircleUsr.Address = dtMstCircleusr.Rows[iCnt]["CIRCLE_ADDRESS"].ToString(); objMstCircleUsr.Userid = dtMstCircleusr.Rows[iCnt]["USER_ID"].ToString(); objMstCircleUsr.Password = dtMstCircleusr.Rows[iCnt]["PASSWORD"].ToString(); objMstCircleUsr.active = Convert.ToBoolean(dtMstCircleusr.Rows[iCnt]["ACTIVE"].ToString()); objMstCircleUsr.flag = Convert.ToBoolean(dtMstCircleusr.Rows[iCnt]["flag"].ToString()); objMstCircleUsr.CirclePinCode = dtMstCircleusr.Rows[iCnt]["Circle_PinCode"].ToString(); lstMstCircleuser.Add(objMstCircleUsr); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(View(lstMstCircleuser)); }
public ActionResult Index() { List <CircleUser> lst_rq = new List <CircleUser>(); SqlConnection con = null; try { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString()); SqlCommand cmd = new SqlCommand("select * from circle_user_master ", con); cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CircleUser rq = new CircleUser(); rq.CircleID = Convert.ToInt32(Convert.ToString(rdr["CIRCLE_ID"])); rq.CircleOfficerName = Convert.ToString(rdr["CIRCLE_OFFICER_NAME"]); rq.MobileNo = Convert.ToString(rdr["MOBILE_NO"]); rq.EmailId = Convert.ToString(rdr["EMAIL_ID"]); rq.Address = Convert.ToString(rdr["CIRCLE_ADDRESS"]); rq.Userid = Convert.ToString(rdr["USER_ID"]); rq.Password = Convert.ToString(rdr["PASSWORD"]); lst_rq.Add(rq); } rdr.Close(); con.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(View(lst_rq)); }
public ActionResult Index(CircleUser objcust) { if (ModelState.IsValid) { string CircleId = ""; try { CircleId = GlobalSettings.oUserData.CircleID; } catch { CircleId = ""; } if (CircleId != "") { try { objcust.Userid = Convert.ToString(GlobalSettings.oUserData.UserId); objDbTrx.UpdateInCericleUser(objcust); TempData["Message"] = "Profile Successfully Updated"; } catch (Exception ex) { TempData["Message"] = "Some Error occured while updating Profile."; objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } finally { } } else { return(RedirectToAction("Index", "CircleLogin")); } } return(View()); }
public async Task AddUserToCircle(int user_id, int circle_id) { //Backend Logic: Register every LO in Circle with the new user // Doesn't insert if duplicated CircleUser cuser = new CircleUser { User_id = user_id, Circle_id = circle_id, created_at = DateTime.UtcNow, updated_at = DateTime.UtcNow }; await _repositoryService.InsertAsync <CircleUser>(cuser); }
public ActionResult AddCircleUsers(CircleUser objCircleusers) { try { bool isUpdated = objDbTrx.InsertInMstCircleUser1(objCircleusers); } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(RedirectToAction("Index", "MstCircleUser")); }
protected override async void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); if (NavigationContext.QueryString.TryGetValue("userID", out userID)) { List <Circle> circles = await Global.googLib.GetCircles(); //circlesList.ItemsSource = circles; List <CircleUser> circles2 = new List <CircleUser>(); foreach (var c in circles) { CircleUser circle = new CircleUser(); circle.containUser = c.users.Any(u => u.id == userID); circle.name = c.name; circle.circleID = c.id; if (circle.circleID != "15") { circles2.Add(circle); } } circlesList.ItemsSource = circles2; } }
public ActionResult Index(CircleUser objcust) { if (ModelState.IsValid) { SqlConnection con = null; string result = ""; try { con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString()); SqlCommand cmd = new SqlCommand("insert into circle_user_master (CIRCLE_ID,CIRCLE_OFFICER_NAME,MOBILE_NO,EMAIL_ID,CIRCLE_ADDRESS,USER_ID,PASSWORD) values (@CIRCLE_ID,@CIRCLE_OFFICER_NAME,@MOBILE_NO,@EMAIL_ID,@CIRCLE_ADDRESS,@USER_ID,@PASSWORD)", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@CIRCLE_ID", objcust.CircleID); cmd.Parameters.AddWithValue("@CIRCLE_OFFICER_NAME", objcust.CircleOfficerName); cmd.Parameters.AddWithValue("@MOBILE_NO", objcust.MobileNo); cmd.Parameters.AddWithValue("@EMAIL_ID", objcust.EmailId); cmd.Parameters.AddWithValue("@CIRCLE_ADDRESS", objcust.Address); cmd.Parameters.AddWithValue("@USER_ID", objcust.Userid); cmd.Parameters.AddWithValue("@PASSWORD", objcust.Password); con.Open(); result = cmd.ExecuteReader().ToString(); Response.Write("<script> alert ('Data has been submitted successfully...') </script> "); } catch (Exception ex) { throw new Exception(ex.Message); } finally { con.Close(); } } return(RedirectToAction("Index", "CircleUserView")); }