public string DeviceInsert(DeviceModel mdl) { try { db = new Hartama_IOTEntities(); string ret = ""; var res = db.InsertDevice( mdl.Device_Name, mdl.Device_category_ID, mdl.Device_Site_ID, mdl.Device_Description, mdl.UserEntry, DateTime.Now.ToShortDateString(), mdl.UserEntry, DateTime.Now.ToShortDateString(), mdl.UserEntry, mdl.MacAddress1, mdl.MacAddress2, mdl.MacAddress3 ).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); } }