public List <FavouriteHomeModel> gethome(FavouriteModel a) { SqlConnection conn = new SqlConnection(commonCode.conStr); conn.Open(); SqlCommand cmd = new SqlCommand("Pro_favourite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@login_id", SqlDbType.Int).Value = a.login_id; cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); DataTable Dt = ds.Tables[0]; conn.Close(); List <FavouriteHomeModel> fm = new List <FavouriteHomeModel>(); fm = commonCode.ConvertDataTable <FavouriteHomeModel>(Dt); return(fm); }
public CommonModal insert(FavouriteModel a) { CommonModal e1 = new CommonModal(); SqlConnection conn = new SqlConnection(commonCode.conStr); conn.Open(); SqlCommand cmd = new SqlCommand("Pro_favourite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@login_id", SqlDbType.Int).Value = a.login_id; cmd.Parameters.Add("@category_id", SqlDbType.Int).Value = a.category_id; cmd.Parameters.Add("@ad_id", SqlDbType.Int).Value = a.ad_id; cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); DataTable Dt = ds.Tables[0]; conn.Close(); if (Dt.Rows.Count > 0) { e1.ResponseStatus = Dt.Rows[0]["status"].ToString(); e1.ResponseMessage = Dt.Rows[0]["MSG"].ToString(); e1.data = Dt; } else { e1.ResponseStatus = "False"; e1.ResponseMessage = "Ad Posting Failed"; } return(e1); }
public ActionResult Index() { FavouriteModel model = new FavouriteModel { Products = _db.GetList() }; return(View(model)); }
public static Favourite Map(FavouriteModel objModel) { return(new Favourite { Id = objModel.Id, EntityId = objModel.EntityId, SectionId = objModel.SectionId, UserProfileId = objModel.UserProfileId }); }
public void Add(string userName, FavouriteModel model) { using (var db = new LiteDatabase($"{userName}.db")) { var col = db.GetCollection <FavouriteModel>("favourite"); model.UpdateDate = DateTime.Now; col.Insert(model); } }
public async Task <IActionResult> ToFavourite([FromBody] FavouriteModel model) { if (model.Value == "1") { User user = await _context.Users.Include(x => x.UserChosenTextiles).FirstOrDefaultAsync(x => x.UserName == User.Identity.Name); user.UserChosenTextiles.Add(new UserChosenTextile() { TextileId = Guid.Parse(model.TextileId), UserId = user.Id }); try { await _userManager.UpdateAsync(user); await _context.SaveChangesAsync(); } catch (Exception ex) { return(BadRequest(ex)); } return(Ok()); } else { User user = await _context.Users.Include(x => x.UserChosenTextiles) .FirstOrDefaultAsync(x => x.UserName == User.Identity.Name); if (user.UserChosenTextiles.Contains(user.UserChosenTextiles.FirstOrDefault(x => x.TextileId == Guid.Parse(model.TextileId)))) { user.UserChosenTextiles.Remove( user.UserChosenTextiles.FirstOrDefault(x => x.TextileId == Guid.Parse(model.TextileId))); try { await _userManager.UpdateAsync(user); await _context.SaveChangesAsync(); } catch (Exception ex) { return(BadRequest(ex)); } return(Ok()); } else { return(BadRequest()); } } }
public int delete(FavouriteModel a) { try { SqlConnection con = new SqlConnection(commonCode.conStr); con.Open(); SqlCommand cmd = new SqlCommand("Pro_favourite", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@fav_id", SqlDbType.Int).Value = a.fav_id; cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode; int s = (int)cmd.ExecuteNonQuery(); con.Close(); return(s); } catch (Exception ex) { return(-1); } }
public ActionResult AddRemovetoFavourites(int id, int sectionid) { var objFavourite = _repoFavourite.GetSingle(x => x.SectionId == sectionid && x.EntityId == id); if (objFavourite == null) { FavouriteModel objFavouriteModel = new FavouriteModel(); objFavouriteModel.EntityId = id; objFavouriteModel.SectionId = sectionid; objFavouriteModel.UserProfileId = _repoUserProfile.GetSingle(x => x.UserId == CurrentUser.UserId).Id; _repoFavourite.Add(FavouriteMap.Map(objFavouriteModel)); _repoFavourite.Save(); return(Json(new { status = "success", message = "added" })); } else { _repoFavourite.Delete(objFavourite); _repoFavourite.Save(); return(Json(new { status = "success", message = "removed" })); } }
public async Task <HttpResponseMessage> Post(FavouriteModel entity) { entity.Id = Guid.NewGuid().ToString(); try { var result = await Service.InsertAsync(Mapper.Map <FavouritePOCO>(entity)); if (result == 1) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.BadRequest, e.ToString())); } }
public DataTable get(FavouriteModel a) { SqlConnection conn = new SqlConnection(commonCode.conStr); conn.Open(); SqlCommand cmd = new SqlCommand("Pro_favourite", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@login_id", SqlDbType.Int).Value = a.login_id; cmd.Parameters.Add("@category_id", SqlDbType.Int).Value = a.category_id; cmd.Parameters.Add("@ad_id", SqlDbType.Int).Value = a.ad_id; cmd.Parameters.Add("@mode", SqlDbType.NVarChar).Value = a.mode; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); DataTable Dt = ds.Tables[0]; conn.Close(); return(Dt); }
public async Task <HttpResponseMessage> Put(string id, FavouriteModel entity) { try { if (id == entity.Id) { var result = await Service.UpdateAsync(Mapper.Map <FavouritePOCO>(entity)); if (result == 1) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } return(Request.CreateResponse(HttpStatusCode.BadRequest, "ID's don't match!")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.BadRequest, e.ToString())); } }
public ActionResult SaveFavouriteInfo(FavouriteModel favInfo) { _userRepository.Save(favInfo.ToEntity(_userRepository.FirstOrDefault(x => x.Id == _userID))); return(Json(new Message(TMessage.TRUE), JsonRequestBehavior.AllowGet)); }