public ControllerUsageInfoRegistrationList(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public MetaResponse NotiSendingPreview(string COMPANY_NAME, string COMPANY_NO_BOX, string REQ_SEQ, string EDI_ACCOUNT, string authHeader) { try { //int status; //message for pop up DataTable messagecode = new DataTable(); messagecode.Columns.Add("Message"); DataRow dr = messagecode.NewRow(); string strMessage = ""; //get config object for CTS060 BOL_CONFIG config = new BOL_CONFIG("SYSTEM", con); int FY = config.getIntValue("client.certificate.FY"); status = 1; int clientCertificateDiff = DAL_REQUEST_DETAIL.GetClientCertificateDiff(COMPANY_NO_BOX, REQ_SEQ, FY.ToString(), out strMessage); using (TransactionScope dbTxn = new TransactionScope()) { for (int i = 1; i <= clientCertificateDiff; i++) { #region SearchClientCertificateNo string clientCertificateNo = DAL_CLIENT_CERTIFICATE.GetClientCertificateNo(FY.ToString(), out strMessage); if (!string.IsNullOrEmpty(clientCertificateNo)) { #region UpdateWithClientCertificateNo status = UpdateWithClientCertificateNO(clientCertificateNo, COMPANY_NO_BOX, CURRENT_USER, strMessage); #endregion if (status == 0) { dbTxn.Dispose(); response.Status = 0; response.Message = Utility.Messages.Jimugo.E000WB005; dr["Message"] = Utility.Messages.Jimugo.E000WB005; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } } else { response.Status = 0; response.Message = Utility.Messages.Jimugo.E000WB004; dr["Message"] = Utility.Messages.Jimugo.E000WB004; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } #endregion } if (status == 2) { dbTxn.Complete(); } } if (status == 1 || status == 2) { #region GetPDFData DataTable dtPDFData = DAL_REQUEST_DETAIL.GetPDFData(COMPANY_NO_BOX, REQ_SEQ, out strMessage); DataTable dtPDFData1 = DAL_REQ_ADDRESS.GetPDFData1(COMPANY_NO_BOX, REQ_SEQ, out strMessage); DataTable dtPDFData2 = DAL_REQ_ADDRESS.GetPDFData2(COMPANY_NO_BOX, REQ_SEQ, out strMessage); string req_seq = REQ_SEQ.Length != 1 ? REQ_SEQ : REQ_SEQ.ToString().PadLeft(2, '0'); string saveFileName = COMPANY_NO_BOX + "-" + "3" + "-" + req_seq + "_完了通知書(" + EDI_ACCOUNT.Replace("@", "") + ")_" + COMPANY_NAME + "様_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"; response = getPDF(COMPANY_NO_BOX, COMPANY_NAME, dtPDFData, dtPDFData1, dtPDFData2, saveFileName, status); #endregion } else { response.Status = 0; response.Message = Utility.Messages.Jimugo.I000WB001; dr["Message"] = Utility.Messages.Jimugo.I000WB001; messagecode.Rows.Add(dr); response.Data = Utility_Component.DtToJSon(messagecode, "Message"); return(response); } return(response); //process 3 successful } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public ControllerRegisterCompleteNotificationSending(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
protected void seperateAmigo_NonAmigo() { CUSTOMER_MASTER oCust = new CUSTOMER_MASTER(Properties.Settings.Default.MyConnection); string run_date = DateTime.Now.ToString(); DataTable dtCustomer = oCust.getBillBankAccounts(); for (int i = 0; i < dtUploadData.Rows.Count; i++) { string strCustomerName = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString().Trim() : ""); var query = dtCustomer.AsEnumerable().Where (r => (r.Field <string>("BILL_BANK_ACCOUNT_NAME-1") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-1").Trim()) == strCustomerName || (r.Field <string>("BILL_BANK_ACCOUNT_NAME-2") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-2").Trim()) == strCustomerName || (r.Field <string>("BILL_BANK_ACCOUNT_NAME-3") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-3").Trim()) == strCustomerName || (r.Field <string>("BILL_BANK_ACCOUNT_NAME-4") == null ? "" : r.Field <string>("BILL_BANK_ACCOUNT_NAME-4").Trim()) == strCustomerName ); if (query.Any()) //Amigo { BOL_RECEIPT_DETAILS oReceipt = new BOL_RECEIPT_DETAILS(); oReceipt.DATA_CLASS = 1; oReceipt.RECORD_CLASS = (dtUploadData.Rows[i]["RECORD_CLASS"] != null ? dtUploadData.Rows[i]["RECORD_CLASS"].ToString() : ""); oReceipt.TRANSACTION_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["TRANSACTION_DATE"] != null ? dtUploadData.Rows[i]["TRANSACTION_DATE"].ToString() : ""); oReceipt.TRANSACTION_CONTACT_NAME = (dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"].ToString() : ""); oReceipt.TRANSACTION_BANKS_NAME = (dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"].ToString() : ""); oReceipt.TRANSACTION_BRANCH_NAME = (dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"].ToString() : ""); oReceipt.TRANSACTION_ACCOUNT_NO_CLASS = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"].ToString() : ""); oReceipt.TRANSACTION_ACCOUNT_TYPE = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"].ToString() : ""); oReceipt.TRANSACTION_ACCOUNT_NO = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"].ToString() : ""); oReceipt.RESEND_INDICATION = (dtUploadData.Rows[i]["RESEND_INDICATION"] != null ? dtUploadData.Rows[i]["RESEND_INDICATION"].ToString() : ""); oReceipt.TRANSACTION_NAME = (dtUploadData.Rows[i]["TRANSACTION_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_NAME"].ToString() : ""); oReceipt.TRANSACTION_NO = (dtUploadData.Rows[i]["TRANSACTION_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_NO"].ToString() : ""); oReceipt.TRANSACTION_DETAIL_CLASS = (dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"].ToString() : ""); oReceipt.HANDLING_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["HANDLING_DATE"] != null ? dtUploadData.Rows[i]["HANDLING_DATE"].ToString() : ""); oReceipt.DEPOSIT_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["DEPOSIT_DATE"] != null ? dtUploadData.Rows[i]["DEPOSIT_DATE"].ToString() : ""); oReceipt.DEPOSIT_AMOUNT = Utility_Component.dtColumnToDecimal(dtUploadData.Rows[i]["DEPOSIT_AMOUNT"] != null ? dtUploadData.Rows[i]["DEPOSIT_AMOUNT"].ToString() : ""); oReceipt.CHECK_CLASS = (dtUploadData.Rows[i]["CHECK_CLASS"] != null ? dtUploadData.Rows[i]["CHECK_CLASS"].ToString() : ""); oReceipt.CUSTOMER_NAME = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString() : ""); oReceipt.COLLECTION_NO_SHEETS = Utility_Component.dtColumnToInt(dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"] != null ? dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"].ToString() : ""); oReceipt.COLLECTION_NO = (dtUploadData.Rows[i]["COLLECTION_NO"] != null ? dtUploadData.Rows[i]["COLLECTION_NO"].ToString() : ""); oReceipt.CUSTOMER_NO = (dtUploadData.Rows[i]["CUSTOMER_NO"] != null ? dtUploadData.Rows[i]["CUSTOMER_NO"].ToString() : ""); oReceipt.BANK_NAME = (dtUploadData.Rows[i]["BANK_NAME"] != null ? dtUploadData.Rows[i]["BANK_NAME"].ToString() : ""); oReceipt.BRANCH_NAME = (dtUploadData.Rows[i]["BRANCH_NAME"] != null ? dtUploadData.Rows[i]["BRANCH_NAME"].ToString() : ""); oReceipt.TRANSACTION_FILE_NAME = (dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"].ToString() : ""); oReceipt.TRANSFER_MESSAGE = (dtUploadData.Rows[i]["TRANSFER_MESSAGE"] != null ? dtUploadData.Rows[i]["TRANSFER_MESSAGE"].ToString() : ""); oReceipt.NOTE = (dtUploadData.Rows[i]["NOTE"] != null ? dtUploadData.Rows[i]["NOTE"].ToString() : ""); oReceipt.NUMBER = (!String.IsNullOrEmpty(dtUploadData.Rows[i]["NUMBER"].ToString()) ? int.Parse(dtUploadData.Rows[i]["NUMBER"].ToString()) : 0); oReceipt.RUN_DATE_TIME = run_date; oReceipt.RUN_RESULT = 1; oReceipt.DATA_MOVEMENT_INFORMATION = ""; oReceipt.PAYMENT_DAY = null; oReceipt.TYPE_OF_ALLOCATION = 0; oReceipt.ALLOCATED_QUANTITY = 0; oReceipt.ALLOCATED_MONEY = 0; oReceipt.ALLOCATED_COMPLETION_DATE = null; lstAmigo.Add(oReceipt); } else //Non Amigo { BOL_RECEIPT_DETAILS_NON_AMIGO oReceipt_NonAmigo = new BOL_RECEIPT_DETAILS_NON_AMIGO(); oReceipt_NonAmigo.DATA_CLASS = 1; oReceipt_NonAmigo.RECORD_CLASS = (dtUploadData.Rows[i]["RECORD_CLASS"] != null ? dtUploadData.Rows[i]["RECORD_CLASS"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["TRANSACTION_DATE"] != null ? dtUploadData.Rows[i]["TRANSACTION_DATE"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_CONTACT_NAME = (dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_CONTACT_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_BANKS_NAME = (dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BANKS_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_BRANCH_NAME = (dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_BRANCH_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_ACCOUNT_NO_CLASS = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO_CLASS"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_ACCOUNT_TYPE = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_TYPE"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_ACCOUNT_NO = (dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_ACCOUNT_NO"].ToString() : ""); oReceipt_NonAmigo.RESEND_INDICATION = (dtUploadData.Rows[i]["RESEND_INDICATION"] != null ? dtUploadData.Rows[i]["RESEND_INDICATION"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_NAME = (dtUploadData.Rows[i]["TRANSACTION_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_NO = (dtUploadData.Rows[i]["TRANSACTION_NO"] != null ? dtUploadData.Rows[i]["TRANSACTION_NO"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_DETAIL_CLASS = (dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"] != null ? dtUploadData.Rows[i]["TRANSACTION_DETAIL_CLASS"].ToString() : ""); oReceipt_NonAmigo.HANDLING_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["HANDLING_DATE"] != null ? dtUploadData.Rows[i]["HANDLING_DATE"].ToString() : ""); oReceipt_NonAmigo.DEPOSIT_DATE = Utility_Component.dtColumnToDateTime(dtUploadData.Rows[i]["DEPOSIT_DATE"] != null ? dtUploadData.Rows[i]["DEPOSIT_DATE"].ToString() : ""); oReceipt_NonAmigo.DEPOSIT_AMOUNT = Utility_Component.dtColumnToDecimal(dtUploadData.Rows[i]["DEPOSIT_AMOUNT"] != null ? dtUploadData.Rows[i]["DEPOSIT_AMOUNT"].ToString() : ""); oReceipt_NonAmigo.CHECK_CLASS = (dtUploadData.Rows[i]["CHECK_CLASS"] != null ? dtUploadData.Rows[i]["CHECK_CLASS"].ToString() : ""); oReceipt_NonAmigo.CUSTOMER_NAME = (dtUploadData.Rows[i]["CUSTOMER_NAME"] != null ? dtUploadData.Rows[i]["CUSTOMER_NAME"].ToString() : ""); oReceipt_NonAmigo.COLLECTION_NO_SHEETS = Utility_Component.dtColumnToInt(dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"] != null ? dtUploadData.Rows[i]["COLLECTION_NO_SHEETS"].ToString() : ""); oReceipt_NonAmigo.COLLECTION_NO = (dtUploadData.Rows[i]["COLLECTION_NO"] != null ? dtUploadData.Rows[i]["COLLECTION_NO"].ToString() : ""); oReceipt_NonAmigo.CUSTOMER_NO = (dtUploadData.Rows[i]["CUSTOMER_NO"] != null ? dtUploadData.Rows[i]["CUSTOMER_NO"].ToString() : ""); oReceipt_NonAmigo.BANK_NAME = (dtUploadData.Rows[i]["BANK_NAME"] != null ? dtUploadData.Rows[i]["BANK_NAME"].ToString() : ""); oReceipt_NonAmigo.BRANCH_NAME = (dtUploadData.Rows[i]["BRANCH_NAME"] != null ? dtUploadData.Rows[i]["BRANCH_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSACTION_FILE_NAME = (dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"] != null ? dtUploadData.Rows[i]["TRANSACTION_FILE_NAME"].ToString() : ""); oReceipt_NonAmigo.TRANSFER_MESSAGE = (dtUploadData.Rows[i]["TRANSFER_MESSAGE"] != null ? dtUploadData.Rows[i]["TRANSFER_MESSAGE"].ToString() : ""); oReceipt_NonAmigo.NOTE = (dtUploadData.Rows[i]["NOTE"] != null ? dtUploadData.Rows[i]["NOTE"].ToString() : ""); oReceipt_NonAmigo.NUMBER = (!String.IsNullOrEmpty(dtUploadData.Rows[i]["NUMBER"].ToString()) ? int.Parse(dtUploadData.Rows[i]["NUMBER"].ToString()) : 0); oReceipt_NonAmigo.RUN_DATE_TIME = run_date; oReceipt_NonAmigo.RUN_RESULT = 99; oReceipt_NonAmigo.DATA_MOVEMENT_INFORMATION = ""; oReceipt_NonAmigo.PAYMENT_DAY = null; oReceipt_NonAmigo.TYPE_OF_ALLOCATION = 0; oReceipt_NonAmigo.ALLOCATED_QUANTITY = 0; oReceipt_NonAmigo.ALLOCATED_MONEY = 0; oReceipt_NonAmigo.ALLOCATED_COMPLETION_DATE = null; lstNonAmigo.Add(oReceipt_NonAmigo); } } }
public ControllerClientCertificateList(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public ControllerUsageChargeMaster(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public ControllerMonthlySaleAggregation(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public string CreateInvoiceData(string BILLING_DATE, string status) { string errorStatus = ""; using (TransactionScope dbTxn = new TransactionScope()) { try { int OFFSET = 0; int LIMIT = 0; String strMessage = ""; int TOTAL; int countForInsert = 0; string checkGetOrCreate = "CREATE"; DateTime yearMonth = Convert.ToDateTime(BILLING_DATE); String YEAR_MONTH = yearMonth.ToString("yyyyMM"); if (InvoiceAllocationAmountCheck(BILLING_DATE)) { errorStatus = "3"; return(errorStatus); } if (status == "1") { //delete Existing Invoice List bool checkDelete = HandleDelete(BILLING_DATE); if (!checkDelete) { errorStatus = "0"; return(errorStatus); } } //Select Invoice Data INVOICE_INFO DAL_INVOICE_INFO = new INVOICE_INFO(con); DataTable dt = DAL_INVOICE_INFO.GetInvoiceList(YEAR_MONTH, OFFSET, LIMIT, checkGetOrCreate, out strMessage, out TOTAL); for (int i = 0; i < dt.Rows.Count; i++) { decimal Key_source_Monthly_usage_fee_REQ_SEQ = 0; decimal Supplier_Initial_expense_REQ_SEQ = 0; decimal Supplier_Monthly_usage_fee_REQ_SEQ = 0; decimal Production_information_browsing_Initial_expense_REQ_SEQ = 0; decimal View_production_information_Annual_usage_fee_REQ_SEQ = 0; DataRow row = dt.Rows[i]; if (!string.IsNullOrEmpty(row["Key_source_Monthly_usage_fee"].ToString())) { Key_source_Monthly_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Key_source_Monthly_usage_fee"].ToString()); } if (!string.IsNullOrEmpty(row["Supplier_Initial_expense"].ToString())) { Supplier_Initial_expense_REQ_SEQ = Convert.ToDecimal(row["Supplier_Initial_expense"].ToString()); } if (!string.IsNullOrEmpty(row["Supplier_Monthly_usage_fee"].ToString())) { Supplier_Monthly_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Supplier_Monthly_usage_fee"].ToString()); } if (!string.IsNullOrEmpty(row["Production_information_browsing_Initial_expense"].ToString())) { Production_information_browsing_Initial_expense_REQ_SEQ = Convert.ToDecimal(row["Production_information_browsing_Initial_expense"].ToString()); } if (!string.IsNullOrEmpty(row["Viewing_production_information_Annual_usage_fee"].ToString())) { View_production_information_Annual_usage_fee_REQ_SEQ = Convert.ToDecimal(row["Viewing_production_information_Annual_usage_fee"].ToString()); } BOL_INVOICE_INFO oINVOICE_INFO = new BOL_INVOICE_INFO(); #region Set value in Model oINVOICE_INFO.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); oINVOICE_INFO.INVOICE_DATE = DateTime.Now; oINVOICE_INFO.NCS_CUSTOMER_CODE = row["NCS_CUSTOMER_CODE"].ToString(); oINVOICE_INFO.BILL_SUPPLIER_NAME = row["BILL_COMPANY_NAME"].ToString(); oINVOICE_INFO.BILL_SUPPLIER_NAME_READING = row["COMPANY_NAME_READING"].ToString(); oINVOICE_INFO.BILL_COMPANY_NAME = row["COMPANY_NAME"].ToString(); oINVOICE_INFO.BILL_DEPARTMENT_IN_CHARGE = row["BILL_DEPARTMENT_IN_CHARGE"].ToString(); oINVOICE_INFO.BILL_CONTACT_NAME = row["BILL_CONTACT_NAME"].ToString(); oINVOICE_INFO.BILL_HONORIFIC = "様"; oINVOICE_INFO.BILL_POSTAL_CODE = row["BILL_POSTAL_CODE"].ToString(); oINVOICE_INFO.BILL_ADDRESS = row["BILL_ADDRESS"].ToString(); oINVOICE_INFO.BILL_ADDRESS_2 = row["BILL_ADDRESS_BUILDING"].ToString(); string CONTRACT_PLAN = row["CONTRACT_PLAN"].ToString(); if (CONTRACT_PLAN == "SERVER") { oINVOICE_INFO.PLAN_SERVER = 1; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "SERVERRIGHT") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 1; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "BROWSERAUTO") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 1; oINVOICE_INFO.PLAN_BROWSER = 0; } if (CONTRACT_PLAN == "BROWSER") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 1; } if (CONTRACT_PLAN == "PRODUCT") { oINVOICE_INFO.PLAN_SERVER = 0; oINVOICE_INFO.PLAN_SERVER_LIGHT = 0; oINVOICE_INFO.PLAN_BROWSER_AUTO = 0; oINVOICE_INFO.PLAN_BROWSER = 0; } oINVOICE_INFO.PLAN_AMIGO_CAI = Utility_Component.dtColumnToInt(row["OP_AMIGO_CAI"].ToString()); oINVOICE_INFO.PLAN_AMIGO_BIZ = Utility_Component.dtColumnToInt(row["OP_AMIGO_BIZ"].ToString()); oINVOICE_INFO.PLAN_ADD_BOX_SERVER = Utility_Component.dtColumnToInt(row["OP_BOX_SERVER"].ToString()); oINVOICE_INFO.PLAN_ADD_BOX_BROWSER = Utility_Component.dtColumnToInt(row["OP_BOX_BROWSER"].ToString()); oINVOICE_INFO.PLAN_OP_FLAT = Utility_Component.dtColumnToInt(row["OP_FLAT"].ToString()); oINVOICE_INFO.PLAN_OP_SSL = Utility_Component.dtColumnToInt(row["OP_CLIENT"].ToString()); oINVOICE_INFO.PLAN_OP_BASIC_SERVICE = Utility_Component.dtColumnToInt(row["OP_BASIC_SERVICE"].ToString()); oINVOICE_INFO.PLAN_OP_ADD_SERVICE = Utility_Component.dtColumnToInt(row["OP_ADD_SERVICE"].ToString()); if (row["SOCIOS_USER_FLG"].ToString() == " ") { oINVOICE_INFO.PLAN_OP_SOCIOS = 0; } if (row["SOCIOS_USER_FLG"].ToString() == "*") { oINVOICE_INFO.PLAN_OP_SOCIOS = 1; } oINVOICE_INFO.BILL_DEPOSIT_RULES = row["BILL_DEPOSIT_RULES"].ToString(); oINVOICE_INFO.BILL_TRANSFER_FEE = Utility_Component.dtColumnToDecimal(row["BILL_TRANSFER_FEE"].ToString()); oINVOICE_INFO.BILL_EXPENSES = Utility_Component.dtColumnToDecimal(row["BILL_EXPENSES"].ToString()); DateTime date = Convert.ToDateTime(BILLING_DATE); var lastDateOfMonth = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)).ToString("dd"); var lastDay = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)).DayOfWeek; var BILL_DATE = BILLING_DATE + "/" + lastDateOfMonth; DateTime PaymentDay = Convert.ToDateTime(BILL_DATE); string strPaymentDay = ""; if (lastDay.ToString() == "Saturday") { strPaymentDay = PaymentDay.AddDays(-1).ToString(); } if (lastDay.ToString() == "Sunday") { strPaymentDay = PaymentDay.AddDays(-2).ToString(); } if (lastDay.ToString() != "Saturday" && lastDay.ToString() != "Sunday") { strPaymentDay = PaymentDay.ToString(); } oINVOICE_INFO.BILL_PAYMENT_DATE = Utility_Component.dtColumnToDateTime(strPaymentDay); oINVOICE_INFO.STATUS_PRINT = null; oINVOICE_INFO.STATUS_MEMO = null; oINVOICE_INFO.STATUS_SEND = null; oINVOICE_INFO.STATUS_MAIL_DATE = null; //declare check oINVOICE_INFO.STATUS_ACC_RECEIVABLE_DATE = null; oINVOICE_INFO.STATUS_INVOCE_COPY_DATE = null; oINVOICE_INFO.STATUS_ACTUAL_MDB_UPDATE = null; oINVOICE_INFO.STATUS_ACTUAL_DEPOSIT_YYMM = null; oINVOICE_INFO.STATUS_ACTUAL_DEPOSIT_DATE = null; oINVOICE_INFO.STATUS_CASH_FORECAST_MM = null; //need to change set value string depositRuleCheck = row["BILL_DEPOSIT_RULES"].ToString(); if (depositRuleCheck == "0") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.AddMonths(1).ToString("yyMM"); } if (depositRuleCheck == "1") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.ToString("yyMM"); } if (depositRuleCheck == "2") { oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = date.AddMonths(2).ToString("yyMM"); } //oINVOICE_INFO.STATUS_PLAN_DEPOSIT_YYMM = row["BILL_SUPPLIER_NAME"].ToString(); oINVOICE_INFO.STATUS_PAY_NOTICE_DATE = null; oINVOICE_INFO.TYPE_OF_ALLOCATION = 0; oINVOICE_INFO.ALLOCATION_TOTAL_AMOUNT = 0; oINVOICE_INFO.ALLOCATED_COMPLETION_DATE = null; oINVOICE_INFO.DUNNING_COUNT = 0; oINVOICE_INFO.DUNNING_DATE = null; oINVOICE_INFO.ANSWER_DATE = null; oINVOICE_INFO.PAYMENT_DUE_DATE = null; oINVOICE_INFO.ANSWER_MEMO = null; oINVOICE_INFO.SPECIAL_NOTES_1 = null; oINVOICE_INFO.SPECIAL_NOTES_2 = null; oINVOICE_INFO.SPECIAL_NOTES_3 = null; oINVOICE_INFO.SPECIAL_NOTES_4 = null; #endregion if (Key_source_Monthly_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "12"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Key_source_Monthly_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Supplier_Initial_expense_REQ_SEQ > 0) { string TRANSACTION_TYPE = "21"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM") + "IC"; oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Supplier_Initial_expense_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Supplier_Monthly_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "22"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Supplier_Monthly_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } if (Production_information_browsing_Initial_expense_REQ_SEQ > 0 || View_production_information_Annual_usage_fee_REQ_SEQ > 0) { string TRANSACTION_TYPE = "32"; oINVOICE_INFO.TRANSACTION_TYPE = TRANSACTION_TYPE; oINVOICE_INFO.YEAR_MONTH = "-" + yearMonth.ToString("yyMM"); oINVOICE_INFO.BILL_AMOUNT = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense"].ToString()) + Utility_Component.dtColumnToDecimal(row["Viewing_production_information_Annual_usage_fee"].ToString()); oINVOICE_INFO.BILL_TAX = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense_TAX"].ToString()) + Utility_Component.dtColumnToDecimal(row["View_production_information_Annual_usage_fee_TAX"].ToString()); oINVOICE_INFO.BILL_PRICE = Utility_Component.dtColumnToDecimal(row["Production_information_browsing_Initial_expense_INCLUDING_TAX"].ToString()) + Utility_Component.dtColumnToDecimal(row["View_production_information_Annual_usage_fee_INCLUDING_TAX"].ToString()); //Insert InvoiceData DAL_INVOICE_INFO.InsertInvoiceInfo(oINVOICE_INFO, out strMessage); countForInsert++; } } if (string.IsNullOrEmpty(strMessage) && countForInsert > 0) { errorStatus = "1," + countForInsert; dbTxn.Complete(); } else { errorStatus = "2"; } } catch (Exception ex) { errorStatus = "2"; } } return(errorStatus); }
private BOL_REQUEST_DETAIL Cast_REQUEST_DETAIL(DataRow row) { BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString(); oREQUEST_DETAIL.REQ_SEQ = Utility_Component.dtColumnToInt(row["REQ_SEQ"].ToString()); oREQUEST_DETAIL.COMPANY_NAME = row["COMPANY_NAME"].ToString(); oREQUEST_DETAIL.CLOSE_FLG = row["CLOSE_FLG"].ToString(); string str_REQ_TYPE = row["REQ_TYPE"].ToString(); switch (str_REQ_TYPE) { case "新規": oREQUEST_DETAIL.REQ_TYPE = 1; break; case "変更": oREQUEST_DETAIL.REQ_TYPE = 2; break; case "解約": oREQUEST_DETAIL.REQ_TYPE = 9; break; default: break; } string str_REQ_STATUS = row["REQ_STATUS"].ToString(); switch (str_REQ_STATUS) { case "仮登録(保存": oREQUEST_DETAIL.REQ_STATUS = 0; break; case "申請中": oREQUEST_DETAIL.REQ_STATUS = 1; break; case "承認済": oREQUEST_DETAIL.REQ_STATUS = 2; break; case "否認": oREQUEST_DETAIL.REQ_STATUS = 3; break; case "申請取消": oREQUEST_DETAIL.REQ_STATUS = 9; break; default: break; } oREQUEST_DETAIL.REQ_DATE = Utility_Component.dtColumnToDateTime(row["REQ_DATE"].ToString()); oREQUEST_DETAIL.QUOTATION_DATE = Utility_Component.dtColumnToDateTime(row["QUOTATION_DATE"].ToString()); oREQUEST_DETAIL.ORDER_DATE = Utility_Component.dtColumnToDateTime(row["ORDER_DATE"].ToString()); oREQUEST_DETAIL.SYSTEM_EFFECTIVE_DATE = Utility_Component.dtColumnToDateTime(row["SYSTEM_EFFECTIVE_DATE"].ToString()); string str_system_status = row["SYSTEM_SETTING_STATUS"].ToString(); if (str_system_status == "依頼中") { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 1; } else if (str_system_status == "設定済み") { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 2; } else { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 0; } oREQUEST_DETAIL.COMPLETION_NOTIFICATION_DATE = Utility_Component.dtColumnToDateTime(row["COMPLETION_NOTIFICATION_DATE"].ToString()); oREQUEST_DETAIL.NML_CODE_NISSAN = row["NML_CODE_NISSAN"].ToString(); oREQUEST_DETAIL.NML_CODE_NS = row["NML_CODE_NS"].ToString(); oREQUEST_DETAIL.NML_CODE_JATCO = row["NML_CODE_JATCO"].ToString(); oREQUEST_DETAIL.NML_CODE_AK = row["NML_CODE_AK"].ToString(); oREQUEST_DETAIL.NML_CODE_NK = row["NML_CODE_NK"].ToString(); oREQUEST_DETAIL.UPDATED_AT = row["UPDATED_AT"].ToString(); oREQUEST_DETAIL.UPDATED_AT_RAW = row["UPDATED_AT_RAW"].ToString(); return(oREQUEST_DETAIL); }
public MetaResponse Disapprove(string COMPANY_NO_BOX, int REQ_TYPE, string CHANGED_ITEMS, string SYSTEM_EFFECTIVE_DATE, string SYSTEM_REGIST_DEADLINE, string List) { try { DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } string msg = ""; BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL.REQ_STATUS = 3; if (REQ_TYPE == 1 || REQ_TYPE == 9 || (REQ_TYPE == 2 && !string.IsNullOrEmpty(CHANGED_ITEMS.Trim()))) { oREQUEST_DETAIL.AMIGO_COOPERATION = 1; } else { oREQUEST_DETAIL.AMIGO_COOPERATION = 2; } oREQUEST_DETAIL.AMIGO_COOPERATION_CHENGED_ITEMS = CHANGED_ITEMS.Trim(); try { oREQUEST_DETAIL.SYSTEM_EFFECTIVE_DATE = Convert.ToDateTime(SYSTEM_EFFECTIVE_DATE); } catch (Exception) { } try { oREQUEST_DETAIL.SYSTEM_REGIST_DEADLINE = Convert.ToDateTime(SYSTEM_REGIST_DEADLINE); } catch (Exception) { } oREQUEST_DETAIL.REQ_SEQ = int.Parse(row["REQ_SEQ"].ToString()); oREQUEST_DETAIL.UPDATED_AT = row["UPDATED_AT_RAW"].ToString(); oREQUEST_DETAIL.COMPANY_NO_BOX = COMPANY_NO_BOX; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.Disapprove(oREQUEST_DETAIL, CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.REQ_SEQ = REQ_TYPE; DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (string.IsNullOrEmpty(msg)) { DataTable dtMail = new DataTable(); bool success = DisapproveSendMail(row["COMPANY_NAME"].ToString(), row["INPUT_PERSON"].ToString(), row["INPUT_PERSON_EMAIL_ADDRESS"].ToString(), out dtMail); if (success) { response.Status = 1; row["UPDATED_AT"] = UPDATED_AT_DATETIME; row["UPDATED_AT_RAW"] = CURRENT_DATETIME; row["UPDATED_BY"] = CURRENT_USER; row["UPDATE_MESSAGE"] = string.Format(Messages.Jimugo.I000ZZ016, "否認"); Listing.TableName = "LISTING"; ds.Tables.Add(Listing.Copy()); dtMail.TableName = "MAIL"; ds.Tables.Add(dtMail.Copy()); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } response.Data = Utility.Utility_Component.DsToJSon(ds, "Approval"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public Response GetScheduled_Payment( int TRANSACTION_TYPE, string FROM_YEAR_MONTH, string TO_YEAR_MONTH, string FROM_STATUS_PLAN_DEPOSIT_YYMM, string TO_STATUS_PLAN_DEPOSIT_YYMM, string FROM_STATUS_ACTUAL_DEPOSIT_DATE, string TO_STATUS_ACTUAL_DEPOSIT_DATE, string DEPOSIT_RULE, string WITH_OR_WITHOUT_PAYMENT, string BILL_SUPPLIER_NAME) { try { INVOICE_INFO oINV = new INVOICE_INFO(Properties.Settings.Default.MyConnection); string strMessage = ""; string from_yearMonth = Utility_Component.GetYearMonth(FROM_YEAR_MONTH, true); string to_yearMonth = Utility_Component.GetYearMonth(TO_YEAR_MONTH, false); string from_statusPlanYYMM = Utility_Component.GetYearMonth(FROM_STATUS_PLAN_DEPOSIT_YYMM, true); string to_statusPlanYYMM = Utility_Component.GetYearMonth(TO_STATUS_PLAN_DEPOSIT_YYMM, false); string from_statusPlanDate = Utility_Component.GetFullDate(FROM_STATUS_ACTUAL_DEPOSIT_DATE); string to_statusPlanDate = Utility_Component.GetFullDate(TO_STATUS_ACTUAL_DEPOSIT_DATE); DataTable dt = oINV.getDataForScheduled_Payment( TRANSACTION_TYPE, from_yearMonth, to_yearMonth, from_statusPlanYYMM, to_statusPlanYYMM, from_statusPlanDate, to_statusPlanDate, DEPOSIT_RULE, WITH_OR_WITHOUT_PAYMENT, BILL_SUPPLIER_NAME, out strMessage ); response.Data = Utility.Utility_Component.DtToJSon(dt, "Scheduled Payment"); if (dt.Rows.Count > 0) { response.Status = 1; response.Message = "Success"; } else { if (strMessage == "") { response.Status = 1; response.Message = "There has no data to display."; } else { response.Status = 0; response.Message = strMessage; } } return(response); } catch (Exception ex) { response.Status = 0; response.Message = ex.Message + "\n" + ex.StackTrace; return(response); } }
public ControllerApplicationApproval(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public MetaResponse Approve(string COMPANY_NO_BOX, int REQ_TYPE, string REQ_TYPE_RAW, string CHANGED_ITEMS, string SYSTEM_EFFECTIVE_DATE, string SYSTEM_REGIST_DEADLINE, string List) { try { DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } string EMIAL_SENDING_TARGET_FLG = row["MAIL_SENDING_TARGET_FLG"].ToString().Trim(); string MAIL_DESTINATION = row["MAIL_DESTINATION"].ToString().Trim(); int TRANSACTION_TYPE = getTRANSACTION_TYPE(row["TRANSACTION_TYPE"].ToString().Trim()); DateTime START_USE_DATE = Convert.ToDateTime(row["START_USE_DATE"].ToString().Trim()); using (TransactionScope dbTxn = new TransactionScope()) { #region Approve BOL_REQUEST_DETAIL oREQUEST_DETAIL = new BOL_REQUEST_DETAIL(); oREQUEST_DETAIL.COMPANY_NO_BOX = COMPANY_NO_BOX; oREQUEST_DETAIL.REQ_STATUS = 2; if (REQ_TYPE == 1 || REQ_TYPE == 9 || (REQ_TYPE == 2 && !string.IsNullOrEmpty(CHANGED_ITEMS.Trim()))) { oREQUEST_DETAIL.AMIGO_COOPERATION = 1; } else { oREQUEST_DETAIL.AMIGO_COOPERATION = 2; } oREQUEST_DETAIL.AMIGO_COOPERATION_CHENGED_ITEMS = CHANGED_ITEMS.Trim(); try { oREQUEST_DETAIL.SYSTEM_EFFECTIVE_DATE = Convert.ToDateTime(SYSTEM_EFFECTIVE_DATE); } catch (Exception) { } try { oREQUEST_DETAIL.SYSTEM_REGIST_DEADLINE = Convert.ToDateTime(SYSTEM_REGIST_DEADLINE); } catch (Exception) { } oREQUEST_DETAIL.REQ_SEQ = int.Parse(row["REQ_SEQ"].ToString()); if (MAIL_DESTINATION == "1") { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 1; } else { oREQUEST_DETAIL.SYSTEM_SETTING_STATUS = 0; } oREQUEST_DETAIL.UPDATED_AT = row["UPDATED_AT_RAW"].ToString(); string msg = ""; REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); DAL_REQUEST_DETAIL.Approve(oREQUEST_DETAIL, CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion if (EMIAL_SENDING_TARGET_FLG == "*" && TRANSACTION_TYPE == 3) { DataTable LatestCustomer = new DataTable(); CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); if (REQ_TYPE == 2 || REQ_TYPE == 9) { LatestCustomer = DAL_CUSTOMER_MASTER.GetTopCustomerByKeys(oREQUEST_DETAIL.COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg); } #region CONDUCT NEW CUSTOMER MASTER BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); if (LatestCustomer.Rows.Count > 0 && REQ_TYPE != 1) { oCUSTOMER_MASTER = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); } oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.TRANSACTION_TYPE = TRANSACTION_TYPE; oCUSTOMER_MASTER.EFFECTIVE_DATE = START_USE_DATE; oCUSTOMER_MASTER.REQ_SEQ = oREQUEST_DETAIL.REQ_SEQ; oCUSTOMER_MASTER.UPDATE_CONTENT = REQ_TYPE; DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } DAL_CUSTOMER_MASTER.Insert(oCUSTOMER_MASTER, CURRENT_DATETIME, CURRENT_USER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion string CONTRACT_PLAN = row["CONTRACT_PLAN_RAW"].ToString().ToString(); if (CONTRACT_PLAN == "PRODUCT" && REQ_TYPE == 9) { //get latest customer for new applying time DateTime NEW_EFFECTIVE_DATE = Convert.ToDateTime(DAL_CUSTOMER_MASTER.GetEffectiveDateForNewApplyingTime(oREQUEST_DETAIL.COMPANY_NO_BOX, TRANSACTION_TYPE, START_USE_DATE, out msg)); if ((NEW_EFFECTIVE_DATE.Month + NEW_EFFECTIVE_DATE.Day) != (START_USE_DATE.Month + START_USE_DATE.Day)) { #region Insert Browsing CUSTOMER MASTER BOL_CUSTOMER_MASTER oCUSTOMER_MASTER_BROWSING = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER_BROWSING = Cast_CUSTOMER_MASTER(LatestCustomer.Rows[0]); oCUSTOMER_MASTER_BROWSING.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER_BROWSING.TRANSACTION_TYPE = TRANSACTION_TYPE; oCUSTOMER_MASTER_BROWSING.EFFECTIVE_DATE = Convert.ToDateTime(START_USE_DATE.Year + "/" + NEW_EFFECTIVE_DATE.Month + "/" + NEW_EFFECTIVE_DATE.Day); oCUSTOMER_MASTER_BROWSING.REQ_SEQ = oREQUEST_DETAIL.REQ_SEQ; oCUSTOMER_MASTER_BROWSING.UPDATE_CONTENT = REQ_TYPE; DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); DAL_CUSTOMER_MASTER.Insert(oCUSTOMER_MASTER_BROWSING, CURRENT_DATETIME, CURRENT_USER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } #endregion } } } DataTable dtMail = new DataTable(); bool mailSuccess = false; if (EMIAL_SENDING_TARGET_FLG == "*" && MAIL_DESTINATION == "1") { mailSuccess = SendMailToMaintenance(COMPANY_NO_BOX, REQ_TYPE_RAW, row["COMPANY_NAME"].ToString(), CHANGED_ITEMS, SYSTEM_REGIST_DEADLINE, out dtMail); if (mailSuccess) { dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } else if (EMIAL_SENDING_TARGET_FLG == "*" && MAIL_DESTINATION == "2") { mailSuccess = SendMailToSupplier(row["COMPANY_NAME"].ToString(), row["INPUT_PERSON"].ToString(), row["INPUT_PERSON_EMAIL_ADDRESS"].ToString(), out dtMail); if (mailSuccess) { dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } else { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } } dbTxn.Complete(); return(SetSuccessMessage(row, Listing, dtMail, ds)); } } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
public MetaResponse ApproveCancel(string COMPANY_NO_BOX, string REQ_SEQ, string List) { try { string msg = ""; DataSet ds = new DataSet(); DataTable Listing = Utility_Component.JsonToDt(List); DataRow row; if (Listing.Rows.Count > 1) { row = Listing.Rows[1]; } else { row = Listing.Rows[0]; } REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con); //serch with COMPANY_NO_BOX AND REQ_SEQ DataTable APPROVAL_CHECK = DAL_REQUEST_DETAIL.GetDataToCheckApproveCancel(COMPANY_NO_BOX, REQ_SEQ, out msg); //IF QUOTATION DATE NOT NULL THEN ERROR if (!string.IsNullOrEmpty(APPROVAL_CHECK.Rows[0]["QUOTATION_DATE"].ToString())) { return(ResponseError(response, Utility.Messages.Jimugo.E000ZZ037, Listing, ds, row)); } //IF SYSTEM_SETTING_STATUS NOT NULL THEN ERROR if (APPROVAL_CHECK.Rows[0]["SYSTEM_SETTING_STATUS"].ToString() != "0") { return(ResponseError(response, Utility.Messages.Jimugo.E000WB015, Listing, ds, row)); } DAL_REQUEST_DETAIL.ApproveCancel(COMPANY_NO_BOX, row["REQ_SEQ"].ToString(), CURRENT_USER, CURRENT_DATETIME, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } CUSTOMER_MASTER DAL_CUSTOMER_MASTER = new CUSTOMER_MASTER(con); BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER.COMPANY_NO_BOX = COMPANY_NO_BOX; oCUSTOMER_MASTER.REQ_SEQ = Convert.ToInt32(row["REQ_SEQ"]); DAL_CUSTOMER_MASTER.Delete(oCUSTOMER_MASTER, out msg); if (!string.IsNullOrEmpty(msg)) { return(ResponseError(response, Utility.Messages.Jimugo.I000ZZ005, Listing, ds, row)); } else { response.Status = 1; row["UPDATE_MESSAGE"] = string.Format(Messages.Jimugo.I000ZZ016, "承認解除"); Listing.TableName = "LISTING"; ds.Tables.Add(Listing.Copy()); } response.Data = Utility.Utility_Component.DsToJSon(ds, "Approval"); timer.Stop(); response.Meta.Duration = timer.Elapsed.TotalSeconds; return(response); } catch (Exception ex) { return(ResponseUtility.GetUnexpectedResponse(response, timer, ex)); } }
private BOL_CUSTOMER_MASTER Cast_CUSTOMER_MASTER(DataRow row) { BOL_CUSTOMER_MASTER oCUSTOMER_MASTER = new BOL_CUSTOMER_MASTER(); oCUSTOMER_MASTER.COMPANY_NO_BOX = row["COMPANY_NO_BOX"].ToString().Trim(); string transaction_type = row["TRANSACTION_TYPE"].ToString().Trim(); switch (transaction_type) { case "要元": oCUSTOMER_MASTER.TRANSACTION_TYPE = 1; break; case "サプライヤ": oCUSTOMER_MASTER.TRANSACTION_TYPE = 2; break; case "納代": oCUSTOMER_MASTER.TRANSACTION_TYPE = 3; break; case "生産情報閲覧": oCUSTOMER_MASTER.TRANSACTION_TYPE = 4; break; case "SI": oCUSTOMER_MASTER.TRANSACTION_TYPE = 11; break; case "SOL": oCUSTOMER_MASTER.TRANSACTION_TYPE = 12; break; case "その他": oCUSTOMER_MASTER.TRANSACTION_TYPE = 19; break; } oCUSTOMER_MASTER.EFFECTIVE_DATE = (DateTime)Utility_Component.dtColumnToDateTime(row["EFFECTIVE_DATE"].ToString().Trim()); oCUSTOMER_MASTER.ORG_EFFECTIVE_DATE = Utility_Component.dtColumnToDateTime(row["ORG_EFFECTIVE_DATE"].ToString().Trim()); oCUSTOMER_MASTER.CONTRACT_DATE = Utility_Component.dtColumnToDateTime(row["CONTRACT_DATE"].ToString().Trim()); oCUSTOMER_MASTER.SPECIAL_NOTES_1 = row["SPECIAL_NOTES_1"].ToString().Trim(); oCUSTOMER_MASTER.SPECIAL_NOTES_2 = row["SPECIAL_NOTES_2"].ToString().Trim(); oCUSTOMER_MASTER.SPECIAL_NOTES_3 = row["SPECIAL_NOTES_3"].ToString().Trim(); oCUSTOMER_MASTER.SPECIAL_NOTES_4 = row["SPECIAL_NOTES_4"].ToString().Trim(); oCUSTOMER_MASTER.NCS_CUSTOMER_CODE = row["NCS_CUSTOMER_CODE"].ToString().Trim(); string billingInterval = row["BILL_BILLING_INTERVAL"].ToString(); switch (billingInterval) { case "月額": oCUSTOMER_MASTER.BILL_BILLING_INTERVAL = 1; break; case "四半期": oCUSTOMER_MASTER.BILL_BILLING_INTERVAL = 2; break; case "半期": oCUSTOMER_MASTER.BILL_BILLING_INTERVAL = 3; break; case "年額": oCUSTOMER_MASTER.BILL_BILLING_INTERVAL = 4; break; } string deposit_Rules = row["BILL_DEPOSIT_RULES"].ToString(); switch (deposit_Rules) { case "翌月": oCUSTOMER_MASTER.BILL_DEPOSIT_RULES = 0; break; case "当月": oCUSTOMER_MASTER.BILL_DEPOSIT_RULES = 1; break; case "翌々月月頭": oCUSTOMER_MASTER.BILL_DEPOSIT_RULES = 2; break; } oCUSTOMER_MASTER.BILL_TRANSFER_FEE = Utility_Component.dtColumnToDecimal(row["BILL_TRANSFER_FEE"].ToString()); oCUSTOMER_MASTER.BILL_EXPENSES = Utility_Component.dtColumnToDecimal(row["BILL_EXPENSES"].ToString()); oCUSTOMER_MASTER.COMPANY_NAME_CHANGED_DATE = Utility_Component.dtColumnToDateTime(row["COMPANY_NAME_CHANGED_DATE"].ToString()); oCUSTOMER_MASTER.PREVIOUS_COMPANY_NAME = row["PREVIOUS_COMPANY_NAME"].ToString(); oCUSTOMER_MASTER.OBOEGAKI_DATE = Utility_Component.dtColumnToDateTime(row["OBOEGAKI_DATE"].ToString()); oCUSTOMER_MASTER.UPDATED_AT = row["UPDATED_AT"].ToString().Length >= 1 ? row["UPDATED_AT"].ToString() : null; oCUSTOMER_MASTER.UPDATED_AT_RAW = row["UPDATED_AT_RAW"].ToString() == "" ? null : row["UPDATED_AT_RAW"].ToString(); oCUSTOMER_MASTER.UPDATED_BY = row["UPDATED_BY"].ToString().Length >= 1 ? row["UPDATED_BY"].ToString() : null; oCUSTOMER_MASTER.REQ_SEQ = Utility_Component.dtColumnToInt(row["REQ_SEQ"].ToString()); return(oCUSTOMER_MASTER); }
public Controller38(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public ControllerCustomerMasterMaintenance(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }
public ControllerMonthlySaleComparisonList(string authHeader) : this() { CURRENT_USER = Utility_Component.DecodeAuthHeader(authHeader)[0]; }