//public Tuple <List<tblLabel>,List<tblLabelNotes>>labelshow(tblLabelNotes objtbl,string userid) //{ // Tuple<List<tblLabel>,List<tblLabelNotes>> result = null; // result = noteService.labelshow(objtbl, userid); // return result; //} public async Task <string> labelshow(tblLabelNotes objtbl) { Tuple <List <tblLabel>, List <tblLabelNotes>, List <tblCollaborator> > result = null; result = noteService.labelshow(objtbl, objtbl.UserID); string JSONString; JSONString = JsonConvert.SerializeObject(result); return(JSONString); }
//public string labelshow() //{ // tblLabelNotes objtbl = new tblLabelNotes(); // string userid=TempData["UserID"].ToString(); // Tuple<List<tblLabel>, List<tblLabelNotes>> result=null; // //int result = 0; // if (ModelState.IsValid) // { // result = notesApicontroller.labelshow(objtbl, userid); // } // string JSONString; // JSONString = JsonConvert.SerializeObject(result); // return JSONString; //} public async Task <string> labelshow() { token = TempData["access_token"].ToString(); TempData.Keep(); tblNotes obj = new tblNotes(); obj.UserID = UserId; int result1 = 0; string re = string.Empty; // Tuple<List<tblLabel>, List<tblLabelNotes>> result = null; string ABC = ""; tblLabelNotes objtbl = new tblLabelNotes(); string userid = TempData["UserID"].ToString(); objtbl.UserID = userid; string myString; if (External != "Log") { ABC = await notesApicontroller.labelshow(objtbl); myString = ABC; } else { ABC = await accountController.ConsumePostchipApi(objtbl, token); ABC = ABC.Replace("\\", ""); myString = ABC; myString = myString.Substring(0, myString.Length - 1); int index1 = myString.IndexOf('"'); if (index1 != -1) { myString = myString.Remove(index1, 1); } } // Tuple<List<tblLabel>, List<tblLabelNotes>> result=null; //int result = 0; //if (ModelState.IsValid) //{ // result = notesApicontroller.labelshow(objtbl, userid); //} //string JSONString; // JSONString = JsonConvert.SerializeObject(ABC); return(myString); }
public async Task <string> ConsumePostchipApi(tblLabelNotes model, string token) { try { var client = new HttpClient(); string returnurl = currenturl + "/api/NotesApi/labelshow"; client.BaseAddress = new Uri(returnurl); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token); //var response = await client.GetAsync(returnurl); //var contents = await response.Content.ReadAsStringAsync(); //var data = JsonConvert.DeserializeObject<List<tblLabelNotes>>(contents); var body = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("ID", Convert.ToString(model.ID)), new KeyValuePair <string, string>("LabelID", model.LabelID), new KeyValuePair <string, string>("UserID", Convert.ToString(model.UserID)), new KeyValuePair <string, string>("NotesID", Convert.ToString(model.NotesID)) }; //var content = new FormUrlEncodedContent(body); var response = await client.PostAsync(returnurl, new FormUrlEncodedContent(body)); // var response = await httpClient.PostAsync(returnurl, new FormUrlEncodedContent(body)); var contents = await response.Content.ReadAsStringAsync(); return(contents); } catch (Exception ex) { Logger.Write(ex.ToString());; } return(""); }
public Tuple <List <tblLabel>, List <tblLabelNotes>, List <tblCollaborator> > labelshow(tblLabelNotes objtbl, string userid) { int result = 0; //List<tblLabel> response =new List<tblLabel>(); var lbl = new List <tblLabel>(); var lblname = new List <tblLabelNotes>(); var Collaborator = new List <tblCollaborator>(); ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId()); //current user check in share colum tblCollaborators tbl var share = from t in applicationDbContext.tblCollaborators where t.SharID == user.Email select t; var sharelist = new List <tblCollaborator>(); foreach (tblCollaborator data1 in share) { sharelist.Add(data1); } var temp = new List <tblNotes>(); for (int i = 0; i < sharelist.Count(); i++) { int id = sharelist[i].NotesID; var sharedata = from t in applicationDbContext.tblNotes where t.ID == id select t; foreach (tblNotes data12 in sharedata) { temp.Add(data12); } } for (int i = 0; i < temp.Count(); i++) { string userid1 = temp[i].UserID; int nodeid = temp[i].ID; var data1 = from a in applicationDbContext.tblLabelNotes where a.UserID == userid1 && a.NotesID == nodeid select a; foreach (tblLabelNotes itemdata in data1) { lblname.Add(itemdata); } var newdata12 = from a in applicationDbContext.tblCollaborators where a.UserID == userid1 && a.NotesID == nodeid && a.SharID == user.Email select a; foreach (tblCollaborator itm in newdata12) { //change email for share var own = itm.OwnerID; var sh = itm.SharID; itm.SharID = own; itm.OwnerID = sh; Collaborator.Add(itm); } } var data = from a in applicationDbContext.tblLabelNotes where a.UserID == userid select a; foreach (tblLabelNotes itemdata in data) { lblname.Add(itemdata); } for (int i = 0; i < lblname.Count; i++) { var id = int.Parse(lblname[i].LabelID.ToString()); var newdata = from a in applicationDbContext.tblLabels where a.ID == id select a; foreach (tblLabel itemdata in newdata) { lbl.Add(itemdata); } } var newdata1 = from a in applicationDbContext.tblCollaborators where a.UserID == userid select a; foreach (tblCollaborator itm in newdata1) { Collaborator.Add(itm); } return(Tuple.Create(lbl, lblname, Collaborator)); }
public async Task <int> addnotelabel(tblNotes objtbl) { int result = 0; // Add new label. var listlabels = new List <int>(); var labelnames = new List <string>(); if (objtbl.Mode == 1) { try { var labels = objtbl.Label.Split(','); foreach (string data in labels) { labelnames.Add(data); } foreach (string item in labelnames) { var iddata = from a in applicationDbContext.tblLabels where a.Label == item select a; foreach (tblLabel itemdata in iddata) { listlabels.Add(itemdata.ID); } } for (int i = 0; i < listlabels.Count(); i++) { string cn = listlabels[i].ToString(); var check = from a in applicationDbContext.tblLabelNotes where a.NotesID == objtbl.ID && a.LabelID == cn select a; if (check.Count() == 0) { tblLabelNotes label = new tblLabelNotes(); label.LabelID = cn; label.NotesID = objtbl.ID; label.UserID = objtbl.UserID; applicationDbContext.tblLabelNotes.Add(label); result = await applicationDbContext.SaveChangesAsync(); } } } catch (Exception ex) { ex.ToString(); } return(result); } if (objtbl.Mode == 2) { var iddata = from a in applicationDbContext.tblLabels where a.Label == objtbl.Label select a; foreach (tblLabel itemdata in iddata) { listlabels.Add(itemdata.ID); } var abc = listlabels[0].ToString(); tblLabelNotes obj = applicationDbContext.tblLabelNotes.Where(i => i.LabelID == abc && i.NotesID == objtbl.ID).FirstOrDefault(); applicationDbContext.tblLabelNotes.Remove(obj); result = await applicationDbContext.SaveChangesAsync(); } if (objtbl.Mode == 3) { try { var latestid = from a in applicationDbContext.tblNotes orderby a.ID descending select a.ID; var id = latestid.First(); var newrecord = from a in applicationDbContext.tblLabelNotes where a.UserID == objtbl.UserID && a.NotesID == objtbl.ID select a; var list = new List <string>(); foreach (tblLabelNotes tbl in newrecord) { list.Add(tbl.LabelID); } for (int i = 0; i < list.Count(); i++) { tblLabelNotes label = new tblLabelNotes(); label.LabelID = list[i]; label.NotesID = id; label.UserID = objtbl.UserID; applicationDbContext.tblLabelNotes.Add(label); result = await applicationDbContext.SaveChangesAsync(); } } catch (Exception ex) { ex.ToString(); } return(result); } return(result); }