//---------Get VehCat Details--------
public VehiCat VehCat_GetById(int?pid)
{
DataTable dt = null;
VehiCat unit = null;
try
{
cmd.Parameters.AddWithValue("@Pid", pid);
cmd.Parameters.AddWithValue("@Action", "SELECT");
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
unit = GetList.DataTableToList <VehiCat>(dt).FirstOrDefault();
return(unit);
}
catch
{
return(unit);
}
finally
{
conn.Close();
}
}
//---------Update VehCat Details--------
public string VehCat_Update(VehiCat vehCat)
{
string result = "";
try
{
conn.Open();
cmd.Parameters.Add("@NAME", SqlDbType.VarChar, 50).Value = vehCat.NAME;
cmd.Parameters.Add("@VPREFIX", SqlDbType.VarChar, 2).Value = vehCat.VPREFIX;
cmd.Parameters.Add("@START_NO", SqlDbType.Int).Value = vehCat.START_NO;
cmd.Parameters.AddWithValue("@Pid", vehCat.PID);
cmd.Parameters.AddWithValue("@Action", "UPDATE");
int res = cmd.ExecuteNonQuery();
return(result);
}
catch (Exception ex)
{
return(result = "");
}
finally
{
conn.Close();
}
}
public HttpResponseMessage PutVehCat(VehiCat vehCat)
{
try
{
if (ModelState.IsValid)
{
var result = new VehCats().VehCat_Update(vehCat);
if (result != null || result != "")
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
}
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
//---------Insert VehCat Details--------
public string VehCat_Insert(VehiCat vehCat)
{
string result = "";
try
{
cmd.Parameters.Add("@NAME", SqlDbType.VarChar, 50).Value = vehCat.NAME;
cmd.Parameters.Add("@VPREFIX", SqlDbType.VarChar, 2).Value = vehCat.VPREFIX;
cmd.Parameters.Add("@START_NO", SqlDbType.Int).Value = vehCat.START_NO;
cmd.Parameters.AddWithValue("@Action ", "INSERT");
conn.Open();
result = cmd.ExecuteNonQuery().ToString();
return(result);
}
catch (Exception ex)
{
return(result = "");
}
finally
{
conn.Close();
}
}
