This is the connection of a PostgreSQL database to a function which get the details and create database record
public bool USERPWDHISTORYInsert(string[] connectionValues, USERPWDHISTORYDTO oSUSERPWDHISTORYDTO)
{
bool result = false;
try
{
using (DBConnector oCloudConnection = new DBConnector(connectionValues[0], Convert.ToInt32(connectionValues[1])))
{
StringBuilder varname1 = new StringBuilder();
varname1.Append("INSERT INTO SUSERPWDHISTORY n");
varname1.Append("( n");
varname1.Append("USER_ID, n");
varname1.Append("USER_PASSWORD, n");
varname1.Append("CREATED_DATETIME, n");
varname1.Append("CREATED_USER, n");
varname1.Append("CREATED_USER_CC, n");
varname1.Append("CREATED_MACHINE, n");
varname1.Append("CREATED_MACHINE_IP, n");
varname1.Append("MODIFIED_DATETIME, n");
varname1.Append("MODIFIED_USER, n");
varname1.Append("MODIFIED_USER_CC, n");
varname1.Append("MODIFIED_MACHINE, n");
varname1.Append("MODIFIED_MACHINE_IP n");
varname1.Append(") n");
varname1.Append("VALUES n");
varname1.Append("( n");
varname1.Append(":USER_ID, n");
varname1.Append(":USER_PASSWORD, n");
varname1.Append(":CREATED_DATETIME, n");
varname1.Append(":CREATED_USER, n");
varname1.Append(":CREATED_USER_CC, n");
varname1.Append(":CREATED_MACHINE, n");
varname1.Append(":CREATED_MACHINE_IP, n");
varname1.Append(":MODIFIED_DATETIME, n");
varname1.Append(":MODIFIED_USER, n");
varname1.Append(":MODIFIED_USER_CC, n");
varname1.Append(":MODIFIED_MACHINE, n");
varname1.Append(":MODIFIED_MACHINE_IP n");
varname1.Append(")");
oCloudConnection.CommandText = varname1.ToString();
oCloudConnection.Parameters.Clear();
oCloudConnection.Parameters.Add(new Parameter { Name = "USER_ID", Value = oSUSERPWDHISTORYDTO.USER_ID });
oCloudConnection.Parameters.Add(new Parameter { Name = "USER_PASSWORD", Value = oSUSERPWDHISTORYDTO.USER_PASSWORD ?? (object)DBNull.Value });
oCloudConnection.Parameters.Add(new Parameter { Name = "CREATED_DATETIME", Value = oSUSERPWDHISTORYDTO.CREATED_DATETIME });
oCloudConnection.Parameters.Add(new Parameter { Name = "CREATED_USER", Value = oSUSERPWDHISTORYDTO.CREATED_USER });
oCloudConnection.Parameters.Add(new Parameter { Name = "CREATED_USER_CC", Value = oSUSERPWDHISTORYDTO.CREATED_USER_CC });
oCloudConnection.Parameters.Add(new Parameter { Name = "CREATED_MACHINE", Value = oSUSERPWDHISTORYDTO.CREATED_MACHINE });
oCloudConnection.Parameters.Add(new Parameter { Name = "CREATED_MACHINE_IP", Value = oSUSERPWDHISTORYDTO.CREATED_MACHINE_IP });
oCloudConnection.Parameters.Add(new Parameter { Name = "MODIFIED_DATETIME", Value = oSUSERPWDHISTORYDTO.MODIFIED_DATETIME });
oCloudConnection.Parameters.Add(new Parameter { Name = "MODIFIED_USER", Value = oSUSERPWDHISTORYDTO.MODIFIED_USER });
oCloudConnection.Parameters.Add(new Parameter { Name = "MODIFIED_USER_CC", Value = oSUSERPWDHISTORYDTO.MODIFIED_USER_CC });
oCloudConnection.Parameters.Add(new Parameter { Name = "MODIFIED_MACHINE", Value = oSUSERPWDHISTORYDTO.MODIFIED_MACHINE });
oCloudConnection.Parameters.Add(new Parameter { Name = "MODIFIED_MACHINE_IP", Value = oSUSERPWDHISTORYDTO.MODIFIED_MACHINE_IP });
if (oCloudConnection.ExecuteQuery() > 0)
{
result = true;
}
}
return result;
}
catch (Exception ex)
{
DMSLogger.Write(ex);
return false;
}
}
I wanted to know if this code is correct because when I insert data from the application this dose not work and shows the error and other functions are correct this is the only thing I suspect to be wrong