public bool InsertDrugName(string DrugName)
{
var result = new CRUD().getItem(new AmazonDBHelper().AmazonDBConnectionString(), "drugname", DrugName, ":v_drugname", "drugname");
if (result.Count == 0)
{
int ID = 1;
//Get ID
List<ListboxHelper.CustomListItem> cli = new ListboxHelper().GetTableID();
foreach (var li in cli)
{
if (li.text == "drugname")
{
ID = li.value;
ID += 1;
}
}
List<string> columnName = new List<string>();
columnName.Add("id");
columnName.Add("drugname");
List<string> types = new List<string>();
types.Add("int");
types.Add("string");
List<string> value = new List<string>();
value.Add(ID.ToString());
value.Add(DrugName.ToLower());
new CRUD().InsertItem(new AmazonDBHelper().AmazonDBConnectionString(), "drugname", columnName, types, value);
}
return true;
}
public JsonResult CheckEmail(string Email)
{
var client = new Connection().ConnectAmazonDynamoDB(new AmazonDBHelper().AmazonDBConnectionString());
var result = new CRUD().getItem(new AmazonDBHelper().AmazonDBConnectionString(), "user", Email, ":v_email", "email");
if (result.Count >= 1)
return Json("false");
else
return Json("true");
}