private void AddParameters(ItemGrp itemGrp) { cmd.Parameters.AddWithValue("GRP_CODE", itemGrp.GRP_CODE); cmd.Parameters.AddWithValue("GRP_NAME", itemGrp.GRP_NAME); cmd.Parameters.AddWithValue("GRP_PREFIX", itemGrp.GRP_PREFIX); cmd.Parameters.AddWithValue("PICT_PATH", itemGrp.PICT_PATH); }
public HttpResponseMessage PutItemGrp(ItemGrp itemGrp) { try { if (ModelState.IsValid) { var result = new ItemGrpData_Crud().ItemGrp_Update(itemGrp); if (result != null || result != "") { return(Request.CreateResponse(HttpStatusCode.OK, result)); } } return(Request.CreateResponse(HttpStatusCode.NoContent)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
//---------Insert ItemGrp Details-------- public string ItemGrp_Insert(ItemGrp itemGrp) { string result = ""; try { AddParameters(itemGrp); cmd.Parameters.AddWithValue("@Action ", "INST"); conn.Open(); result = cmd.ExecuteNonQuery().ToString(); return(result); } catch (Exception ex) { return(result = ""); } finally { conn.Close(); } }
//---------Update ItemGrp Details-------- public string ItemGrp_Update(ItemGrp itemGrp) { string result = ""; try { conn.Open(); AddParameters(itemGrp); cmd.Parameters.AddWithValue("@PID", itemGrp.PID); cmd.Parameters.AddWithValue("@Action", "UPDT"); int res = cmd.ExecuteNonQuery(); return(result); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.StackTrace); return(result = ""); } finally { conn.Close(); } }