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