static void Main_TestATPCTPConfirm()
{
String ConStrCustom;
String ConstrStd;
string WarningMsg = string.Empty;
Cls_Connection t = new Cls_Connection();
ConStrCustom = t.GetConnectionString_Custom();
ConstrStd = t.GetConnectionString_Std();
d = new ATPCTP(ConStrCustom, ConstrStd);
clsDTConfirm DTConfirm = new clsDTConfirm {
SolutionId = 3296, Quantity = 35
};
DTConfirm.AddRow();
if (d.Confirm(DTConfirm, UserID: 0, ref WarningMsg) == true)
{
Console.WriteLine($"Confirm process is success");
}
else
{
Console.WriteLine($"WarningMsg:{WarningMsg}");
}
}
public bool Confirm(clsDTConfirm DTConfirm, int UserID, ref string WarningMsg)
{
try
{
Console.WriteLine("Start Confirm ... ");
int logID;
logID = log.LogProcessInsert(clsLog.Logger.ATPCTP, clsLog.ProcessCategory.ConfirmATPCTP, "ATPCTP Confirm", DateTime.Now);
string procName = "proc_DUP_ConfirmATPCTP_4322";
DataTable DT1 = DTConfirm.DT;
using (SqlConnection con = new SqlConnection(_conStr))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = procName;
cmd.CommandTimeout = 180;
SqlParameter dtc;
dtc = cmd.Parameters.Add("@DTConfirm", SqlDbType.Structured);
dtc.Value = DT1;
dtc.TypeName = "dbo.DT_ConfirmATPCTP";
cmd.Parameters.AddWithValue("@UserID", UserID);
cmd.ExecuteNonQuery();
}
}
log.LogProcessUpdate(logID, DateTime.Now);
Console.WriteLine("End Confirm");
return(true);
}
catch (SqlException ex)
{
string errmsg = ex.Message;
string showerrmsg = string.Empty;
WarningMsg = errmsg;
try
{
log.LogAlert(clsLog.Logger.ATPCTP, clsLog.ErrorLevel.CriticalImapact, clsLog.ProcessCategory.ConfirmATPCTP, $"Unable to Confirm ATCTP {errmsg}");
if (IsRealError(errmsg, ref showerrmsg) == true)
{
WarningMsg = errmsg;
Console.WriteLine($"Error found on Confirm ATPCTP:{errmsg}");
return(false);
}
else
{
WarningMsg = showerrmsg;
return(false);
}
}
catch (Exception)
{
//nothing
throw ex;
}
}
}