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)); } }