private void AddEnumValue() { EnumListValue enumListValue = _enumList.EnumValues.Add(); EnumValueForm frm = new EnumValueForm(); frm.PickValues(enumListValue); if (frm.ShowDialog() == DialogResult.OK) { RefreshGrid(); } }
// POST: api/Inspection public HttpResponseMessage Post(EnumListValue enumList) { try { var provider = new EnumListValueProvider(DbInfo); var isSaved = provider.Save(enumList); return(Request.CreateResponse(HttpStatusCode.OK, isSaved)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } }
private void InitEnumListValue(EnumListValue enumListValue, DataRow row) { try { enumListValue.Key = row["guid"].ToString(); enumListValue.CreatedBy = row["created_by"].ToString(); enumListValue.OID = int.Parse(row["OID"].ToString()); enumListValue.Description = row["Description"].ToString(); enumListValue.Deleted = bool.Parse(row["deleted"].ToString()); enumListValue.Code = int.Parse(row["Code"].ToString()); enumListValue.EnumListId = row["enumListId"].ToString(); } catch (Exception ex) { throw ex; } }
public EnumListValue GetEnumList(string id) { try { string query = $"select * from dsto_EnumListValues where guid = '{id}'"; var table = DbInfo.ExecuteSelectQuery(query); if (table.Rows.Count > 0 && table.Rows.Count == 1) { System.Data.DataRow row = table.Rows[0]; EnumListValue enumListValue = new EnumListValue(null); InitEnumListValue(enumListValue, row); return(enumListValue); } } catch (Exception ex) { throw ex; } return(null); }
public override bool Save(DCAnalyticsObject obj) { EnumListValue enumListValue = obj as EnumListValue; string query = string.Empty; var exists = RecordExists("dsto_EnumListValues", enumListValue.Key); if (!exists) { query = $"insert into dsto_EnumListValues([guid],[Description],[Code],[created_by],[enumListId]) values('{enumListValue.Key}','{enumListValue.Description}','{enumListValue.Code}','Admin','{enumListValue.EnumListId}')"; } else { //update query = $"UPDATE dsto_EnumListValues SET " + $"[Description]='{enumListValue.Description}', " + $"[Code]='{enumListValue.Code}', " + $"[Deleted] = '{enumListValue.Deleted}' " + $"WHERE [guid] = '{enumListValue.Key}'"; } return(DbInfo.ExecuteNonQuery(query) > -1); }
public EnumListValues GetEnumListValue(string key) { EnumListValues enumListValues = new EnumListValues(); try { string query = $"select * from dsto_EnumListValues where enumListId = '{key}' and Deleted=0"; var table = DbInfo.ExecuteSelectQuery(query); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { EnumListValue enumListValue = enumListValues.Add(); InitEnumListValue(enumListValue, row); } } } catch (Exception ex) { throw ex; } return(enumListValues); }
private void AddMore() { EnumList prices = _configuration.EnumerationLists.Add(); prices.Name = "Prices"; EnumListValue val = prices.EnumValues.Add(); val.Code = 2000; val.Description = "Coffee"; val = prices.EnumValues.Add(); val.Code = 2000; val.Description = "Cotton"; val = prices.EnumValues.Add(); val.Code = 2000; val.Description = "Vanilla"; //Certifications FairTrade fairTrade = _configuration.Certifications.Add(CertificationTypes.FairTrade) as FairTrade; fairTrade.Farmer = new Questionaire(null); fairTrade.Name = "fairTrade"; Section section = fairTrade.Sections.Add(); section.Name = "Section1"; SubSection sb2 = section.SubSections.Add(); sb2.Name = "SubSection1"; var openQuestion1 = sb2.Questions.AddOpenQuestion(); openQuestion1.QuestionText = "Where do you stay"; openQuestion1.Name = "Residence"; var openQuestion = section.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; openQuestion = fairTrade.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; //organic Organic organic = _configuration.Certifications.Add(CertificationTypes.Organic) as Organic; organic.Farmer = new Questionaire(null); fairTrade.Name = "fairTrade"; section = fairTrade.Sections.Add(); organic.Name = "Section1"; SubSection sb1 = section.SubSections.Add(); sb1.Name = "SubSection1"; openQuestion = sb1.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; openQuestion = section.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; openQuestion = organic.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; // UTZ utz = _configuration.Certifications.Add(CertificationTypes.UTZ) as UTZ; utz.Farmer = new Questionaire(null); utz.Name = "fairTrade"; section = utz.Sections.Add(); organic.Name = "Section1"; SubSection sb = section.SubSections.Add(); sb.Name = "SubSection1"; openQuestion = sb.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; openQuestion = section.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; openQuestion = utz.Questions.AddOpenQuestion(); openQuestion.QuestionText = "Where do you stay"; openQuestion.Name = "Residence"; //Trainings Training training = _configuration.Trainings.Add(); training.Name = "Training1"; training.StartDate = DateTime.Now; training.EndDate = DateTime.Now; //trainees var tra = training.Trainees.Add(); tra.Name = "Nana"; var topic = training.Topics.Add(); topic.Name = "Topic1"; var trainer = training.Trainers.Add(); trainer.Name = "Kato"; //Purchases Purchase purchase = _configuration.Purchases.Add(); purchase.DateOfPurchase = DateTime.Now; purchase.Quantity = 50; purchase.Prices = _configuration.EnumerationLists.ByName("Prices"); purchase.ProductPrice = purchase.Prices.EnumValues.ByDescription("Coffee"); purchase.Lotid = "Lot90343"; purchase.Products = _configuration.EnumerationLists.ByName("Products"); purchase.Product = purchase.Products.EnumValues.ByDescription("Coffee"); purchase.Farmer = new Questionaire(null); Questionaire questionaire = _configuration.Questionaires[0]; Section section_o = questionaire.Sections[0]; OpenQuestion question = section_o.Questions.AddOpenQuestion(); question.QuestionText = "What's your name"; question.Name = "Name"; Dependency dependency = question.Dependencies.Add(); dependency.Target = questionaire.Sections[1]; //inspection FieldInspection inspection = _configuration.Inspections.Add(); inspection.FieldName = "Kasese 1"; var fieldSection = inspection.Sections.Add(); fieldSection.Name = "Field Section"; var qn = fieldSection.Questions.Add(QuestionTypes.Open); qn.QuestionText = "Whats your name?"; inspection.Farmer = _configuration.Questionaires[0]; inspection.Coordinates.Add("Lat:78834;Long:459"); //adding clients _configuration.Client.Contact = "0775407583"; _configuration.Client.CreatedBy = "Admin"; _configuration.Client.Email = "*****@*****.**"; _configuration.Client.Name = "Kakembo"; User user = _configuration.Client.Users.Add(UserTypes.ClientUser); user.UserName = "******"; user.Password = "******"; user.Email = "*****@*****.**"; user.Firstname = "Nanana"; user.IsAdmin = true; user.Lastname = "Nanana"; user.Usercode = "N009"; }
internal void PickValues(EnumListValue enumListValue) { _enumListValue = enumListValue; }