public object GetImprovementList(ImprovementSearch impr)
{
dynamic ImprovementListResult;
List <object> ImprListResult = new List <object>();
DataSet Result = new DataSet();
try
{
string search = "";
if (impr.searchText == null)
{
search = "";
}
else
{
search = impr.searchText;
}
Result = Improvement.GetImprovementList(impr, search);
DataTable dt = Result.Tables[0];
DataTable dt1 = Result.Tables[1];
List <ImprovementList> res = new List <ImprovementList>();
if (dt.Rows.Count > 0)
{
res = GlobalFuns.DataTableToList <ImprovementList>(dt);
if (!string.IsNullOrEmpty(res[0].improvementImg))
{
string announ_Image = res[0].improvementImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/Improvement/Group" + impr.groupId + "/thumb/";
res[0].improvementImg = path + announ_Image;
}
}
for (int i = 0; i < res.Count; i++)
{
ImprListResult.Add(new { ImprovementList = res[i] });
}
if (res != null && res.Count != 0)
{
ImprovementListResult = new { status = "0", message = "success", smscount = dt1.Rows[0]["SMSCount"].ToString(), ImprListResult = ImprListResult };
}
else
{
ImprovementListResult = new { status = "1", message = "Record not found", smscount = dt1.Rows[0]["SMSCount"].ToString(), ImprListResult = ImprListResult };
}
}
catch
{
ImprovementListResult = new { status = "1", message = "failed", smscount = 0 };
}
return(new { TBImprovementListResult = ImprovementListResult });
}
//private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();
public static DataSet GetImprovementList(ImprovementSearch imp, string search)
{
try
{
MySqlParameter[] param = new MySqlParameter[5];
param[0] = new MySqlParameter("?memberId", imp.memberProfileId);
param[1] = new MySqlParameter("?grpId", imp.groupId);
param[2] = new MySqlParameter("?searchText", search);
param[3] = new MySqlParameter("?type", imp.type);
param[4] = new MySqlParameter("?isAdmin", imp.isAdmin);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPGetImprovementList", param);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
