/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public ActionResult InterviewAppointments(InterviewAppointmentParameter param)
{
param.KeyWord = HttpUtility.UrlDecode(param.KeyWord);
return(View(
new InternalDataTransferToView {
List = InterviewAppointmentTableProvider.List(param),
Data = param
}));
}
public ActionResult AjaxInterviewAppointmentDelete(InterviewAppointmentParameter param)
{
var result = new JsonNetResult();
var r = new GeneralResponse();
try {
r.Code = InterviewAppointmentTableProvider.Delete(param).ToString(Section.Get.Common.Culture);
}
catch (Exception ex) {
Log.Error(ex.Message, ex);
r.Code = "-11";
}
result.Data = r;
return(result);
}
public static int Delete(InterviewAppointmentParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.Write(
CommandType.Text,
"DELETE FROM [dbo].[InterviewAppointment] WHERE [InterviewAppointmentId] = @InterviewAppointmentId;",
new DbParameter[] {
new SqlParameter {
Value = param.Entity.InterviewAppointmentId,
SqlDbType = SqlDbType.Int,
ParameterName = "@InterviewAppointmentId",
Direction = ParameterDirection.Input
}
}));
}
}
public static DataSet List(InterviewAppointmentParameter param)
{
using (var db = new MsSql(DbName.Official)) {
return(db.DataSet(
CommandType.StoredProcedure,
"[dbo].[sp_FetchInterviewAppointmentList_Sel]",
new DbParameter[] {
new SqlParameter {
Value = param.KeyWord,
SqlDbType = SqlDbType.NVarChar,
ParameterName = "@argStrKeyWord",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = string.IsNullOrEmpty(param.StartUtcDateTime) ? null : param.StartUtcDateTime,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@argDteStart",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = string.IsNullOrEmpty(param.EndUtcDateTime) ? null : param.EndUtcDateTime,
SqlDbType = SqlDbType.DateTime,
ParameterName = "@argDteEnd",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.Page,
SqlDbType = SqlDbType.Int,
ParameterName = "@argIntPage",
Direction = ParameterDirection.Input
},
new SqlParameter {
Value = param.PageSize,
SqlDbType = SqlDbType.Int,
ParameterName = "@argIntPageSize",
Direction = ParameterDirection.Input
}
}));
}
}