private MENURes insert(MENUREq dataReq, string conStr = null) { var res = new MENURes(); try { var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); if (lst == null || (lst != null && lst.Count == 0)) { var req = new STMENU() { MENUCODE = dataReq.MENUCODE, MENUNAME = dataReq.MENUNAME, INPID = dataReq.INPID, }; var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Insert(req, null, conStr); res._result._code = "200"; res._result._message = "บันทึกข้อมูลเรียบร้อยแล้ว"; res._result._status = "OK"; } else { var obj = lst.FirstOrDefault(); if (obj.FLAG.Equals("2")) { throw new Exception("รหัสหน้าจอนี้มีอยู่แล้ว แต่ถูกปิดการใช้งาน"); } else { throw new Exception("รหัสหน้าจอซ้ำ"); } } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } finally { var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = null }, null, conStr); res.MENULST = newList; } return(res); }
private MENURes active(MENUREq dataReq, int flag, string conStr = null) { var res = new MENURes(); try { var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); if (lst != null && lst.Count > 0) { var obj = lst.FirstOrDefault(); var req = new STMENU() { MENUCODE = obj.MENUCODE, MENUNAME = obj.MENUNAME, FLAG = flag.ToString(), INPID = dataReq.INPID, }; var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Update(req, null, conStr); res._result._code = "200"; res._result._message = "บันทึกข้อมูลเรียบร้อยแล้ว"; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Not Found"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } finally { var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); res.MENULST = newList; } return(res); }
private MENURes delete(MENUREq dataReq, string conStr = null) { var res = new MENURes(); try { var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Get(new STPERMISSIONS() { MENUCODE = dataReq.MENUCODE }, null, conStr); if (lst == null || (lst != null && lst.Count == 0)) { var req = new STMENU() { MENUCODE = dataReq.MENUCODE, MENUNAME = dataReq.MENUNAME, FLAG = dataReq.FLAG, INPID = dataReq.INPID, }; var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Delete(req, null, conStr); res._result._code = "200"; res._result._message = "ลบข้อมูลเรียบร้อยแล้ว"; res._result._status = "OK"; } else { throw new Exception("ไม่สามารถลบข้อมูลได้ เนื่องจากหน้าจอนี้ถูกกำหนดสิทธิ์การใช้งานแล้ว"); } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } finally { var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); res.MENULST = newList; } return(res); }
private MENURes getMenu(MENUREq dataReq, string conStr = null) { var res = new MENURes(); try { var req = new STMENU() { MENUCODE = dataReq.MENUCODE, MENUNAME = dataReq.MENUNAME, FLAG = dataReq.FLAG, INPID = dataReq.INPID, }; var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().ListActive(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); res.MENULST = lst; if (lst != null && lst.Count > 0) { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Not Found"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private MENURes check(MENUREq dataReq, string conStr = null) { var res = new MENURes(); try { var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU() { MENUCODE = dataReq.MENUCODE }, null, conStr); if (lst == null || (lst != null && lst.Count == 0)) { res._result._code = "200"; res._result._message = "ข้อมูลพร้อมใช้งาน"; res._result._status = "OK"; } else { var obj = lst.FirstOrDefault(); if (obj.FLAG.Equals("2")) { throw new Exception("รหัสหน้าจอนี้มีอยู่แล้ว แต่ถูกปิดการใช้งาน"); } else { throw new Exception("รหัสหน้าจอซ้ำ"); } } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
protected override void ExecuteChild(MENUREq dataReq, ResponseAPI dataRes) { DBMode = dataReq.DBMode; var res = new MENURes(); res._result.ServerAddr = ConnectionString(); res._result.DBMode = DBMode; try { switch (dataReq.MODE.Trim().ToLower()) { case "insert": res = insert(dataReq, conString); break; case "update": res = update(dataReq, conString); break; case "delete": res = delete(dataReq, conString); break; case "search": res = search(dataReq, conString); break; case "check": res = check(dataReq, conString); break; case "active": res = active(dataReq, 1, conString); break; case "inactive": res = active(dataReq, 2, conString); break; default: res = getMenu(dataReq, conString); break; } } catch (SqlException ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Execute exception Error"; } catch (InvalidOperationException ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Connection Exception Error"; } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } dataRes.data = res; }