public ActionResult GetCompanys()
{
DataSet ds_Company = new DataSet();
ItemsBAL objBAL = new ItemsBAL();
//ds_Company = objBAL.GetItems();
string jsonData = "";
try
{
ds_Company = objBAL.GetCompany();
if (ds_Company.Tables[0].Rows.Count > 0)
{
JsonSerializerSettings serializerSettings = new JsonSerializerSettings();
serializerSettings.Converters.Add(new DataTableConverter());
jsonData = JsonConvert.SerializeObject(ds_Company, Formatting.None, serializerSettings);
}
else
{
jsonData = "";
}
}
catch (Exception ex)
{
jsonData = "Fail";
}
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
//public ActionResult GetItems()
//{
// DataSet ds_Items = new DataSet();
// ItemsBAL objBAL = new ItemsBAL();
// ds_Items = objBAL.GetItems();
// string jsonData = "";
// try
// {
// ds_Items = objBAL.GetItems();
// if (ds_Items.Tables[0].Rows.Count > 0)
// {
// JsonSerializerSettings serializerSettings = new JsonSerializerSettings();
// serializerSettings.Converters.Add(new DataTableConverter());
// jsonData = JsonConvert.SerializeObject(ds_Items, Formatting.None, serializerSettings);
// }
// else
// {
// jsonData = "";
// }
// }
// catch (Exception ex)
// {
// jsonData = "Fail";
// }
// return Json(jsonData, JsonRequestBehavior.AllowGet);
//}
public void GetItemstest()
{
DataSet ds_Items = new DataSet();
ItemsBAL objBAL = new ItemsBAL();
List <Items> ItemLst = new List <Items>();
ds_Items = objBAL.GetItems();
if (ds_Items.Tables[0].Rows.Count > 0)
{
Items items = new Items();
for (int i = 0; i < ds_Items.Tables[0].Rows.Count; i++)
{
items.Name = ds_Items.Tables[0].Rows[i]["Name"].ToString();
items.HSNCode = ds_Items.Tables[0].Rows[i]["HSNCode"].ToString();
items.compname = ds_Items.Tables[0].Rows[i]["compname"].ToString();
items.pack = ds_Items.Tables[0].Rows[i]["pack"].ToString();
items.clqty = ds_Items.Tables[0].Rows[i]["clqty"].ToString();
}
ItemLst.Add(items);
}
}
