private void AddParameters(CurrMast currMast) { cmd.Parameters.AddWithValue("CURR_CODE", currMast.CURR_CODE); cmd.Parameters.AddWithValue("CURR_NAME", currMast.CURR_NAME); cmd.Parameters.AddWithValue("CURR_CAP", currMast.CURR_CAP); cmd.Parameters.AddWithValue("CURR_CONV", currMast.CURR_CONV); cmd.Parameters.AddWithValue("EXC_RATE", currMast.EXC_RATE); cmd.Parameters.AddWithValue("COIN", currMast.COIN); cmd.Parameters.AddWithValue("CURR_SEP", currMast.CURR_SEP); }
public HttpResponseMessage PutCurrMast(CurrMast currMast) { try { if (ModelState.IsValid) { var result = new CurrMastData_Crud().CurrMast_Update(currMast); if (result != null || result != "") { return(Request.CreateResponse(HttpStatusCode.OK, result)); } } return(Request.CreateResponse(HttpStatusCode.NoContent)); } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
//---------Insert CurrMast Details-------- public string CurrMast_Insert(CurrMast currMast) { string result = ""; try { AddParameters(currMast); cmd.Parameters.AddWithValue("@Action ", "INST"); conn.Open(); result = cmd.ExecuteNonQuery().ToString(); return(result); } catch (Exception ex) { return(result = ""); } finally { conn.Close(); } }
//---------Update CurrMast Details-------- public string CurrMast_Update(CurrMast currMast) { string result = ""; try { conn.Open(); AddParameters(currMast); cmd.Parameters.AddWithValue("@PID", currMast.PID); cmd.Parameters.AddWithValue("@Action", "UPDT"); int res = cmd.ExecuteNonQuery(); return(result); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.StackTrace); return(result = ""); } finally { conn.Close(); } }