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();
}
}
