public ActionResult DistributorsBudget(string EncryptedId)
{
if (!string.IsNullOrEmpty(EncryptedId))
{
string data = Security.DecodeUrlandDecrypt(EncryptedId);
string[] verificationParams = data.Split('_');
Guid GUID = new Guid(verificationParams[0]);
Int64 ProgramTypeId = Convert.ToInt64(verificationParams[1]);
DistributorsBudget dt = _distributorDao.GetDistributorsBudget(GUID, ProgramTypeId);
return(View(dt));
}
return(View());
}
public DistributorsBudget GetDistributorsBudget(Guid GUID, Int64 ProgramTypeId = 0)
{
DistributorsBudget PT = null;
using (IDbConnection conn = factory.GetConnection())
{
conn.Open();
DynamicParameters param = new DynamicParameters();
param.Add("@GUID", GUID, DbType.Guid);
param.Add("@ProgramTypeId", ProgramTypeId, DbType.Int64);
string SQL = @"[USP_GetDistributorsBudget]";
PT = conn.Query <DistributorsBudget>(SQL, param, commandType: CommandType.StoredProcedure).FirstOrDefault <DistributorsBudget>();
}
return(PT);
}
