public MyTaskCountDBModel Get(string userid)
{
userid = Cipher.Decrypt(userid);
MyTaskCountDBModel myTaskList = _dbTna.GetTaskCount(userid);
return(myTaskList);
}
public async Task <MyTaskCountDBModel> GetTaskCount(string userid)
{
userid = Cipher.Encrypt(userid);
string url = RepositorySettings.BaseURl + "TNA?userid=" + userid;
HttpClient client = new HttpClient();
HttpResponseMessage result = await client.GetAsync(url);
var aproves = JsonConvert.DeserializeObject <MyTaskCountDBModel>(result.Content.ReadAsStringAsync().Result);
if (aproves == null)
{
aproves = new MyTaskCountDBModel();
}
return(aproves);
}
protected async override void OnStart()
{
base.OnStart();
TNARepository repo = new TNARepository();
MyTaskCountDBModel mytaskList = null;
mytaskList = await repo.GetTaskCount(bitopiApplication.User.UserCode);
if (mytaskList != null)
{
if (mytaskList.TotalUnSeenTask != "0")
{
numberUnseen.Text = mytaskList.TotalUnSeenTask;
numberUnseen.Visibility = ViewStates.Visible;
}
else
{
numberUnseen.Visibility = ViewStates.Gone;
}
if (mytaskList.TotalSeenTask != "0")
{
numberSeen.Text = mytaskList.TotalSeenTask;
numberSeen.Visibility = ViewStates.Visible;
}
else
{
numberSeen.Visibility = ViewStates.Gone;
}
if (mytaskList.TotalCompleteTask != "0")
{
numberCompleted.Text = mytaskList.TotalCompleteTask;
numberCompleted.Visibility = ViewStates.Visible;
}
else
{
numberCompleted.Visibility = ViewStates.Gone;
}
}
}
public MyTaskCountDBModel GetTaskCount(string UserCode)
{
SqlParameter[] param = null;
param = new SqlParameter[] {
new SqlParameter("@QryOption", 6),
new SqlParameter("@DefaultAsignee", UserCode)
};
MyTaskCountDBModel _DBModel = null;
try
{
DataTable dt = ExecuteDataTable("PlanningTNA.dbo.Sp_Get_MyTask_Details", param);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
_DBModel = new MyTaskCountDBModel()
{
TotalCompleteTask = dr["TotalCompleteTask"].ToString(),
TotalSeenTask = dr["TotalSeenTask"].ToString(),
TotalUnSeenTask = dr["TotalUnSeenTask"].ToString()
};
}
}
return(_DBModel);
}
catch (Exception ex)
{
//ErrorSignal.FromCurrentContext().Raise(ex);
throw ex;
}
finally
{
_DBModel = null;
}
}
