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