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();
}
public void TestMethod1()
{
DateTime? expireDate;
PaymentService paymentService = new PaymentService();
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH");
var LicenseNo = GenLicenseNumber.AG_LICENSE_RUNNING(ctx, Convert.ToDateTime("22/10/2013"), "04");
string aaa = LicenseNo.ToString();
if ("18/10/2013".ToString().Substring(0, 4) == "2902")
{
expireDate = Convert.ToDateTime("22/10/2013".ToString()).AddMonths(12);
}
else
{
expireDate = Convert.ToDateTime("22/10/2013".ToString()).AddMonths(12).AddDays(-1);
}
var License = new DAL.AG_LICENSE_T
{
LICENSE_NO = LicenseNo.ToString(),
LICENSE_DATE = Convert.ToDateTime("22/10/2013"),
EXPIRE_DATE = Convert.ToDateTime(Convert.ToString(expireDate)),
LICENSE_TYPE_CODE = "04",
NEW_LICENSE_NO = null,
LICENSE_ACTOR = null,
DATE_LICENSE_ACT = Convert.ToDateTime("22/10/2013"),
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.SingleOrDefault(a => a.SEQ_NO == "0001" &&
a.UPLOAD_GROUP_NO == "131022094549687");
entLicenseD.LICENSE_NO = LicenseNo;
var entSubpaymentD = ctx.AG_IAS_SUBPAYMENT_D_T.SingleOrDefault(a => a.SEQ_NO == "0001" &&
a.UPLOAD_GROUP_NO == "131022094549687");
entSubpaymentD.LICENSE_NO = LicenseNo;
ctx.SaveChanges();
//using (OracleConnection objConn = new OracleConnection(DBConnection.GetConnectionString))
//{
// OracleCommand objCmd = new OracleCommand();
// objCmd.Connection = objConn;
// objCmd.CommandText = "IAS_UPDATE_11";
// objCmd.CommandType = CommandType.StoredProcedure;
// objCmd.Parameters.Add("P_id_card_no", OracleDbType.Varchar2).Value = "6239694333650";
// objCmd.Parameters.Add("P_license_type_code", OracleDbType.Varchar2).Value = "04";
// objCmd.Parameters.Add("P_license_no", OracleDbType.Varchar2).Value = "5601023392";
// objCmd.Parameters.Add("COMP_CODE", OracleDbType.Varchar2).Value = "3139";
// objCmd.Parameters.Add("P_RECEIPT_DATE", OracleDbType.Date).Value = Convert.ToDateTime("11/10/2013");
// objCmd.Parameters.Add("P_REQUEST_NO", OracleDbType.Varchar2).Value = "";
// objCmd.Parameters.Add("P_PAYMENT_NO", OracleDbType.Varchar2).Value = "0001";
// // รอการjoin data from ag_applicant_t
// // objCmd.Parameters.Add("P_testing_no", OracleDbType.Varchar2).Value = dt.Rows[i]["testing_no"].ToString();
// objCmd.Parameters.Add("P_RECEIPT_NO", OracleDbType.Varchar2).Value = "12122e41300027";
// try
// {
// objConn.Open();
// objCmd.ExecuteNonQuery();
// //if (objCmd.ExecuteNonQuery() == -1)
// //{
// // res.ResultMessage = false;
// //}
// //else
// //{
// // res.ResultMessage = true;
// //}
// }
// catch (Exception ex)
// {
// throw new ArgumentException(ex.Message);
// }
// finally
// {
// objConn.Close();
// }
}
