private void AddParameters(ManUnit ManufacturingUnit) { cmd.Parameters.Add("@CompanyUnit", SqlDbType.VarChar, 10).Value = ManufacturingUnit.COMPANYUNIT; cmd.Parameters.Add("@Manufact_Name", SqlDbType.VarChar, 25).Value = ManufacturingUnit.MANF_NAME; cmd.Parameters.Add("@INPUT_BY", SqlDbType.VarChar, 3).Value = ManufacturingUnit.INPUT_BY; cmd.Parameters.Add("@EDIT_BY", SqlDbType.VarChar, 3).Value = ManufacturingUnit.EDIT_BY; }
//---------Get Manufacturing Unit-------- public ManUnit ManufacturingUnit_GetById(int?id) { DataTable dt = null; ManUnit ManufacturingUnit = null; try { conn.Open(); cmd.Parameters.AddWithValue("@Pid", id); cmd.Parameters.AddWithValue("@Action", "SHOW"); SqlDataAdapter da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); ManufacturingUnit = GetList.DataTableToList <ManUnit>(dt).FirstOrDefault(); return(ManufacturingUnit); } catch { return(ManufacturingUnit); } finally { conn.Close(); } }
public HttpResponseMessage PutManufacturingUnit(ManUnit ManufactUnit) { try { if (ModelState.IsValid) { var result = new ManufacturingUnit_CRUD().ManufacturingUnit_Update(ManufactUnit); if (result != null || result != "") { return(Request.CreateResponse(HttpStatusCode.OK, result)); } } return(Request.CreateResponse(HttpStatusCode.NoContent)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
//--------- Insert Manufacturing Unit -------- public string ManufacturingUnit_Insert(ManUnit ManufacturingUnit) { string result = string.Empty; try { conn.Open(); AddParameters(ManufacturingUnit); cmd.Parameters.AddWithValue("@Action", "INST"); result = cmd.ExecuteNonQuery().ToString(); return(result); } catch (Exception ex) { return(result); } finally { conn.Close(); } }