public JsonResult Delete(int id = 0)
{
UserInfoModel userInfo = (UserInfoModel)GeneralFunctions.GetSession(Configs.session);
MGroupUserModel item = new MGroupUserModel();
item.GroupUserID = id;
item.UserCreated = userInfo.UserName;
item.UserModified = userInfo.UserName;
ResultStatusModel result = new ResultStatusModel();
ModelState.Clear();
try
{
string id_out = "";
result = uow.GroupUserRepository.CUD_GroupUser(item, "d", out id_out);
if (!result.issuccess)
{
ModelState.AddModelError("Failed", result.msg);
}
}
catch (Exception e)
{
ModelState.AddModelError("Failed", e.Message);
}
List <string> Error = (from m in ModelState
where m.Value.Errors.Any()
select m.Value.Errors[0].ErrorMessage).ToList();
return(Json(new { Error = Error, data = id }, JsonRequestBehavior.DenyGet));
}
public ResultStatusModel CUD_MBarang(MGroupUserModel item, string mode, out string ID)
{
SqlParameter id_out = new SqlParameter("id_out", 0)
{
Direction = ParameterDirection.Output
};
SqlParameter[] sqlParams =
{
new SqlParameter("BarangID", SqlDbType.Int)
{
Value = item.GroupUserID
},
new SqlParameter("NamaBarang", string.IsNullOrEmpty(item.GroupCode) ? (object)DBNull.Value : item.GroupCode),
new SqlParameter("JenisBarang", string.IsNullOrEmpty(item.GroupCode) ? (object)DBNull.Value : item.GroupCode),
new SqlParameter("UserCreated", string.IsNullOrEmpty(item.UserCreated) ? (object)DBNull.Value : item.UserCreated),
new SqlParameter("UserModified", string.IsNullOrEmpty(item.UserModified) ? (object)DBNull.Value : item.UserModified),
new SqlParameter("Mode", string.IsNullOrEmpty(mode) ? (object)DBNull.Value : mode),
id_out
};
List <ResultStatusModel> result =
Db.Database.SqlQuery <ResultStatusModel>(
@"exec sp_CUD_MBarang
@BarangID, @NamaBarang, @JenisBarang, @UserCreated
, @UserModified, @Mode, @id_out output"
, sqlParams).ToList();
ID = id_out.Value.ToString();
return(result.FirstOrDefault());
}
public ActionResult Manage(int id = 0)
{
MGroupUserModel data = new MGroupUserModel();
if (id != 0)
{
data = uow.GroupUserRepository.LookUp_MGroupUser(id, null, null).FirstOrDefault();
if (data == null)
{
data = new MGroupUserModel();
data.GroupUserID = -1;
}
}
return(View(data));
}
