public IHttpActionResult Save(paramvalues_vm Record)
{
try
{
using (SysParamService obj = new SysParamService())
return(Ok(obj.Save(Record)));
}
catch (Exception Ex)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, Ex.Message.ToString())));
}
}
public Dictionary <string, object> Save(paramvalues_vm Record)
{
Dictionary <string, object> RetData = new Dictionary <string, object>();
try
{
Con_Oracle = new DBConnection();
DBRecord Rec = new DBRecord();
Con_Oracle.BeginTransaction();
sql = "delete from paramvalues where parent_id ='" + Record.param_pkid + "'";
Con_Oracle.ExecuteNonQuery(sql);
foreach (paramvalues _Record in Record.RecordDet)
{
if (_Record.param_value.ToString().Length > 0)
{
_Record.param_pkid = System.Guid.NewGuid().ToString().ToUpper();
Rec.CreateRow("paramvalues", "ADD", "param_pkid", _Record.param_pkid);
Rec.InsertString("parent_id", Record.param_pkid);
Rec.InsertString("param_key", _Record.param_key);
Rec.InsertString("param_value", _Record.param_value, "P");
Rec.InsertString("param_filetype", _Record.param_filetype);
Rec.InsertString("param_impexp", _Record.param_impexp);
Rec.InsertString("param_edifile", _Record.param_edifile);
Rec.InsertString("param_format", _Record.param_format);
Rec.InsertString("rec_company_code", Record._globalvariables.comp_code);
sql = Rec.UpdateRow();
Con_Oracle.ExecuteNonQuery(sql);
}
}
Con_Oracle.CommitTransaction();
Con_Oracle.CloseConnection();
}
catch (Exception Ex)
{
if (Con_Oracle != null)
{
Con_Oracle.RollbackTransaction();
Con_Oracle.CloseConnection();
}
throw Ex;
}
Con_Oracle.CloseConnection();
return(RetData);
}