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;
}