//---------Update Unit Details-------- public string Unit_Update(UnitMast unit) { string result = ""; try { conn.Open(); cmd.Parameters.Add("@UNIT", SqlDbType.VarChar, 3).Value = unit.UNIT; cmd.Parameters.Add("@DESC", SqlDbType.VarChar, 20).Value = unit.DESC; cmd.Parameters.Add("@DECI_REQ", SqlDbType.Bit).Value = unit.DECI_REQ; cmd.Parameters.AddWithValue("@Pid", unit.PID); cmd.Parameters.AddWithValue("@Action", "UPDT"); result = cmd.ExecuteNonQuery().ToString(); return(result); } catch (Exception ex) { return(result = ""); } finally { conn.Close(); } }
//---------Get Unit Details-------- public UnitMast Unit_GetById(int?pid) { DataTable dt = null; UnitMast unit = 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); unit = GetList.DataTableToList <UnitMast>(dt).FirstOrDefault(); return(unit); } catch { return(unit); } finally { conn.Close(); } }
//---------Insert Unit Details-------- public string Unit_Insert(UnitMast unit) { string result = ""; try { cmd.Parameters.Add("@UNIT", SqlDbType.VarChar, 3).Value = unit.UNIT; cmd.Parameters.Add("@DESC", SqlDbType.VarChar, 20).Value = unit.DESC; cmd.Parameters.Add("@DECI_REQ", SqlDbType.Bit).Value = unit.DECI_REQ; cmd.Parameters.AddWithValue("@Action ", "INST"); conn.Open(); result = cmd.ExecuteNonQuery().ToString(); return(result); } catch (SqlException sqlException) { if (sqlException.Number == 2601 || sqlException.Number == 2627) { result = "Code is duplicate."; } return(result); } finally { conn.Close(); } }
public HttpResponseMessage PutUnit(UnitMast unit) { try { if (ModelState.IsValid) { var result = new UnitMaster().Unit_Update(unit); if (result != null || result != "") { return(Request.CreateResponse(HttpStatusCode.OK, result)); } } return(Request.CreateResponse(HttpStatusCode.NoContent)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }