public JsonResult DepartmentDropDownFill()
{
try
{
int statusCode = 1;
BlPopulate blpopulate = new BlPopulate();
blpopulate.TableName = "Department";
blpopulate.ListFields = "DepName";
blpopulate.ValueFields = "ID_Department";
blpopulate.SortFields = "DepName,ID_Department";
blpopulate.Criteria = "Cancelled=0 AND Active=1 AND FK_Company= " + Session["ID_Company"].ToString();
DataTable dt = new DataTable();
dt = blpopulate.PopulateData();
return(Json(Converttojson(dt), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
public JsonResult ProductDropDownFill()
{
try
{
int statusCode = 1;
BlPopulate blpopulate = new BlPopulate();
blpopulate.TableName = "Product P LEFT JOIN ClientDetails CD ON CD.FK_Product=P.ID_Product LEFT JOIN Client C ON C.ID_Client=CD.FK_Client LEFT JOIN Users U ON U.FK_Client=C.ID_Client";
blpopulate.ListFields = "P.ProdName";
blpopulate.ValueFields = "P.ID_Product";
blpopulate.SortFields = "P.ProdName,P.ID_Product";
blpopulate.Criteria = "U.Cancelled=0 AND P.Cancelled=0 AND CD.Cancelled=0 AND P.Active=1 AND C.Cancelled=0 AND U.ID_Users=" + Session["ID_Users"].ToString() + " AND U.FK_Company=" + Session["ID_Company"].ToString();
DataTable dt = new DataTable();
dt = blpopulate.PopulateData();
return(Json(Converttojson(dt), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
