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