public async Task <JsonResult> DSGet(string id, string aid)
{
try {
var data = DateTimeStorageService.GetByID(Guid.Parse(id));
return(Success(DateTimeStorageVM.MToVM(data)));
} catch { 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 static MessagingConversationVM SetSubData(MessagingConversation data)
{
var model = MessagingConversationVM.MToVM(data);
model.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
return(model);
}
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 static ReviewStoragesVM SetSubData(ReviewStorages data, Guid aid)
{
var model = ReviewStoragesVM.MToVM(data);
model.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
return(model);
}
public async Task <JsonResult> ELIsEmailExist()
{
try {
//checks if email exist in the database else create one
var name = Request.Form["name"];
var email = Request.Form["email"];
var aid = Guid.Parse(Request.Form["aid"]);
var cnum = Request.Form["cnum"];
var data = EmailListService.GetByEAdd(email);
var tz = Request.Form["tz"];
if (data != null)
{
if (InsertNewEmailList(Guid.NewGuid(), name, email, aid, cnum))
{
return(Success(true));
}
return(Failed(MessageUtilityService.ServerError()));
}
else
{
//update time updated data
DateTimeStorageService.Update(data.DateTimeID, data.ID, DateTimeStorageService.GetByTZ(tz));
EmailListService.Update(data.ID, name, data.Email, data.DateTimeID, cnum);
}
//email is already registered in the database
return(Success(false));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public static NotificationManagerVM SetSubData(NotificationManager data, Guid aid)
{
var model = NotificationManagerVM.MToVM(data);
model.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
return(model);
}
//setting sub data sub classes of this class properties are set here
public static UsersVM SetSubData(Users item, Guid aid)
{
var model = UsersVM.MToVM(item);
model.DateTimeData = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByOID(item.DateTimeStorageID, aid).FirstOrDefault());
model.ProfileImage = ImageLinkStorageVM.MToVM(ImageLinkStorageService.GetByIDAdmin(item.ProfileImageID));
return(model);
}
public static ReportClaimsVM SetSubData(ReportClaims data, Guid aid)
{
var model = ReportClaimsVM.MToVM(data);
model.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
model.ReportType = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.ReportTypeID));
return(model);
}
public static QuizTakersVM SetSubData(QuizTakers data, Guid aid)
{
var model = QuizTakersVM.MToVM(data);
model.QuizInfo = QuizInfoService.SetSubData(QuizInfoService.GetByID(data.QuizInfoID, data.UserID, aid), aid);
model.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
return(model);
}
public static IS_ItemStockVM SetSubData(IS_ItemStock data, Guid aid)
{
var model = IS_ItemStockVM.MToVM(data);
model.DateTimeStorage = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
model.StockStatus = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.StockStatusID));
return(model);
}
public static CustomerOrderVM SetSubData(CustomerOrder model)
{
var data = CustomerOrderVM.MToVM(model);
data.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByOID(model.ID, model.API).FirstOrDefault());
data.OrderItem = CustomerOrderItemService.SetSubDatas(CustomerOrderItemService.GetByCOID(model.ID, model.API));
return(data);
}
public static UserAccessLevelVM SetSubData(UserAccessLevel item, Guid aid)
{
var model = UserAccessLevelVM.MToVM(item);
model.AccessLevel = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(item.AccessLevelID));
model.DateTimeData = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(item.DateTimeStorageID));
return(model);
}
public static GroupingsDataVM SetSubData(GroupingsData data, Guid aid)
{
var model = GroupingsDataVM.MToVM(data);
model.DateTimeData = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
model.CategoryStatus = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByOIDAID(data.CategoryID, aid).FirstOrDefault());
return(model);
}
public static UsersVM SetSubDataAdmin(Users item)
{
var model = UsersVM.MToVM(item);
model.DateTimeData = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(item.DateTimeStorageID));
model.ProfileImage = ImageLinkStorageVM.MToVM(ImageLinkStorageService.GetByIDAdmin(item.ProfileImageID));
return(model);
}
public static CustomerOrderItemVM SetSubData(CustomerOrderItem model)
{
var data = CustomerOrderItemVM.MToVM(model);
data.DateTime = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByOID(model.ID, model.API).FirstOrDefault());
data.Item = IS_ItemService.SetSubData(IS_ItemService.GetByID(model.ItemID), model.API);
data.ItemColor = IS_ItemColorService.SetSubData(IS_ItemColorService.GetByID(model.ItemColorID));
return(data);
}
public static UserAccessLevelVM SetSubDataAdmin(UserAccessLevel model)
{
var data = UserAccessLevelVM.MToVM(model);
data.AccessLevel = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(model.AccessLevelID));
data.DateTimeData = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(model.DateTimeStorageID));
data.Application = ApplicationInformationVM.MToVM(ApplicationInformationService.GetByID(model.ApplicationID));
return(data);
}
//validate email address if it is allowed to be used
private static bool InsertNewUserInformation(Guid userID, Guid aid, Guid locCatID)
{
try {
var dtid = Guid.NewGuid();
DateTimeStorageService.Insert(dtid, userID, aid, DateTime.Now, DateTime.Now, Guid.Parse("a2e2d83d-dd8d-4a66-bacf-94ad90344ca7"));
LocationStorageService.Insert(Guid.NewGuid(), userID, locCatID, 0, 0, "User Location", dtid, false);
return(true);
} catch { return(false); }
}
public static QuizInfoVM SetSubData(QuizInfo data, Guid aid)
{
var model = QuizInfoVM.MToVM(data);
model.QuizStatus = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.QuizStatus));
model.Status = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.Status));
model.DateTimeStorage = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
return(model);
}
private bool InsertNewEmailList(Guid id, string name, string email, Guid aid, string cnum)
{
try {
var dtid = Guid.NewGuid();
var time = DateTime.Now;
DateTimeStorageService.Insert(dtid, id, aid, time, time, Guid.Parse("931b5cca-e652-49cf-bc6c-ed96cf053604"));
EmailListService.Insert(id, name, email, dtid, cnum);
return(true);
} catch { return(false); }
}
public static IS_ItemVM SetSubData(IS_Item data, Guid aid)
{
var model = IS_ItemVM.MToVM(data);
model.DateTimeStorage = DateTimeStorageVM.MToVM(DateTimeStorageService.GetByID(data.DateTimeStorageID));
model.ItemCategory = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.ItemCategoryID));
model.ItemColors = IS_ItemColorService.SetSubDatas(IS_ItemColorService.GetByOwnerID(data.ID, aid));
model.Images = ImageLinkStorageVM.MsToVMs(ImageLinkStorageService.GetByOIDAPI(data.ID, aid));
model.Condition = StatusTypesReferencesVM.MToVM(StatusTypesReferencesService.GetByID(data.ConditionID));
return(model);
}
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> DSRemove()
{
try {
var id = Guid.Parse(Request.Form["id"]);
var aid = Guid.Parse(Request.Form["aid"]);
var oid = Guid.Parse(Request.Form["oid"]);
if (DateTimeStorageService.Remove(id, aid, oid))
{
return(Success(id.ToString()));
}
return(Failed(MessageUtilityService.FailedRemove("DateTime")));
} catch { return(Failed(MessageUtilityService.ServerError())); }
}
public static bool Remove(Guid id, Guid oid, Guid api)
{
try {
using (var context = new CentralProcessContext()){
var query = (from i in context.ImageLinkStorageDB where i.ID == id && i.OwnerID == oid && i.API == api select i).FirstOrDefault();
context.ImageLinkStorageDB.Remove(query);
context.SaveChanges();
if (DateTimeStorageService.Remove(query.DateTimeStorageID, api, query.ID))
{
return(true);
}
return(false);
}
} catch { return(false); }
}
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 static bool Remove(Guid id, Guid aid, Guid oid, Guid cid)
{
try {
using (var context = new CentralProcessContext()) {
var query = (from i in context.QuizInfoDB where i.ID == id && i.ApplicationID == aid && i.OwnerID == oid select i).FirstOrDefault();
context.QuizInfoDB.Remove(query);
context.SaveChanges();
//removes quizQuestions and datetime associated with this tables
if (QuizQuestionsService.RemoveByQIID(id, aid, cid) && DateTimeStorageService.Remove(query.DateTimeStorageID, aid, query.ID))
{
return(true);
}
return(false);
}
} catch { return(false); }
}
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 static bool Remove(Guid id, Guid qiid, Guid aid)
{
try {
using (var context = new CentralProcessContext()) {
var query = (from i in context.QuizTakersDB where i.ID == id && i.QuizInfoID == qiid select i).FirstOrDefault();
context.QuizTakersDB.Remove(query);
context.SaveChanges();
//remove quizUserAnswers
if (QuizUserAnswerService.RemoveByQTID(id) && DateTimeStorageService.Remove(query.DateTimeStorageID, aid, query.ID))
{
return(true);
}
return(false);
}
} catch { return(false); }
}
public static bool Remove(Guid id, Guid uid, Guid aid)
{
try {
using (var context = new CentralProcessContext()){
var query = (from i in context.CustomerOrderDB where i.ID == id && i.UserID == uid && i.API == aid select i).FirstOrDefault();
context.CustomerOrderDB.Remove(query);
context.SaveChanges();
//remove customerOrderItem
//remove date time
if (DateTimeStorageService.Remove(query.DateTimeID, aid, id) && CustomerOrderItemService.RemoveByCOID(id, aid))
{
return(true);
}
return(false);
}
} catch { return(false); }
}
private static bool InsertUserAccessLevel(Guid aid, Guid uid)
{
try {
var dtid = Guid.NewGuid();
var ualID = Guid.NewGuid();
DateTimeStorageService.Insert(dtid, ualID, aid, DateTime.Now, DateTime.Now, Guid.Parse("c4926f90-2be8-4c62-94ed-5399be276f11"));
//check if application exist and user exist
if (ApplicationInformationService.IsApplicationExist(aid) && UsersService.IsUserExist(uid))
{
//insert new user access level for this user
var ual = Guid.Parse("a2e2d83d-dd8d-4a66-bacf-94ad90344ca7");
UserAccessLevelService.Insert(ualID, uid, ual, aid, dtid, false);
}
return(true);
}
catch { return(false); }
}
