public static void LicensePetitionType(IAS.DAL.Interfaces.IIASPersonEntities ctx, OracleConnection Connection, LicensePetitionType15Request licenseRequest) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH"); string LicenseNo = GenLicenseNumber.AG_LICENSE_RUNNING(ctx, licenseRequest.RECEIPT_DATE, licenseRequest.LICENSE_TYPE_CODE); var License = new DAL.AG_LICENSE_T { LICENSE_NO = LicenseNo, LICENSE_DATE = licenseRequest.RECEIPT_DATE, // Convert.ToDateTime(ReceiveDate), EXPIRE_DATE = licenseRequest.EXPIRATION_DATE, // Convert.ToDateTime(Convert.ToString(expireDate)), LICENSE_TYPE_CODE = licenseRequest.LICENSE_TYPE_CODE, // licenseT, NEW_LICENSE_NO = null, LICENSE_ACTOR = null, DATE_LICENSE_ACT = licenseRequest.RECEIPT_DATE, // Convert.ToDateTime(ReceiveDate), REMARK = null, UNIT_LINK_RENEW = null, START_UL_DATE = null, EXPIRE_UL_DATE = null, UNIT_LINK_STATUS = null }; ctx.AG_LICENSE_T.AddObject(License); var entLicenseD = ctx.AG_IAS_LICENSE_D.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); entLicenseD.LICENSE_NO = LicenseNo; entLicenseD.LICENSE_DATE = DateTime.Now; entLicenseD.LICENSE_EXPIRE_DATE = licenseRequest.EXPIRATION_DATE; // Convert.ToDateTime(Convert.ToString(expireDate)); var entSubpaymentD = ctx.AG_IAS_SUBPAYMENT_D_T.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); //string OldLicense = entSubpaymentD.LICENSE_NO.ToString(); entSubpaymentD.OLD_LICENSE_NO = entSubpaymentD.LICENSE_NO; entSubpaymentD.LICENSE_NO = LicenseNo; OracleCommand objCmd = new OracleCommand() { Connection = Connection, CommandText = "IAS_UPDATE_15", CommandType = CommandType.StoredProcedure }; objCmd.Parameters.Add("P_ID_CARD_NO", OracleDbType.Varchar2).Value = licenseRequest.ID_CARD_NO; objCmd.Parameters.Add("P_LICENSE_TYPE_CODE", OracleDbType.Varchar2).Value = licenseRequest.LICENSE_TYPE_CODE; objCmd.Parameters.Add("P_LICENSE_NO", OracleDbType.Varchar2).Value = LicenseNo; objCmd.Parameters.Add("P_COMP_CODE", OracleDbType.Varchar2).Value = licenseRequest.COMP_CODE; objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = licenseRequest.RECEIPT_NO; // requestNo; objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = licenseRequest.PAYMENT_NO; // payment_no; objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = licenseRequest.RECEIPT_NO; // receiptNo; objCmd.ExecuteNonQuery(); }
public static void LicensePetitionType(IAS.DAL.Interfaces.IIASPersonEntities ctx, OracleConnection Connection, LicensePetitionType11Request licenseRequest) { Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH"); String LicenseNo = GenLicenseNumber.AG_LICENSE_RUNNING(ctx, (DateTime)licenseRequest.RECEIPT_DATE, licenseRequest.LICENSE_TYPE_CODE); // Convert.ToDateTime(dt.Rows[i]["receipt_date"]), dt.Rows[i]["license_type_code"].ToString()); var License = new DAL.AG_LICENSE_T { LICENSE_NO = LicenseNo, LICENSE_DATE = licenseRequest.RECEIPT_DATE, EXPIRE_DATE = licenseRequest.EXPIRATION_DATE, LICENSE_TYPE_CODE = licenseRequest.LICENSE_TYPE_CODE, NEW_LICENSE_NO = null, LICENSE_ACTOR = null, DATE_LICENSE_ACT = licenseRequest.RECEIPT_DATE, REMARK = null, UNIT_LINK_RENEW = null, START_UL_DATE = null, EXPIRE_UL_DATE = null, UNIT_LINK_STATUS = null }; ctx.AG_LICENSE_T.AddObject(License); //Check Null AG_IAS_LICENSE_D entLicenseD = ctx.AG_IAS_LICENSE_D.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); if (entLicenseD != null) { entLicenseD.LICENSE_NO = LicenseNo; entLicenseD.LICENSE_DATE = DateTime.Now; entLicenseD.LICENSE_EXPIRE_DATE = licenseRequest.EXPIRATION_DATE; } //Check Null AG_IAS_SUBPAYMENT_D_T entSubpaymentD = ctx.AG_IAS_SUBPAYMENT_D_T.FirstOrDefault(a => a.SEQ_NO == licenseRequest.SEQ_NO && a.UPLOAD_GROUP_NO == licenseRequest.UPLOAD_GROUP_NO); if (entSubpaymentD != null) { entSubpaymentD.LICENSE_NO = LicenseNo; } OracleCommand objCmd = new OracleCommand() { Connection = Connection, CommandText = "IAS_UPDATE_11", CommandType = CommandType.StoredProcedure }; objCmd.Parameters.Add("P_id_card_no", OracleDbType.Varchar2).Value = SetValue(licenseRequest.ID_CARD_NO); objCmd.Parameters.Add("P_license_type_code", OracleDbType.Varchar2).Value = SetValue(licenseRequest.LICENSE_TYPE_CODE); objCmd.Parameters.Add("P_license_no", OracleDbType.Varchar2).Value = SetValue(LicenseNo); objCmd.Parameters.Add("COMP_CODE", OracleDbType.Varchar2).Value = SetValue(licenseRequest.COMP_CODE); objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = licenseRequest.RECEIPT_DATE; objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = SetValue(entLicenseD.REQUEST_NO); objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = SetValue(licenseRequest.PAYMENT_NO); objCmd.Parameters.Add("P_testing_no", OracleDbType.Varchar2).Value = SetValue(licenseRequest.TESTING_NO); objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = SetValue(licenseRequest.RECEIPT_NO); objCmd.ExecuteNonQuery(); }