public static string LoadRegion(string BranchID)
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySP("USER_GET_ALL", Conn, Branch);
List <GetDistrictClass> RegionList = new List <GetDistrictClass>();
RegionList.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetDistrictClass dbdc = new GetDistrictClass();
dbdc.ID = ds.Tables[0].Rows[i]["UserID"].ToString();
dbdc.Name = ds.Tables[0].Rows[i]["UserName"].ToString();
dbdc.Login = ds.Tables[0].Rows[i]["LoginID"].ToString();
dbdc.Email = ds.Tables[0].Rows[i]["email"].ToString();
dbdc.Phone = ds.Tables[0].Rows[i]["Phone"].ToString();
dbdc.Picture = ds.Tables[0].Rows[i]["Picture"].ToString();
dbdc.Manager = ds.Tables[0].Rows[i]["ManagerID"].ToString();
dbdc.UTID = ds.Tables[0].Rows[i]["UTID"].ToString();
dbdc.Branch = ds.Tables[0].Rows[i]["BranchID"].ToString();
RegionList.Insert(i, dbdc);
}
}
JavaScriptSerializer jser = new JavaScriptSerializer();
return(jser.Serialize(RegionList));
}
public static string LoadDetail(string id)
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SELECT * tbl_com", Conn);
DataTable dt = new DataTable();
da.Fill(dt);
List <GetDistrictClass> RegionList = new List <GetDistrictClass>();
RegionList.Clear();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
GetDistrictClass dbdc = new GetDistrictClass();
dbdc.ID = dt.Rows[i]["ID"].ToString();
dbdc.Name = dt.Rows[i]["Name"].ToString();
dbdc.Name = dt.Rows[i]["fname"].ToString();
dbdc.Name = dt.Rows[i]["city"].ToString();
RegionList.Insert(i, dbdc);
}
}
JavaScriptSerializer jser = new JavaScriptSerializer();
return(jser.Serialize(RegionList));
}
public static string LoadRegion(string BranchID)
//public static string LoadRegion()
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlParameter Branch = new SqlParameter("@BranchID", BranchID);
DataSet ds = AACommon.ReturnDatasetBySP("USERTYPEFORM_GET_ALL", Conn, Branch);
List <GetDistrictClass> RegionList = new List <GetDistrictClass>();
RegionList.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetDistrictClass dbdc = new GetDistrictClass();
dbdc.ID = ds.Tables[0].Rows[i]["UTFID"].ToString();
dbdc.Form = ds.Tables[0].Rows[i]["FormTitle"].ToString();
dbdc.UserType = ds.Tables[0].Rows[i]["UTDesc"].ToString();
dbdc.FormID = ds.Tables[0].Rows[i]["FormID"].ToString();
dbdc.UserTypeID = ds.Tables[0].Rows[i]["UTID"].ToString();
RegionList.Insert(i, dbdc);
}
}
JavaScriptSerializer jser = new JavaScriptSerializer();
return(jser.Serialize(RegionList));
}
public static string LoadDetailRegion()
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SELECT SUM(dbo.SP_DETAIL.QtyIn) - SUM(dbo.SP_DETAIL.QtyOut) AS CC, dbo.ITM_ITEM.ITEMName AS DesignationTitle FROM dbo.ITM_ITEM INNER JOIN dbo.SP_DETAIL ON dbo.ITM_ITEM.ITEMID = dbo.SP_DETAIL.ITEMID WHERE (dbo.ITM_ITEM.ISDELETE = 0) GROUP BY dbo.ITM_ITEM.ITEMName", Conn);
DataSet ds = new DataSet();
da.Fill(ds);
List <GetDistrictClass> RegionList = new List <GetDistrictClass>();
RegionList.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetDistrictClass dbdc = new GetDistrictClass();
dbdc.Checked = ds.Tables[0].Rows[i]["CC"].ToString();
dbdc.User = ds.Tables[0].Rows[i]["DesignationTitle"].ToString();
RegionList.Insert(i, dbdc);
}
}
JavaScriptSerializer jser = new JavaScriptSerializer();
return(jser.Serialize(RegionList));
}
public static string LoadRegion()
{
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString);
DataSet ds = AACommon.ReturnDatasetBySPWithoutParameter("FORM_GET_ALL", Conn);
List <GetDistrictClass> RegionList = new List <GetDistrictClass>();
RegionList.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
GetDistrictClass dbdc = new GetDistrictClass();
dbdc.ID = ds.Tables[0].Rows[i][0].ToString();
dbdc.Name = ds.Tables[0].Rows[i][1].ToString();
dbdc.Region = ds.Tables[0].Rows[i][2].ToString();
dbdc.Path = ds.Tables[0].Rows[i][3].ToString();
RegionList.Insert(i, dbdc);
}
}
JavaScriptSerializer jser = new JavaScriptSerializer();
return(jser.Serialize(RegionList));
}
