public string createoreditsensorparamdetail(string idsensor, string idcategory, decimal lower, decimal upper, string user) { try { db = new Hartama_IOTEntities(); string ret = ""; var res = db.CreateorEditSensor( idsensor, idcategory, lower, upper, user ).FirstOrDefault(); if (res.Error == 0 || res.Error == null) { //var retSplit = res.Pesan.Split('|'); //ret = TranslateMessageClass.TranslateMessage(retSplit[0], Resources.Resource.LabelSite, retSplit[1]); ret = "1"; } 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); } }