private OldPackageSold setPackageSold1(OldPackageSold stf1)
{
stf1.PCKSID = "";
stf1.PID = "";
stf1.SellThruID = "";
stf1.PCKID = "";
stf1.PackageName = "";
stf1.Price = "";
stf1.Date = "";
stf1.PaymentTimes = "";
stf1.Status = "";
stf1.Payment1 = "";
stf1.Payment2 = "";
stf1.Payment3 = "";
stf1.Payment4 = "";
stf1.P1BDetailID = "";
stf1.P2BDetailID = "";
stf1.P3BDetailID = "";
stf1.P4BDetailID = "";
stf1.VN = "";
stf1.row1 = "";
stf1.payment_times = "";
stf1.payment_name = "";
stf1.paymentperiod = "";
return(stf1);
}
private void chkNull(OldPackageSold p)
{
decimal chk = 0;
long chk1 = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.PackageName = p.PackageName == null ? "" : p.PackageName;
p.Date = p.Date == null ? "" : p.Date;
p.Status = p.Status == null ? "0" : p.Status;
p.payment_times = p.payment_times == null ? "" : p.payment_times;
p.status_package = p.status_package == null ? "0" : p.status_package;
p.PID = long.TryParse(p.PID, out chk1) ? chk1.ToString() : "0";
p.SellThruID = long.TryParse(p.SellThruID, out chk1) ? chk1.ToString() : "0";
p.PCKID = long.TryParse(p.PCKID, out chk1) ? chk1.ToString() : "0";
p.PaymentTimes = long.TryParse(p.PaymentTimes, out chk1) ? chk1.ToString() : "0";
p.P1BDetailID = long.TryParse(p.P1BDetailID, out chk1) ? chk1.ToString() : "0";
p.P2BDetailID = long.TryParse(p.P2BDetailID, out chk1) ? chk1.ToString() : "0";
p.P3BDetailID = long.TryParse(p.P3BDetailID, out chk1) ? chk1.ToString() : "0";
p.P4BDetailID = long.TryParse(p.P4BDetailID, out chk1) ? chk1.ToString() : "0";
p.VN = long.TryParse(p.VN, out chk1) ? chk1.ToString() : "0";
p.row1 = long.TryParse(p.row1, out chk1) ? chk1.ToString() : "0";
p.Price = decimal.TryParse(p.Price, out chk) ? chk.ToString() : "0";
p.Payment1 = decimal.TryParse(p.Payment1, out chk) ? chk.ToString() : "0";
p.Payment2 = decimal.TryParse(p.Payment2, out chk) ? chk.ToString() : "0";
p.Payment3 = decimal.TryParse(p.Payment3, out chk) ? chk.ToString() : "0";
p.Payment4 = decimal.TryParse(p.Payment4, out chk) ? chk.ToString() : "0";
}
public OldPackageSold setPackageSold(DataTable dt)
{
OldPackageSold opkgs1 = new OldPackageSold();
if (dt.Rows.Count > 0)
{
opkgs1.PCKSID = dt.Rows[0][opkgs.PCKSID].ToString();
opkgs1.PID = dt.Rows[0][opkgs.PID].ToString();
opkgs1.SellThruID = dt.Rows[0][opkgs.SellThruID].ToString();
opkgs1.PCKID = dt.Rows[0][opkgs.PCKID].ToString();
opkgs1.PackageName = dt.Rows[0][opkgs.PackageName].ToString();
opkgs1.Price = dt.Rows[0][opkgs.Price].ToString();
opkgs1.Date = dt.Rows[0][opkgs.Date].ToString();
opkgs1.PaymentTimes = dt.Rows[0][opkgs.PaymentTimes].ToString();
opkgs1.Status = dt.Rows[0][opkgs.Status].ToString();
opkgs1.Payment1 = dt.Rows[0][opkgs.Payment1].ToString();
opkgs1.Payment2 = dt.Rows[0][opkgs.Payment2].ToString();
opkgs1.Payment3 = dt.Rows[0][opkgs.Payment3].ToString();
opkgs1.Payment4 = dt.Rows[0][opkgs.Payment4].ToString();
opkgs1.P1BDetailID = dt.Rows[0][opkgs.P1BDetailID].ToString();
opkgs1.P2BDetailID = dt.Rows[0][opkgs.P2BDetailID].ToString();
opkgs1.P3BDetailID = dt.Rows[0][opkgs.P3BDetailID].ToString();
opkgs1.P4BDetailID = dt.Rows[0][opkgs.P4BDetailID].ToString();
opkgs1.VN = dt.Rows[0][opkgs.VN].ToString();
opkgs1.row1 = dt.Rows[0][opkgs.row1].ToString();
opkgs1.payment_times = dt.Rows[0][opkgs.payment_times].ToString();
opkgs1.payment_name = "";
opkgs1.paymentperiod = "";
}
else
{
setPackageSold1(opkgs1);
}
return(opkgs1);
}
private void initConfig()
{
opkgs = new OldPackageSold();
opkgs.PCKSID = "PCKSID";
opkgs.PID = "PID";
opkgs.SellThruID = "SellThruID";
opkgs.PCKID = "PCKID";
opkgs.PackageName = "PackageName";
opkgs.Price = "Price";
opkgs.Date = "Date";
opkgs.PaymentTimes = "PaymentTimes";
opkgs.Status = "Status";
opkgs.Payment1 = "Payment1";
opkgs.Payment2 = "Payment2";
opkgs.Payment3 = "Payment3";
opkgs.Payment4 = "Payment4";
opkgs.P1BDetailID = "P1BDetailID";
opkgs.P2BDetailID = "P2BDetailID";
opkgs.P3BDetailID = "P3BDetailID";
opkgs.P4BDetailID = "P4BDetailID";
opkgs.VN = "VN";
opkgs.row1 = "row1";
opkgs.payment_times = "payment_times";
opkgs.payment_name = "";
opkgs.paymentperiod = "";
opkgs.status_package = "status_package";
opkgs.table = "PackageSold";
opkgs.pkField = "PCKSID";
}
public OldPackageSold selectByPID1(String pttId, String pkgsid)
{
OldPackageSold labi1 = new OldPackageSold();
DataTable dt = new DataTable();
String sql = "select opkgs.* " +
"From " + opkgs.table + " opkgs " +
"Where opkgs." + opkgs.PID + " ='" + pttId + "' and opkgs." + opkgs.PCKID + "='" + pkgsid + "' and Status <> 3 ";
dt = conn.selectData(conn.conn, sql);
labi1 = setPackageSold(dt);
return(labi1);
}
public OldPackageSold selectByPk1(String pttId)
{
OldPackageSold labi1 = new OldPackageSold();
DataTable dt = new DataTable();
String sql = "select opkgs.* " +
"From " + opkgs.table + " opkgs " +
"Where opkgs." + opkgs.pkField + " ='" + pttId + "' ";
dt = conn.selectData(conn.conn, sql);
labi1 = setPackageSold(dt);
return(labi1);
}
public OldPackageSold selectByVN2(String vn)
{
OldPackageSold labi1 = new OldPackageSold();
DataTable dt = new DataTable();
Decimal pay1 = 0, pay2 = 0, pay3 = 0, pay4 = 0;
String sql = "select opkgs.* " +
"From " + opkgs.table + " opkgs " +
"Where opkgs." + opkgs.VN + " ='" + vn + "' ";
dt = conn.selectData(conn.conn, sql);
labi1 = setPackageSold(dt);
return(labi1);
}
public String insert(OldPackageSold p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
//lbReq.form_a_id = "form_a_id";
//p.req_code = genReqDoc();
sql = "Insert Into " + opkgs.table + " Set " +
" " + opkgs.PID + " = '" + p.PID + "'" +
"," + opkgs.SellThruID + "= '" + p.SellThruID + "'" +
"," + opkgs.PCKID + "= '" + p.PCKID + "'" +
"," + opkgs.PackageName + "= '" + p.PackageName.Replace("'", "''") + "'" +
"," + opkgs.Price + "= '" + p.Price.Replace("'", "''") + "'" +
"," + opkgs.Date + "= now()" +
"," + opkgs.PaymentTimes + "= '" + p.PaymentTimes + "'" +
"," + opkgs.Status + "= '" + p.Status + "'" +
"," + opkgs.Payment1 + "= '" + p.Payment1 + "'" +
"," + opkgs.Payment2 + "= '" + p.Payment2 + "'" +
"," + opkgs.Payment3 + "= '" + p.Payment3 + "'" +
"," + opkgs.Payment4 + "= '" + p.Payment4 + "'" +
"," + opkgs.P1BDetailID + "= '" + p.P1BDetailID + "'" +
"," + opkgs.P2BDetailID + "= '" + p.P2BDetailID + "'" +
"," + opkgs.P3BDetailID + "= '" + p.P3BDetailID + "'" +
"," + opkgs.P4BDetailID + "= '" + p.P4BDetailID + "'" +
"," + opkgs.VN + "= '" + p.VN + "'" +
"," + opkgs.row1 + "= '" + p.row1 + "'" +
"," + opkgs.payment_times + "= '" + p.PaymentTimes + "'" +
"," + opkgs.status_package + "= '1'" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public OldPackageSold selectPeriodByVN(String vn)
{
OldPackageSold labi1 = new OldPackageSold();
DataTable dt = new DataTable();
Decimal pay1 = 0, pay2 = 0, pay3 = 0, pay4 = 0;
String sql = "select opkgs.* " +
"From " + opkgs.table + " opkgs " +
"Where opkgs." + opkgs.VN + " ='" + vn + "' and Status<>3 ";
dt = conn.selectData(conn.conn, sql);
labi1 = setPackageSold(dt);
if (labi1.Status.Equals("1"))
{
Decimal.TryParse(labi1.Payment1, out pay1);
if (labi1.P1BDetailID.Equals("") && (pay1 > 0))
{
//opkgs1.payment_name = "";
//opkgs1.paymentperiod = "";
}
}
return(labi1);
}
