public IHttpActionResult SaveSystemData(dynamic data)
{
try
{
string value = token_gen.Authorize_aesdecrpty(data);
AssetTracking rootobj = JsonConvert.DeserializeObject <AssetTracking>(value);
//var validresult.Status = "Success";//_valid.CheckSaveAssetTracking(rootobj);
//if (validresult.Status == "Success")
//{
return(Ok(heahel.SaveSystemData(rootobj)));
//}
//else
//{
// CatchData.Status = "Failure";
// CatchData.Reason = validresult.Reason;
// return Ok(CatchData);
//}
}
catch (Exception ex)
{
CatchData.Status = "Failure";
CatchData.Reason = ServicesHelper.ThirdpartyMessage;
return(Ok(CatchData));
}
}
//Save Data
public dynamic SaveSystemData(AssetTracking root)
{
dynamic obj = new ExpandoObject();
try
{
string res = SaveSystemDataSpHelper(root);
if (res == "Success")
{
obj.Status = "Success";
obj.Reason = "Data Inserted Successfully.";
}
else
{
obj.Status = "Failure";
obj.Reason = "No Data Found";
}
}
catch (Exception ex)
{
obj.Status = "Failure";
obj.Reason = GetException(ex.Message);
}
return(obj);
}
//Save Data
public dynamic SaveSystemDataSpHelper(AssetTracking obj)
{
try
{
int k = 0;
foreach (insarray array in obj.DATAARRAY)
{
var comd = new OracleCommand();
comd.CommandText = @"insert into gsws_assets_masters (DISTRICT,MANDAL,SECRATARIAT,CPUSERIALNO,CPUCONN,CPUWORKING,CPUCONREMARKS,CPUWORREMARKS,MONITORSERIALNO,MONITORCONN,MONITORWORKING,MONITORCONREMARKS,MONITORWORREMARKS,KEYBOARDSERIALNO,KEYBOARDCONN,KEYBOARDWORKING,KEYBOARDCONREMARKS,KEYBOARDWORREMARKS,MOUSESERIALNO,MOUSECONN,MOUSEWORKING,MOUSECONREMARKS,MOUSEWORREMARKS,INVERTORSERIALNO,INVERTORCONN,INVERTORWORKING,INVERTORCONREMARKS,INVERTORWORREMARKS,BATTERIESSERIALNO,BATTERIESCONN,BATTERIESWORKING,BATTERIESCONREMARKS,BATTERIESWORREMARKS,MACADDRESS,MODELNO,BATCHNO,SYS_NO,UPDATED_BY,PRINTERSERIALNO,PRINTERCONN,PRINTERWORKING,PRINTERCONREMARKS,PRINTERWORREMARKS,LAMINATORSERIALNO,LAMINATORCONN,LAMINATORWORKING,LAMINATORCONREMARKS,LAMINATORWORREMARKS,BIOMETRICSERIALNO,BIOMETRICCONN,BIOMETRICWORKING,BIOMETRICCONREMARKS,BIOMETRICWORREMARKS)
values(:DISTRICT,:MANDAL,:SECRATARIAT,:CPUSERIALNO,:CPUCONN,:CPUWORKING,:CPUCONREMARKS,:CPUWORREMARKS,:MONITORSERIALNO,:MONITORCONN,:MONITORWORKING,:MONITORCONREMARKS,:MONITORWORREMARKS,:KEYBOARDSERIALNO,:KEYBOARDCONN,:KEYBOARDWORKING,:KEYBOARDCONREMARKS,:KEYBOARDWORREMARKS,:MOUSESERIALNO,:MOUSECONN,:MOUSEWORKING,:MOUSECONREMARKS,:MOUSEWORREMARKS,:INVERTORSERIALNO,:INVERTORCONN,:INVERTORWORKING,:INVERTORCONREMARKS,:INVERTORWORREMARKS,:BATTERIESSERIALNO,:BATTERIESCONN,:BATTERIESWORKING,:BATTERIESCONREMARKS,:BATTERIESWORREMARKS,:MACADDRESS,:MODELNO,:BATCHNO,:SYS_NO,:UPDATED_BY,:PRINTERSERIALNO,:PRINTERCONN,:PRINTERWORKING,:PRINTERCONREMARKS,:PRINTERWORREMARKS,:LAMINATORSERIALNO,:LAMINATORCONN,:LAMINATORWORKING,:LAMINATORCONREMARKS,:LAMINATORWORREMARKS,:BIOMETRICSERIALNO,:BIOMETRICCONN,:BIOMETRICWORKING,:BIOMETRICCONREMARKS,:BIOMETRICWORREMARKS)" ;
comd.Parameters.Add(":DISTRICT", OracleDbType.Varchar2, 20).Value = array.DISTRICT;
comd.Parameters.Add(":MANDAL", OracleDbType.Varchar2, 20).Value = array.MANDAL;
comd.Parameters.Add(":SECRATARIAT", OracleDbType.Varchar2, 20).Value = array.SECRATARIAT;
comd.Parameters.Add(":CPUSERIALNO", OracleDbType.Varchar2, 50).Value = array.CPUSERIALNO;
comd.Parameters.Add(":CPUCONN", OracleDbType.Varchar2, 20).Value = array.CPUCONN;
comd.Parameters.Add(":CPUWORKING", OracleDbType.Varchar2, 20).Value = array.CPUWORKING;
comd.Parameters.Add(":CPUCONREMARKS", OracleDbType.Varchar2, 200).Value = array.CPUCONREMARKS;
comd.Parameters.Add(":CPUWORREMARKS", OracleDbType.Varchar2, 200).Value = array.CPUWORREMARKS;
comd.Parameters.Add(":MONITORSERIALNO", OracleDbType.Varchar2, 20).Value = array.MONITORSERIALNO;
comd.Parameters.Add(":MONITORCONN", OracleDbType.Varchar2, 20).Value = array.MONITORCONN;
comd.Parameters.Add(":MONITORWORKING", OracleDbType.Varchar2, 20).Value = array.MONITORWORKING;
comd.Parameters.Add(":MONITORCONREMARKS", OracleDbType.Varchar2, 200).Value = array.MONITORCONREMARKS;
comd.Parameters.Add(":MONITORWORREMARKS", OracleDbType.Varchar2, 200).Value = array.MONITORWORREMARKS;
comd.Parameters.Add(":KEYBOARDSERIALNO", OracleDbType.Varchar2, 20).Value = array.KEYBOARDSERIALNO;
comd.Parameters.Add(":KEYBOARDCONN", OracleDbType.Varchar2, 20).Value = array.KEYBOARDCONN;
comd.Parameters.Add(":KEYBOARDWORKING", OracleDbType.Varchar2, 20).Value = array.KEYBOARDWORKING;
comd.Parameters.Add(":KEYBOARDCONREMARKS", OracleDbType.Varchar2, 200).Value = array.KEYBOARDCONREMARKS;
comd.Parameters.Add(":KEYBOARDWORREMARKS", OracleDbType.Varchar2, 200).Value = array.KEYBOARDWORREMARKS;
comd.Parameters.Add(":MOUSESERIALNO", OracleDbType.Varchar2, 20).Value = array.MOUSESERIALNO;
comd.Parameters.Add(":MOUSECONN", OracleDbType.Varchar2, 20).Value = array.MOUSECONN;
comd.Parameters.Add(":MOUSEWORKING", OracleDbType.Varchar2, 20).Value = array.MOUSEWORKING;
comd.Parameters.Add(":MOUSECONREMARKS", OracleDbType.Varchar2, 200).Value = array.MOUSECONREMARKS;
comd.Parameters.Add(":MOUSEWORREMARKS", OracleDbType.Varchar2, 200).Value = array.MOUSEWORREMARKS;
comd.Parameters.Add(":INVERTORSERIALNO", OracleDbType.Varchar2, 20).Value = array.INVERTORSERIALNO;
comd.Parameters.Add(":INVERTORCONN", OracleDbType.Varchar2, 20).Value = array.INVERTORCONN;
comd.Parameters.Add(":INVERTORWORKING", OracleDbType.Varchar2, 20).Value = array.INVERTORWORKING;
comd.Parameters.Add(":INVERTORCONREMARKS", OracleDbType.Varchar2, 200).Value = array.INVERTORCONREMARKS;
comd.Parameters.Add(":INVERTORWORREMARKS", OracleDbType.Varchar2, 200).Value = array.INVERTORWORREMARKS;
comd.Parameters.Add(":BATTERIESSERIALNO", OracleDbType.Varchar2, 20).Value = array.BATTERIESSERIALNO;
comd.Parameters.Add(":BATTERIESCONN", OracleDbType.Varchar2, 20).Value = array.BATTERIESCONN;
comd.Parameters.Add(":BATTERIESWORKING", OracleDbType.Varchar2, 20).Value = array.BATTERIESWORKING;
comd.Parameters.Add(":BATTERIESCONREMARKS", OracleDbType.Varchar2, 200).Value = array.BATTERIESCONREMARKS;
comd.Parameters.Add(":BATTERIESWORREMARKS", OracleDbType.Varchar2, 200).Value = array.BATTERIESWORREMARKS;
comd.Parameters.Add(":MACADDRESS", OracleDbType.Varchar2, 100).Value = array.MACADDRESS;
comd.Parameters.Add(":MODELNO", OracleDbType.Varchar2, 50).Value = array.MODELNO;
comd.Parameters.Add(":BATCHNO", OracleDbType.Varchar2, 20).Value = array.BATCHNO;
comd.Parameters.Add(":SYS_NO", OracleDbType.Varchar2, 50).Value = array.SYSNO;
comd.Parameters.Add(":UPDATED_BY", OracleDbType.Varchar2, 50).Value = array.USERNAME;
comd.Parameters.Add(":PRINTERSERIALNO", OracleDbType.Varchar2, 20).Value = array.PRINTERSERIALNO;
comd.Parameters.Add(":PRINTERCONN", OracleDbType.Varchar2, 20).Value = array.PRINTERCONN;
comd.Parameters.Add(":PRINTERWORKING", OracleDbType.Varchar2, 20).Value = array.PRINTERWORKING;
comd.Parameters.Add(":PRINTERCONREMARKS", OracleDbType.Varchar2, 200).Value = array.PRINTERCONREMARKS;
comd.Parameters.Add(":PRINTERWORREMARKS", OracleDbType.Varchar2, 200).Value = array.PRINTERWORREMARKS;
comd.Parameters.Add(":LAMINATORSERIALNO", OracleDbType.Varchar2, 20).Value = array.LAMINATORSERIALNO;
comd.Parameters.Add(":LAMINATORCONN", OracleDbType.Varchar2, 20).Value = array.LAMINATORCONN;
comd.Parameters.Add(":LAMINATORWORKING", OracleDbType.Varchar2, 20).Value = array.LAMINATORWORKING;
comd.Parameters.Add(":LAMINATORCONREMARKS", OracleDbType.Varchar2, 200).Value = array.LAMINATORCONREMARKS;
comd.Parameters.Add(":LAMINATORWORREMARKS", OracleDbType.Varchar2, 200).Value = array.LAMINATORWORREMARKS;
comd.Parameters.Add(":BIOMETRICSERIALNO", OracleDbType.Varchar2, 20).Value = array.BIOMETRICSERIALNO;
comd.Parameters.Add(":BIOMETRICCONN", OracleDbType.Varchar2, 20).Value = array.BIOMETRICCONN;
comd.Parameters.Add(":BIOMETRICWORKING", OracleDbType.Varchar2, 20).Value = array.BIOMETRICWORKING;
comd.Parameters.Add(":BIOMETRICCONREMARKS", OracleDbType.Varchar2, 200).Value = array.BIOMETRICCONREMARKS;
comd.Parameters.Add(":BIOMETRICWORREMARKS", OracleDbType.Varchar2, 200).Value = array.BIOMETRICWORREMARKS;
k = getgswsExecuteNonQuery(comd);
}
if (k > 0)
{
return("Success");
}
else
{
return("Failure");
}
}
catch (WebException wex)
{
string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Save Index Page data :" + wex.Message.ToString()));
throw new Exception(wex.Message);
}
}
