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