//---------Get Unit Details--------
public Warehousemast WareHouse_GetById(int?pid)
{
DataTable dt = null;
Warehousemast WareHouse = null;
try
{
cmd.Parameters.AddWithValue("@Pid", pid);
cmd.Parameters.AddWithValue("@Action", "SHOW");
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
WareHouse = GetList.DataTableToList <Warehousemast>(dt).FirstOrDefault();
return(WareHouse);
}
catch
{
return(WareHouse);
}
finally
{
conn.Close();
}
}
//---------Update Unit Details--------
public string WareHouse_Update(Warehousemast WareHouse)
{
string result = "";
try
{
cmd.Parameters.Add("@PID", SqlDbType.VarChar, 3).Value = WareHouse.PID;
cmd.Parameters.Add("@COMPANY_PID", SqlDbType.VarChar, 3).Value = WareHouse.COMPANY_PID;
cmd.Parameters.Add("@WAREHOUSE_NAME", SqlDbType.VarChar, 20).Value = WareHouse.WAREHOUSE_NAME;
cmd.Parameters.Add("@ADDRESS", SqlDbType.VarChar, 30).Value = WareHouse.ADDRESS;
cmd.Parameters.Add("@EDIT_BY", SqlDbType.VarChar, 10).Value = WareHouse.EDIT_BY;
cmd.Parameters.AddWithValue("@Action ", "UPDT");
conn.Open();
result = cmd.ExecuteNonQuery().ToString();
return(result);
}
catch (Exception ex)
{
return(result = "");
}
finally
{
conn.Close();
}
}
public HttpResponseMessage PutWareHouse(Warehousemast WareHouse)
{
try
{
if (ModelState.IsValid)
{
var result = new WareHouse().WareHouse_Update(WareHouse);
if (result != null || result != "")
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
