//[Authorize(Roles = "level3permission")]
public ActionResult CancelReferralOrder(int?id)
{
try
{
using (var db = new StoreContext())
{
ReferralOrder referralOrder = db.ReferralOrders.Find(id);
if (referralOrder != null)
{
referralOrder.ReferralOrderStatusId = 5;
referralOrder.ConfirmationDate = null;
referralOrder.ConfirmationUserId = userId;
referralOrder.Id = userId;
referralOrder.LogDate = db.Database.SqlQuery <DateTime>("SELECT GETDATE()").Single();
db.ReferralOrders.Attach(referralOrder);
db.Entry(referralOrder).State = EntityState.Modified;
db.SaveChanges();
}
}
return(this.Json(new { statuscode = 1, message = "Գործողությունը կատարված է: Ուղեգիրը չեղարկվել է:" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(this.Json(new { statuscode = -1, message = "Տեխնիկական սխալ: - " + ex.Message }, JsonRequestBehavior.AllowGet));
}
}
//[Authorize(Roles = "...")]
public ActionResult DeleteReferralOrder([DataSourceRequest] DataSourceRequest request, int?id)
{
try
{
if (ModelState.IsValid)
{
using (var db = new StoreContext())
{
var item = new ReferralOrder()
{
ReferralOrderId = Convert.ToInt32(id),
};
item.Id = userId;
item.LogDate = db.Database.SqlQuery <DateTime>("SELECT GETDATE()").Single();
db.ReferralOrders.Attach(item);
db.ReferralOrders.Remove(item);
db.SaveChanges();
}
}
return(Json(new { success = true, responseText = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, responseText = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
//[Authorize(Roles = "...")]
public ActionResult UpdateReferral(int?id)
{
try
{
using (var db = new StoreContext())
{
this.ViewBugs(db);
ReferralOrder item = db.ReferralOrders.Find(id);
return(View("ReferralOrderTemplate", item));
}
}
catch (Exception ex)
{
return(RedirectToAction("Index1", "Error", new { msg = ex.Message }));
}
}
//[Authorize(Roles = "...")]
public ActionResult SaveReferralOrder(ReferralOrderTemplate referralOrderTemplate)
{
try
{
using (var db = new StoreContext())
{
int?cnt = db.ReferralOrderItems.Where(p => p.ReferralOrderId == referralOrderTemplate.ReferralOrderId).Count();
if (cnt == 0)
{
var referralOrder = new ReferralOrder();
referralOrder.ReferralOrderId = referralOrderTemplate.ReferralOrderId;
referralOrder.ReferralId = referralOrderTemplate.ReferralId;
referralOrder.ConfirmOrderDate = referralOrderTemplate.ConfirmOrderDate;
referralOrder.ReferralOrderDate = referralOrderTemplate.ReferralOrderDate;
referralOrder.OrganizationId = referralOrderTemplate.OrganizationId;
referralOrder.ReferralOrderStatusId = 1;
referralOrder.Id = userId;
referralOrder.LogDate = db.Database.SqlQuery <DateTime>("SELECT GETDATE()").Single();
db.ReferralOrders.Add(referralOrder);
}
else
{
ReferralOrder item = db.ReferralOrders.Find(referralOrderTemplate.ReferralOrderId);
item.ReferralId = referralOrderTemplate.ReferralId;
item.ConfirmOrderDate = referralOrderTemplate.ConfirmOrderDate;
item.ReferralOrderDate = referralOrderTemplate.ReferralOrderDate;
item.OrganizationId = referralOrderTemplate.OrganizationId;
item.ReferralOrderStatusId = referralOrderTemplate.ReferralOrderStatusId;
item.Id = userId;
item.LogDate = db.Database.SqlQuery <DateTime>("SELECT GETDATE()").Single();
db.Entry(item).State = EntityState.Modified;
}
db.SaveChanges();
return(Json(new { success = true, responseText = "" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, responseText = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
