public Int32 insertDiscount(Models.MstDiscount discount)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstDiscount newDiscount = new Data.MstDiscount();
newDiscount.Discount = discount.Discount;
newDiscount.DiscountRate = discount.DiscountRate;
newDiscount.IsInclusive = discount.IsInclusive;
newDiscount.AccountId = discount.AccountId;
newDiscount.IsLocked = discount.IsLocked;
newDiscount.CreatedById = userId;
newDiscount.CreatedDateTime = DateTime.Now;
newDiscount.UpdatedById = userId;
newDiscount.UpdatedDateTime = DateTime.Now;
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return newDiscount.Id;
}
catch
{
return 0;
}
}
public Int32 insertDiscount(Models.MstDiscount discount)
{
try
{
var userId = (from d in db.MstUsers where d.UserId == User.Identity.GetUserId() select d.Id).SingleOrDefault();
Data.MstDiscount newDiscount = new Data.MstDiscount();
newDiscount.Discount = discount.Discount;
newDiscount.DiscountRate = discount.DiscountRate;
newDiscount.IsInclusive = discount.IsInclusive;
newDiscount.AccountId = discount.AccountId;
newDiscount.IsLocked = discount.IsLocked;
newDiscount.CreatedById = userId;
newDiscount.CreatedDateTime = DateTime.Now;
newDiscount.UpdatedById = userId;
newDiscount.UpdatedDateTime = DateTime.Now;
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return(newDiscount.Id);
}
catch
{
return(0);
}
}
public Int32 postItem(Entities.MstDiscount discount)
{
try
{
var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;
Data.MstDiscount newDiscount = new Data.MstDiscount();
newDiscount.Discount = "n/a";
newDiscount.DiscountRate = 0;
newDiscount.IsVatExempt = false;
newDiscount.IsDateScheduled = false;
newDiscount.DateStart = DateTime.Today;
newDiscount.DateEnd = DateTime.Today;
newDiscount.IsTimeScheduled = false;
newDiscount.TimeStart = DateTime.Today;
newDiscount.TimeEnd = DateTime.Today;
newDiscount.IsDayScheduled = false;
newDiscount.DayMon = false;
newDiscount.DayTue = false;
newDiscount.DayWed = false;
newDiscount.DayThu = false;
newDiscount.DayFri = false;
newDiscount.DaySat = false;
newDiscount.DaySun = false;
newDiscount.EntryUserId = userId;
newDiscount.EntryDateTime = DateTime.Today;
newDiscount.UpdateUserId = userId;
newDiscount.UpdateDateTime = DateTime.Today;
newDiscount.IsLocked = false;
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return(newDiscount.Id);
}
catch (Exception e)
{
Debug.WriteLine(e);
return(0);
}
}
public Int32 postDiscount()
{
try
{
Data.MstDiscount newDiscount = new Data.MstDiscount();
newDiscount.Discount = "n/a";
newDiscount.DiscountRate = 0;
newDiscount.IsVatExempt = false;
newDiscount.IsDateScheduled = false;
newDiscount.DateStart = DateTime.Today;
newDiscount.DateEnd = DateTime.Today;
newDiscount.IsTimeScheduled = false;
newDiscount.TimeStart = DateTime.Now;
newDiscount.TimeEnd = DateTime.Now;
newDiscount.IsDayScheduled = false;
newDiscount.DayMon = false;
newDiscount.DayTue = false;
newDiscount.DayWed = false;
newDiscount.DayThu = false;
newDiscount.DayFri = false;
newDiscount.DaySat = false;
newDiscount.DaySun = false;
newDiscount.EntryUserId = UserId();
newDiscount.EntryDateTime = DateTime.Today;
newDiscount.UpdateUserId = UserId();
newDiscount.UpdateDateTime = DateTime.Today;
newDiscount.IsLocked = false;
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return(newDiscount.Id);
}
catch (Exception e)
{
return(0);
}
}
public HttpResponseMessage AddDiscount(Entities.MstDiscount objDiscount)
{
try
{
var currentUser = from d in db.MstUsers
where d.UserId == User.Identity.GetUserId()
select d;
if (currentUser.Any())
{
var currentUserId = currentUser.FirstOrDefault().Id;
var userForms = from d in db.MstUserForms
where d.UserId == currentUserId &&
d.SysForm.FormName.Equals("SystemTables")
select d;
if (userForms.Any())
{
if (userForms.FirstOrDefault().CanAdd)
{
var accounts = from d in db.MstAccounts.OrderBy(d => d.Account)
where d.IsLocked == true
select d;
if (accounts.Any())
{
Data.MstDiscount newDiscount = new Data.MstDiscount
{
Discount = objDiscount.Discount,
DiscountRate = objDiscount.DiscountRate,
IsInclusive = objDiscount.IsInclusive,
AccountId = objDiscount.AccountId,
IsLocked = true,
CreatedById = currentUserId,
CreatedDateTime = DateTime.Now,
UpdatedById = currentUserId,
UpdatedDateTime = DateTime.Now
};
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return(Request.CreateResponse(HttpStatusCode.OK, newDiscount.Id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "No account found. Please setup at least one account for discounts."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add discount."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access for this system table page."));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
}
}
public int Post(Models.MstDiscount discount)
{
try
{
var isLocked = true;
var identityUserId = User.Identity.GetUserId();
var mstUserId = (from d in db.MstUsers where "" + d.Id == identityUserId select d.Id).SingleOrDefault();
var date = DateTime.Now;
Data.MstDiscount newDiscount = new Data.MstDiscount();
newDiscount.Id = discount.Id;
newDiscount.Discount = discount.Discount;
newDiscount.DiscountRate = discount.DiscountRate;
newDiscount.IsVatExempt = discount.IsVatExempt;
newDiscount.IsDateScheduled = discount.IsDateScheduled;
newDiscount.DateStart = Convert.ToDateTime(discount.DateStart);
newDiscount.DateEnd = Convert.ToDateTime(discount.DateEnd);
newDiscount.IsTimeScheduled = discount.IsTimeScheduled;
newDiscount.TimeStart = Convert.ToDateTime(discount.TimeStart);
newDiscount.TimeEnd = Convert.ToDateTime(discount.TimeEnd);
newDiscount.IsDayScheduled = discount.IsDayScheduled;
newDiscount.DayMon = discount.DayMon;
newDiscount.DayTue = discount.DayTue;
newDiscount.DayWed = discount.DayWed;
newDiscount.DayThu = discount.DayThu;
newDiscount.DayFri = discount.DayFri;
newDiscount.DaySat = discount.DaySat;
newDiscount.DaySun = discount.DaySun;
newDiscount.EntryUserId = mstUserId;
newDiscount.EntryDateTime = date;
newDiscount.UpdateUserId = mstUserId;
newDiscount.UpdateDateTime = date;
newDiscount.IsLocked = isLocked;
db.MstDiscounts.InsertOnSubmit(newDiscount);
db.SubmitChanges();
return newDiscount.Id;
}
catch
{
return 0;
}
}
