public string CategoryInsertorupdate(CategoryModel mdl) { try { db = new Hartama_IOTEntities(); string ret = ""; var res = db.InsertCategory( mdl.CategoryID, mdl.CategoryName, mdl.CategoryDescription, mdl.UserEntry ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { //var retSplit = res.Pesan.Split('|'); //ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSite, retSplit[1]); ret = res.Pesan; } else { ret = res.Pesan; } return(ret); } catch (Exception err) { string ErrMsg = ""; if (err.GetType().Name == "EntityCommandExecutionException") { var SqlErr = err.InnerException as SqlException; if (SqlErr.Number == 52627) { var ErrSplit = SqlErr.Message.Split('|'); ErrMsg = TranslateMessageClass.TranslateMessage(ErrSplit[0], Resources.Resource.LabelSite, ErrSplit[1]); } } else { ErrMsg = err.InnerException.Message; } return(ErrMsg); } }