public async Task <JsonResult> STInsert()
{
var id = Guid.Parse(Request.Form["id"]);
var name = Request.Form["name"];
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var catID = Guid.Parse(Request.Form["cid"]);
var uid = Guid.Parse(Request.Form["uid"]);
var sadmin = Guid.Parse("3c35cccc-d48d-4721-9283-d58faeac6cc1");
try {
if (!UserAccessLevelService.HasAccess(uid, sadmin))
{
return(Failed(MessageUtilityService.ContactAdmin("Content")));
}
if (StatusTypesReferencesService.Insert(id, name, desc, oid, aid, dtid, catID))
{
return(Success(id.ToString()));
}
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.FailedInsert("")));
} catch {
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.ServerError()));
}
}
public async Task <JsonResult> MSInsert()
{
var id = Guid.Parse(Request.Form["id"]);
var uid = Guid.Parse(Request.Form["uid"]);
var name = Request.Form["name"];
var aid = Guid.Parse(Request.Form["aid"]);
var scid = Guid.Parse(Request.Form["scid"]);
var sbid = Guid.Parse(Request.Form["sbid"]);
var slid = Guid.Parse(Request.Form["slid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
try {
if (MyStoreService.IsStoreNameAllowUse(name))
{
//remove dtid
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.InUse("Store Name")));
}
if (MyStoreService.Insert(id, uid, name, aid, scid, sbid, slid, false, dtid))
{
return(Success(id.ToString()));
}
//removing datetimeID
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.FailedInsert("MyStore")));
} catch {
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.ServerError()));
}
}
public async Task <JsonResult> UInsert()
{
var dtid = Guid.Parse(Request.Form["dtid"]);
try {
var id = Guid.Parse(Request.Form["id"]);
var fname = Request.Form["fname"];
var lname = Request.Form["lname"];
var mname = Request.Form["mname"];
var add = Request.Form["add"];
var email = Request.Form["email"];
var pass = Request.Form["pass"];
var repass = Request.Form["rpass"];
var cnum = Request.Form["cnum"];
var isAllow = Boolean.Parse(Request.Form["ia"]);
var areg = Guid.Parse(Request.Form["areg"]);
var profID = Guid.Parse(Request.Form["profid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var hashedPassword = UsersService.GenerateHashPassword(pass);
if (ApplicationInformationService.GetByID(areg) == null)
{
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed("Please do not modify link to complete the signup process " + areg));
}
if (!pass.Equals(repass))
{
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed("Make sure password matches retype password"));
}
if (ValidateEmailAddress(email))
{
if (ValidateContactNumber(cnum))
{
if (UsersService.Insert(id, fname, lname, mname, add, email, hashedPassword, cnum, isAllow, areg, profID, dtid))
{
InsertNewUserInformation(id, aid, Guid.Parse("7d789492-1c6c-4ea2-9e1e-893a68620d1e"));
return(Success(id.ToString()));
}
}
else
{
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.InUse("Mobile Number")));
}
}
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.FailedInsert("Signup")));
} catch {
DateTimeStorageService.RemoveAdmin(dtid);
return(Failed(MessageUtilityService.ServerError()));
}
}
public async Task <JsonResult> ELInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var name = Request.Form["name"];
var email = Request.Form["email"];
var dtid = Guid.Parse(Request.Form["dtid"]);
var cnum = Request.Form["cnum"];
if (EmailListService.Insert(id, name, email, dtid, cnum))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Email")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> SIInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var sinput = Request.Form["input"];
var oid = Guid.Parse(Request.Form["oid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var api = Guid.Parse(Request.Form["aid"]);
if (SearchInputService.Insert(id, sinput, oid, dtid, api))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Input")));
}catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> QQAInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var desc = Request.Form["desc"];
var point = float.Parse(Request.Form["p"]);
var ic = Boolean.Parse(Request.Form["ic"]);
var qqid = Guid.Parse(Request.Form["qqid"]);
if (QuizQuestionAnswerService.Insert(id, desc, point, ic, qqid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Choice")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> MRInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var name = Request.Form["name"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (MessagingRoomService.Insert(id, name, oid, aid, dtid, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Room")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> QUAInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var qtid = Guid.Parse(Request.Form["qtid"]);
var qqid = Guid.Parse(Request.Form["qqid"]);
var qaid = Guid.Parse(Request.Form["qaid"]);
var oa = Request.Form["oa"];
var pe = float.Parse(Request.Form["pe"]);
if (QuizUserAnswerService.Insert(id, qtid, qqid, qaid, oa, pe))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Answer")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> UALInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var uid = Guid.Parse(Request.Form["uid"]);
var alid = Guid.Parse(Request.Form["alid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (UserAccessLevelService.Insert(id, uid, alid, aid, dtid, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> SRDInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var oid = Guid.Parse(Request.Form["oid"]);
var sid = Guid.Parse(Request.Form["sid"]);
var api = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var h = Request.Form["h"];
if (SignalRDataService.Insert(id, oid, sid, api, dtid, h, false))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Signal")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> ICInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var color = Request.Form["color"];
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var cid = Guid.Parse(Request.Form["cid"]);
if (IS_ItemColorService.Insert(id, color, desc, oid, aid, cid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("ItemColor")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> SLInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (SystemLogsService.Insert(id, desc, oid, aid, dtid, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Logs")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> DSInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var ca = DateTime.Parse(Request.Form["ca"]);
var ua = DateTime.Parse(Request.Form["ua"]);
var cid = Guid.Parse(Request.Form["cid"]);
if (DateTimeStorageService.Insert(id, oid, aid, ca, ua, cid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Date Time")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> DSInsertTZ()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var tz = Request.Form["tz"];
var cid = Guid.Parse(Request.Form["cid"]);
var time = DateTimeUtil.GetTimeNowByUTC(tz);
if (DateTimeStorageService.Insert(id, oid, aid, time, time, cid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("DateTime")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> QQInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var ques = Request.Form["ques"];
var qiid = Guid.Parse(Request.Form["qiid"]);
var order = int.Parse(Request.Form["order"]);
var points = int.Parse(Request.Form["p"]);
var sid = Guid.Parse(Request.Form["sid"]);
if (QuizQuestionsService.Insert(id, ques, qiid, order, points, sid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Question")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> LPInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var title = Request.Form["title"];
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var bgid = Guid.Parse(Request.Form["bgid"]);
var mid = Guid.Parse(Request.Form["mid"]);
var tdid = Guid.Parse(Request.Form["tdid"]);
if (LeadPageService.Insert(id, title, desc, oid, bgid, mid, tdid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Lead Pages")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> ILSInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var oid = Guid.Parse(Request.Form["oid"]);
var source = Request.Form["src"];
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var cid = Guid.Parse(Request.Form["cid"]);
var order = int.Parse(Request.Form["o"]);
if (ImageLinkStorageService.Insert(id, oid, source, aid, dtid, false, cid, order))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Image")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> COnsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var uid = Guid.Parse(Request.Form["uid"]);
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var iS = Boolean.Parse(Request.Form["iS"]);
var tc = float.Parse(Request.Form["tc"]);
if (CustomerOrderService.Insert(id, uid, oid, aid, dtid, iS, tc))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Customer Order")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> SMInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var name = Request.Form["name"];
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var pi = Guid.Parse(Request.Form["pi"]);
var cid = Guid.Parse(Request.Form["cid"]);
if (ShopManagementService.Insert(id, name, desc, oid, aid, pi, cid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Shop")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> RCInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var uid = Guid.Parse(Request.Form["uid"]);
var suid = Guid.Parse(Request.Form["suid"]);
var rtid = Guid.Parse(Request.Form["rtid"]);
var reason = Request.Form["reason"];
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
if (ReportClaimsService.Insert(id, uid, suid, rtid, reason, aid, dtid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert(" Report")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> DSInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var title = Request.Form["title"];
var desc = Request.Form["desc"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var cid = Guid.Parse(Request.Form["cid"]);
var order = int.Parse(Request.Form["o"]);
if (DescriptionStorageService.Insert(id, title, desc, oid, aid, cid, order))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Description")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> GDInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var sid = Guid.Parse(Request.Form["sid"]);
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var order = int.Parse(Request.Form["order"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
var catID = Guid.Parse(Request.Form["cid"]);
if (GroupingsDataService.Insert(id, sid, oid, aid, order, dtid, ia, catID))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> COIInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var iid = Guid.Parse(Request.Form["iid"]);
var icid = Guid.Parse(Request.Form["icid"]);
var sc = float.Parse(Request.Form["sc"]);
var q = int.Parse(Request.Form["q"]);
var coid = Guid.Parse(Request.Form["coid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
if (CustomerOrderItemService.Insert(id, iid, icid, sc, q, coid, aid, dtid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Customer Items")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> NMInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var title = Request.Form["title"];
var message = Request.Form["message"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ir = Boolean.Parse(Request.Form["ir"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (NotificationManagerService.Insert(id, title, message, oid, aid, dtid, ir, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Notification")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> ISInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var bcode = Request.Form["bcode"];
var iid = Guid.Parse(Request.Form["iid"]);
var ssid = Guid.Parse(Request.Form["ssid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var sku = Request.Form["sku"];
var serNum = Request.Form["serNum"];
var icid = Guid.Parse(Request.Form["icid"]);
if (IS_ItemStockService.Insert(id, bcode, sku, serNum, iid, ssid, dtid, icid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Stock")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> LSInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var oid = Guid.Parse(Request.Form["oid"]);
var lcid = Guid.Parse(Request.Form["lcid"]);
var longi = float.Parse(Request.Form["longi"]);
var lat = float.Parse(Request.Form["lat"]);
var desc = Request.Form["desc"];
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (LocationStorageService.Insert(id, oid, lcid, longi, lat, desc, dtid, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Location")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> RSInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var sid = Guid.Parse(Request.Form["sid"]);
var rid = Guid.Parse(Request.Form["rid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var title = Request.Form["title"];
var comment = Request.Form["comment"];
var stars = int.Parse(Request.Form["s"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var ia = Boolean.Parse(Request.Form["ia"]);
if (ReviewStorageService.Insert(id, sid, rid, aid, title, comment, stars, dtid, ia))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Review")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> QIInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var name = Request.Form["name"];
var oid = Guid.Parse(Request.Form["oid"]);
var aid = Guid.Parse(Request.Form["aid"]);
var qc = Request.Form["qc"];
var htl = Boolean.Parse(Request.Form["htl"]);
var sid = Guid.Parse(Request.Form["sid"]);
var qsid = Guid.Parse(Request.Form["qsid"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
if (QuizInfoService.Insert(id, name, oid, aid, qc, htl, sid, qsid, dtid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Quiz")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> IIInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var title = Request.Form["title"];
var desc = Request.Form["desc"];
var price = float.Parse(Request.Form["price"]);
var aid = Guid.Parse(Request.Form["aid"]);
var oid = Guid.Parse(Request.Form["oid"]);
var icid = Guid.Parse(Request.Form["icid"]);
var ic = Boolean.Parse(Request.Form["ic"]);
var quantity = int.Parse(Request.Form["q"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var condition = Guid.Parse(Request.Form["cid"]);
if (IS_ItemService.Insert(id, title, desc, price, aid, oid, icid, ic, quantity, dtid, condition))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Item")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public async Task <JsonResult> QTInsert()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var qiid = Guid.Parse(Request.Form["qiid"]);
var uid = Guid.Parse(Request.Form["uid"]);
var tp = float.Parse(Request.Form["tp"]);
var dtid = Guid.Parse(Request.Form["dtid"]);
var aid = Guid.Parse(Request.Form["aid"]);
//check if user already in quizTaker then inform them
if (QuizTakerService.GetByUQA(uid, qiid, aid) != null)
{
return(Failed(MessageUtilityService.AlreadyInRecord("owner of this quiz")));
}
if (QuizTakerService.Insert(id, qiid, uid, tp, dtid, aid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedInsert("Takers")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}