public void SavePublicDesign(gPrivateFormModel model, int officeId) { using (var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm)) { int fid = model.FormID; gPublicFormModel found = db.Fetch <gPublicFormModel>($"select * from form_public where FormID={fid}").FirstOrDefault(); if (found != null) { found.Description = model.Description; found.SystemDate = DateTime.Now; found.Content = model.Content; found.IsActive = 1; found.IsSurveyForm = 0; db.Update(found, fid); } else { //Save Form Design Object gPublicFormModel design = new gPublicFormModel(); design.Description = model.Description; design.SystemDate = DateTime.Now; design.Content = model.Content; design.IsActive = 1; design.IsSurveyForm = 0; db.Save(design); } } }
public string SaveFormAnswer(gFormSavedModel model) { if (!IsFormAlreadyExist(model)) { var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm); model.SystemDate = DateTime.Now; db.Save(model); return("Form Saved Succefully"); } return("Form Already Exists"); }
public void SavePrivateTag(gFormPrivateTag model) { using (var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm)) { gFormPrivateTag found = db.Fetch <gFormPrivateTag>($"select * from form_tag_private where TagID={model.TagID}").FirstOrDefault(); if (found != null) { db.Update(model, model.TagID); } else { db.Save(model); } } }
public void SavePublicTag(gPublicTagModel model) { model.IsSurveyForm = 1; using (var db = new LTCDataModel.PetaPoco.Database(DbConfiguration.LtcForm)) { gPublicTagModel found = db.Fetch <gPublicTagModel>($"select * from form_tag_public where TagID={model.TagID} ").FirstOrDefault(); if (found != null) { db.Update(model, model.TagID); } else { db.Save(model); } } }