private void HandleModify(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, DataRow row)
{
string strMsg = "";
//Get EDI_ACCOUNT object
BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG);
EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con);
if (!DAL_EDI_ACCOUNT.IsAlreadyUpdated(oEDI_ACCOUNT, out strMsg)) // If updated_at is not already modified
{
//insert the record
DAL_EDI_ACCOUNT.Update(oEDI_ACCOUNT, 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
{
ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
private void HandleDelete(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, DataRow row)
{
string strMsg = "";
using (TransactionScope dbTxn = new TransactionScope())
{
//GET EDI ACCOUNT OBJECT
BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG);
EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con);
if (!DAL_EDI_ACCOUNT.IsAlreadyUpdated(oEDI_ACCOUNT, out strMsg)) // IF updated_at is not already modified
{
//delete the record
DAL_EDI_ACCOUNT.Delete(oEDI_ACCOUNT, out strMsg);
}
else
{
dbTxn.Dispose();
ResponseUtility.ReturnFailMessage(row);
return;
}
//return message and MK value
if (String.IsNullOrEmpty(strMsg)) //success
{
dbTxn.Complete();
ResponseUtility.ReturnDeleteSuccessMessage(row);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
}
private void HandleInsert(USAGE_INFO_REGISTRATION oUSAGE_INFO_REG, string OPERATION, DataRow row)
{
string strMsg = "";
//Search in EDI_CANDICATE
BOL_EDI_CANDIDATE oEDI_CANDIDATE = new BOL_EDI_CANDIDATE();
EDI_CANDIDATE DAL_EDI_CANDICATE = new EDI_CANDIDATE(con);
DataTable dtUseFLG = DAL_EDI_CANDICATE.GetUseFLG(oUSAGE_INFO_REG.EDI_ACCOUNT, out strMsg);
using (TransactionScope dbTxn = new TransactionScope())
{
//Prepare EDI CANDIDATE
oEDI_CANDIDATE = GetEDI_CANDIDATE(oUSAGE_INFO_REG);
if (dtUseFLG.Rows.Count == 0)
{
//Insert AS USED
DAL_EDI_CANDICATE.Insert(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg);
}
else
{
if (dtUseFLG.Rows[0]["USED_FLG"].ToString() == "*") //if record is already used
{
ResponseUtility.ReturnFailMessage(row, Utility.Messages.Jimugo.E000WB013);
return;
}
else
{
//set used flage
oEDI_CANDIDATE.USED_FLG = "*";
//Update as USED
DAL_EDI_CANDICATE.Update(oEDI_CANDIDATE, CURRENT_DATETIME, CURRENT_USER, out strMsg);
}
}
EDI_ACCOUNT DAL_EDI_ACCOUNT = new EDI_ACCOUNT(con);
BOL_EDI_ACCOUNT oEDI_ACCOUNT = GetEDI_ACCOUNT(oUSAGE_INFO_REG);
if (DAL_EDI_ACCOUNT.IsCompanyNoBoxAlreadyRegistered(oEDI_ACCOUNT.COMPANY_NO_BOX, out strMsg))
{
ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "会社番号+BOX"));
return;
}
if (DAL_EDI_ACCOUNT.IsEDIAccountAlreadyRegistered(oEDI_ACCOUNT.EDI_ACCOUNT, out strMsg))
{
ResponseUtility.ReturnFailMessage(row, String.Format(Utility.Messages.Jimugo.E000ZZ038, "EDIアカウント"));
return;
}
DAL_EDI_ACCOUNT.Insert(oEDI_ACCOUNT, CURRENT_DATETIME, CURRENT_USER, out strMsg);
#region ASSIGN_MK_VALUE_AND_MESSAGES
if (String.IsNullOrEmpty(strMsg)) //success
{
dbTxn.Complete();
ResponseUtility.ReturnSuccessMessage(row, UPDATED_AT_DATETIME, CURRENT_DATETIME, CURRENT_USER);
}
else //failed
{
ResponseUtility.ReturnFailMessage(row);
}
}
#endregion
}
public MetaResponse SendMailCreate(string list) //add more parameter
{
#region Parameters
//message for pop up
DataTable messagecode = new DataTable();
messagecode.Columns.Add("Error Message");
DataTable dtParameter = Utility.Utility_Component.JsonToDt(list);
COMPANY_NO_BOX = dtParameter.Rows[0]["COMPANY_NO_BOX"].ToString();
REQ_SEQ = Convert.ToInt32(dtParameter.Rows[0]["REQ_SEQ"].ToString());
QUOTATION_DATE = dtParameter.Rows[0]["QUOTATION_DATE"].ToString();
ORDER_DATE = dtParameter.Rows[0]["ORDER_DATE"].ToString();
COMPLETION_NOTIFICATION_DATE = dtParameter.Rows[0]["COMPLETION_NOTIFICATION_DATE"].ToString();
COMPANY_NAME = dtParameter.Rows[0]["COMPANY_NAME"].ToString();
EMAIL_ADDRESS = dtParameter.Rows[0]["EMAIL_ADDRESS"].ToString();
EDI_ACCOUNT = dtParameter.Rows[0]["EDI_ACCOUNT"].ToString();
FILENAME = dtParameter.Rows[0]["FILENAME"].ToString();
#endregion
string msg = "";
try
{
using (TransactionScope dbtnx = new TransactionScope())
{
#region Update RequestDetail For CompleteNotificationSending
DAL_REQUEST_DETAIL.SendMailUpdate(TEMP.ToString("yyyy/MM/dd"), COMPANY_NO_BOX, REQ_SEQ, CURRENT_DATETIME, CURRENT_USER, out msg);
#endregion
if (String.IsNullOrEmpty(msg))
{
#region InsertReportHistroy
DateTime now = DateTime.Now;
string outputFile = COMPANY_NO_BOX + "-" + "3" + "-" + REQ_SEQ.ToString().PadLeft(2, '0') + "_完了通知書(" + EDI_ACCOUNT.Replace("@", "") + ")_" + COMPANY_NAME + "様" + ".pdf";
string msgText = outputFile;
int REPORTHISTORY_SEQ = DAL_REPORT_HISTORY.GetReportHistorySEQ(COMPANY_NO_BOX, 5, REQ_SEQ, out msg);
if (string.IsNullOrEmpty(msg))
{
DAL_REPORT_HISTORY.InsertNotiSending(COMPANY_NO_BOX, REQ_SEQ, REPORTHISTORY_SEQ, outputFile, EMAIL_ADDRESS, CURRENT_USER, UPDATED_AT_DATETIME, CURRENT_DATETIME, out msg);
if (string.IsNullOrEmpty(msg))
{
BOL_CONFIG config = new BOL_CONFIG("CTS060", con);
BOL_CONFIG config1 = new BOL_CONFIG("SYSTEM", con);
string temPath = config1.getStringValue("temp.dir");
temPath = temPath + "/" + FILENAME;
string pdfSavePath = config.getStringValue("fileSavePath.completionNotice");
pdfSavePath = pdfSavePath + "/" + outputFile;
//CopyAndMove File
int res = MovePdfFile(temPath, pdfSavePath);
if (res == 1)
{
//BOL_CONFIG config1 = new BOL_CONFIG("SYSTEM", con);
string zipStorageFolder = config1.getStringValue("temp.dir") + "/" + outputFile.Replace(".pdf", ".zi_");
string PASSWORD = config.getStringValue("password.Attachment");
//Create ZipFile With Password
bool zipgenerate = ZipGenerator(temPath, PASSWORD, zipStorageFolder, outputFile);
if (zipgenerate)
{
#region SendMail
String emailAddressCC = config.getStringValue("emailAddress.cc");
string tempString = PrepareAndSendMail(COMPANY_NAME, PASSWORD);
if (tempString != null)
{
string subjectString = config.getStringValue("emailSubject.notice");
DataTable result = new DataTable();
result.Clear();
result.Columns.Add("ZipFileName");
result.Columns.Add("EmailAddressCC");
result.Columns.Add("TemplateString");
result.Columns.Add("SubjectString");
result.Columns.Add("COMPLETE_NOTIFICATION_DATE");
result.Columns.Add("UPDATED_AT");
result.Columns.Add("UPDATED_AT_RAW");
DataRow dtRow = result.NewRow();
dtRow["ZipFileName"] = outputFile.Replace(".pdf", ".zi_");
dtRow["EmailAddressCC"] = emailAddressCC;
dtRow["TemplateString"] = tempString;
dtRow["SubjectString"] = subjectString.Replace("${companyName}", COMPANY_NAME);
dtRow["COMPLETE_NOTIFICATION_DATE"] = TEMP.ToString("yyyy/MM/dd");
dtRow["UPDATED_AT"] = UPDATED_AT_DATETIME;
dtRow["UPDATED_AT_RAW"] = CURRENT_DATETIME;
result.Rows.Add(dtRow);
dbtnx.Complete();
response.Data = Utility.Utility_Component.DtToJSon(result, "pdfData");
response.Status = 1;
return(response);
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB018));
}
#endregion
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB007));
}
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, String.Format(Utility.Messages.Jimugo.E000WB001, msgText)));
}
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB003));
}
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB002));
}
#endregion
}
else
{
return(ResponseUtility.ReturnFailMessage(response, timer, messagecode, Utility.Messages.Jimugo.E000WB002));
}
}
}
catch (Exception ex)
{
return(ResponseUtility.GetUnexpectedResponse(response, timer, ex));
}
}
