public static clsPastPresidentsOutput GetPastPresidentsList(clsPastPresidentsInput inputParam)
{
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("?GroupId", inputParam.GroupId);
param[1] = new MySqlParameter("?SearchText", string.IsNullOrEmpty(inputParam.SearchText) ? "" : inputParam.SearchText.Replace(" ", "%").Trim());
param[2] = new MySqlParameter("?updateOn", inputParam.updateOn);
DataSet ds = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V1_USPGetPastPresidentsList", param);
DataTable dtNewRecords = ds.Tables[0];
DataTable dtUpdatedRecords = ds.Tables[1];
string strDeletedRecords = ds.Tables[2].Rows[0]["PastPresidentId"].ToString();
List <clsPastPresident> newRecords = new List <clsPastPresident>();
newRecords = GlobalFuns.DataTableToList <clsPastPresident>(dtNewRecords);
foreach (clsPastPresident objPP in newRecords)
{
if (!string.IsNullOrEmpty(objPP.PhotoPath))
{
objPP.PhotoPath = ConfigurationManager.AppSettings["imgPath"] + "Documents/pastpresidents/Group" + inputParam.GroupId + "/" + objPP.PhotoPath;
}
}
List <clsPastPresident> updatedRecords = new List <clsPastPresident>();
updatedRecords = GlobalFuns.DataTableToList <clsPastPresident>(dtUpdatedRecords);
foreach (clsPastPresident objPP in updatedRecords)
{
if (!string.IsNullOrEmpty(objPP.PhotoPath))
{
objPP.PhotoPath = ConfigurationManager.AppSettings["imgPath"] + "Documents/pastpresidents/Group" + inputParam.GroupId + "/" + objPP.PhotoPath;
}
}
clsPastPresidentsOutput obj = new clsPastPresidentsOutput();
obj.newRecords = newRecords;
obj.updatedRecords = updatedRecords;
obj.deletedRecords = strDeletedRecords;
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public object getPastPresidentsList(clsPastPresidentsInput inputParam)
{
dynamic TBPastPresidentListResult;
try
{
clsPastPresidentsOutput result = PastPresidents.GetPastPresidentsList(inputParam);
if (result != null)
{
TBPastPresidentListResult = new { status = "0", message = "success", updatedOn = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), TBPastPresidentList = result };
}
else
{
TBPastPresidentListResult = new { status = "0", message = "success" };
}
}
catch
{
TBPastPresidentListResult = new { status = "1", message = "failed" };
}
return(new { TBPastPresidentListResult });
}