private void HandleDelete(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, DataRow row)
{
string strMsg = "";
using (TransactionScope dbTxn = new TransactionScope())
{
CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
if (!DAL_CLIENT_CERTIFICATE.IsAlreadyUpdated(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified
{
//delete the record
DAL_CLIENT_CERTIFICATE.Delete(oCLIENT_CERTIFICATE, out strMsg);
}
else
{
//already use in another process
ResponseUtility.ReturnFailMessage(row);
return;
}
//return message and MK value
if (String.IsNullOrEmpty(strMsg)) //success
{
response.Status = 1;
dbTxn.Complete();
ResponseUtility.ReturnDeleteSuccessMessage(row);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
}
private void HandleModify(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, string OPERATION, DataRow row)
{
string strMsg = "";
using (TransactionScope dbTxn = new TransactionScope())
{
CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
//check condition
if (!DAL_CLIENT_CERTIFICATE.IsAlreadyUpdated(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified
{
//MODIFY the record
DAL_CLIENT_CERTIFICATE.Update(oCLIENT_CERTIFICATE, CURRENT_DATETIME, CURRENT_USER, out strMsg);
}
else
{
//already use in another process
ResponseUtility.ReturnFailMessage(row);
return;
}
//return message and MK value
if (String.IsNullOrEmpty(strMsg)) //success
{
dbTxn.Complete();
ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
}
private void HandleInsert(BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE, string OPERATION, DataRow row)
{
string strMsg = "";
CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
using (TransactionScope dbTxn = new TransactionScope())
{
if (!DAL_CLIENT_CERTIFICATE.PKKeyCheck(oCLIENT_CERTIFICATE, out strMsg)) // IF updated_at is not already modified
{
//delete the record
DAL_CLIENT_CERTIFICATE.Insert(oCLIENT_CERTIFICATE, CURRENT_DATETIME, CURRENT_USER, out strMsg);
}
else
{
ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ028, oCLIENT_CERTIFICATE.CLIENT_CERTIFICATE_NO));
return;
}
//return message and MK value
if (String.IsNullOrEmpty(strMsg)) //success
{
dbTxn.Complete();
ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
}
public ControllerRegisterCompleteNotificationSending()
{
response = new MetaResponse();
DAL_REQUEST_ID = new REQUEST_ID(con);
DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con);
DAL_REPORT_HISTORY = new REPORT_HISTORY(con);
DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
DAL_REQ_ADDRESS = new REQ_ADDRESS(con);
timer = new Stopwatch();
timer.Start();
//UPDATED_AT
UPDATED_AT_DATETIME = TEMP.ToString("yyyy/MM/dd HH:mm");
CURRENT_DATETIME = TEMP.ToString("yyyyMMddHHmmss");
}
public MetaResponse getClientCertificateList(string FY, string COMPANY_NO_BOX, string CLIENT_CERTIFICATE_NO, string DISTRIBUTION_STATUS, int OFFSET, int LIMIT)
{
try
{
string strMessage = "";
int TOTAL = 0;
CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
DataTable dt = DAL_CLIENT_CERTIFICATE.GetClientCertrificateList(FY, COMPANY_NO_BOX, CLIENT_CERTIFICATE_NO, DISTRIBUTION_STATUS, OFFSET, LIMIT, out strMessage, out TOTAL);
response.Data = Utility.Utility_Component.DtToJSon(dt, "ClientCertificateList");
if (dt.Rows.Count > 0)
{
response.Status = 1;
}
else
{
if (strMessage == "")
{
response.Status = 1;
response.Message = "There is no data to display.";
}
else
{
response.Status = 0;
response.Message = strMessage;
}
}
response.Meta.Offset = OFFSET;
response.Meta.Limit = LIMIT;
response.Meta.Total = TOTAL;
timer.Stop();
response.Meta.Duration = timer.Elapsed.TotalMilliseconds;
return(response);
}
catch (Exception)
{
response.Status = 0;
response.Message = " Unexpected error occour.";
return(response);
}
}
public MetaResponse SendMail(string ClientCertificateList)
{
try
{
string strMsg = "";
bool mailSuccess = false;
ArrayList company_no_boxs = new ArrayList();
DataTable dgvList = Utility.Utility_Component.JsonToDt(ClientCertificateList);
List <string> l_SentMail = new List <string>();
for (int i = 0; i < dgvList.Rows.Count; i++)
{
DataRow dr = dgvList.Rows[i];
string l_COMPANY_NO_BOX = dr["COMPANY_NO_BOX"].ToString();
var certificate_list = dgvList.AsEnumerable().Where(row => row.Field <string>("COMPANY_NO_BOX") == l_COMPANY_NO_BOX).Select(s => s.Field <string>("CLIENT_CERTIFICATE_NO")).ToArray();
BOL_CLIENT_CERTIFICATE oCLIENT_CERTIFICATE = new BOL_CLIENT_CERTIFICATE();
oCLIENT_CERTIFICATE = Cast_CLIENT_CERTIFICATE(dr); //check method
BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL();
oREQUEST_DETAIL = Cast_REQUEST_DETAIL(dr);
CLIENT_CERTIFICATE DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
if (l_SentMail.Where(x => x == l_COMPANY_NO_BOX).ToList().Count <= 0)
{
l_SentMail.Add(l_COMPANY_NO_BOX);
mailSuccess = PrepareAndSendMail(certificate_list, oREQUEST_DETAIL.COMPANY_NAME, oREQUEST_DETAIL.CLIENT_CERTIFICATE_SEND_EMAIL_ADDRESS, oCLIENT_CERTIFICATE.EXPIRATION_DATE, oCLIENT_CERTIFICATE.PASSWORD, oCLIENT_CERTIFICATE.FY);
if (mailSuccess)
{
//update email sent date
DAL_CLIENT_CERTIFICATE.EmailButtonUpdate(oCLIENT_CERTIFICATE, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, out strMsg);
if (String.IsNullOrEmpty(strMsg))
{
//success
dr["DISTRIBUTION_DATE"] = UPDATED_AT_DATETIME;
ResponseUtility.ReturnMailSuccessMessage(dr, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else
{
//already use in another process
ResponseUtility.ReturnFailMessage(dr);
}
}
else
{
//fail message
ResponseUtility.MailSendingFail(dr);
}
}
else
{
//update email sent date
DAL_CLIENT_CERTIFICATE.EmailButtonUpdate(oCLIENT_CERTIFICATE, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER, out strMsg);
if (String.IsNullOrEmpty(strMsg))
{
//success
dr["DISTRIBUTION_DATE"] = UPDATED_AT_DATETIME;
ResponseUtility.ReturnMailSuccessMessage(dr, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else
{
//already use in another process
ResponseUtility.ReturnFailMessage(dr);
}
}
}
response.Data = Utility.Utility_Component.DtToJSon(dgvList, "Mail status");;
timer.Stop();
response.Meta.Duration = timer.Elapsed.TotalSeconds;
return(response);
}
catch (Exception ex)
{
return(ResponseUtility.GetUnexpectedResponse(response, timer, ex));
}
}
