public ActionProfileResult List(bool?activeList)
{
try
{
BSL.ActionProfileService service = new BSL.ActionProfileService();
var lists = service.List(activeList);
var sr = new ActionProfileResult
{
IsSuccess = true,
ListActionProfiles = lists,
};
return(sr);
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "List failed. " + ex.Message, ex, true);
var sr = new ActionProfileResult
{
IsSuccess = false,
ErrorMessage = "List errors. " + ex.Message
};
return(sr);
}
}
public ActionProfileResult Get(int?id)
{
if (id == null)
{
throw new ArgumentNullException("ActionProfileID");
}
try
{
using (var db = new MyDbContext())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
RmsActionProfile actionProfile = db.RmsActionProfiles.Find(id);
var sr = new ActionProfileResult
{
IsSuccess = true,
ActionProfile = actionProfile,
};
return(sr);
}
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Get failed. " + ex.Message, ex, true);
var sr = new ActionProfileResult
{
IsSuccess = false,
ErrorMessage = ex.Message
};
return(sr);
}
}
public ActionProfileResult Search(JQueryDataTableParamModel param, string txtActionProfile, string txtEmail, string txtSms)
{
List <RmsActionProfile> listRmsActionProfile = new List <RmsActionProfile>();
SqlParameter[] parameters = new SqlParameter[8];
try
{
using (var db = new MyDbContext())
{
SqlParameter p1;
SqlParameter p2;
SqlParameter p3;
if (String.IsNullOrEmpty(txtActionProfile))
{
p1 = new SqlParameter("ActionProfileName", DBNull.Value);
}
else
{
p1 = new SqlParameter("ActionProfileName", txtActionProfile);
}
if (String.IsNullOrEmpty(txtEmail))
{
p2 = new SqlParameter("Email", DBNull.Value);
}
else
{
p2 = new SqlParameter("Email", txtEmail);
}
if (String.IsNullOrEmpty(txtSms))
{
p3 = new SqlParameter("Sms", DBNull.Value);
}
else
{
p3 = new SqlParameter("Sms", txtSms);
}
SqlParameter p4 = new SqlParameter("PageNbr", DBNull.Value);
SqlParameter p5 = new SqlParameter("PageSize", param.iDisplayLength);
SqlParameter p6 = new SqlParameter("FirstRec", param.iDisplayStart);
SqlParameter p7 = new SqlParameter("SortCol", param.iSortColumn);
SqlParameter p8 = new SqlParameter("TotalRecords", SqlDbType.Int);
p8.Direction = ParameterDirection.Output;
parameters[0] = p1;
parameters[1] = p2;
parameters[2] = p3;
parameters[3] = p4;
parameters[4] = p5;
parameters[5] = p6;
parameters[6] = p7;
parameters[7] = p8;
db.Configuration.ProxyCreationEnabled = false;
//db.Configuration.LazyLoadingEnabled = false;
var listOfType = db.Database.SqlQuery <RmsActionProfile>("RMS_SearchActionProfile " +
"@ActionProfileName, @Email, @Sms, @PageNbr, @PageSize, @FirstRec, @SortCol, @TotalRecords OUTPUT"
, parameters);
listRmsActionProfile = new List <RmsActionProfile>(listOfType.ToList());
ActionProfileResult sr = new ActionProfileResult
{
IsSuccess = true,
ListActionProfiles = listRmsActionProfile,
TotalRecords = (int)parameters[7].Value
};
return(sr);
}
}
catch (Exception ex)
{
new RMSWebException(this, "0500", "Search failed. " + ex.Message, ex, true);
return(new ActionProfileResult
{
IsSuccess = false,
ErrorMessage = ex.Message
});
}
}