private void LoadRecord()
{
ERPConfig clsERPConfig = new ERPConfig();
APLinkConfigDetails clsDetails = clsERPConfig.APLinkDetails();
clsERPConfig.CommitAndDispose();
cboChartOfAccountAPTracking.SelectedIndex = cboChartOfAccountAPTracking.Items.IndexOf(cboChartOfAccountAPTracking.Items.FindByValue(clsDetails.ChartOfAccountIDAPTracking.ToString()));
cboChartOfAccountAPBills.SelectedIndex = cboChartOfAccountAPBills.Items.IndexOf(cboChartOfAccountAPBills.Items.FindByValue(clsDetails.ChartOfAccountIDAPBills.ToString()));
cboChartOfAccountAPFreight.SelectedIndex = cboChartOfAccountAPFreight.Items.IndexOf(cboChartOfAccountAPFreight.Items.FindByValue(clsDetails.ChartOfAccountIDAPFreight.ToString()));
cboChartOfAccountAPVDeposit.SelectedIndex = cboChartOfAccountAPVDeposit.Items.IndexOf(cboChartOfAccountAPVDeposit.Items.FindByValue(clsDetails.ChartOfAccountIDAPVDeposit.ToString()));
cboChartOfAccountAPContra.SelectedIndex = cboChartOfAccountAPContra.Items.IndexOf(cboChartOfAccountAPContra.Items.FindByValue(clsDetails.ChartOfAccountIDAPContra.ToString()));
cboChartOfAccountAPLatePayment.SelectedIndex = cboChartOfAccountAPLatePayment.Items.IndexOf(cboChartOfAccountAPLatePayment.Items.FindByValue(clsDetails.ChartOfAccountIDAPLatePayment.ToString()));
}
public void Update(DebitMemoDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails();
string SQL = "UPDATE tblPODebitMemo SET " +
"MemoNo = @MemoNo, " +
"MemoDate = @MemoDate, " +
"SupplierID = @SupplierID, " +
"SupplierCode = @SupplierCode, " +
"SupplierContact = @SupplierContact, " +
"SupplierAddress = @SupplierAddress, " +
"SupplierTelephoneNo = @SupplierTelephoneNo, " +
"SupplierModeOfTerms = @SupplierModeOfTerms, " +
"SupplierTerms = @SupplierTerms, " +
"RequiredPostingDate = @RequiredPostingDate, " +
"BranchID = @BranchID, " +
"PurchaserID = @PurchaserID, " +
"PurchaserName = @PurchaserName, " +
"Remarks = @Remarks, " +
"ChartOfAccountIDAPTracking = @ChartOfAccountIDAPTracking, " +
"ChartOfAccountIDAPBills = @ChartOfAccountIDAPBills, " +
"ChartOfAccountIDAPFreight = @ChartOfAccountIDAPFreight, " +
"ChartOfAccountIDAPVDeposit = @ChartOfAccountIDAPVDeposit, " +
"ChartOfAccountIDAPContra = @ChartOfAccountIDAPContra, " +
"ChartOfAccountIDAPLatePayment = @ChartOfAccountIDAPLatePayment " +
"WHERE DebitMemoID = @DebitMemoID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@MemoNo", Details.MemoNo);
cmd.Parameters.AddWithValue("@MemoDate", Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("@SupplierCode", Details.SupplierCode);
cmd.Parameters.AddWithValue("@SupplierContact", Details.SupplierContact);
cmd.Parameters.AddWithValue("@SupplierAddress", Details.SupplierAddress);
cmd.Parameters.AddWithValue("@SupplierTelephoneNo", Details.SupplierTelephoneNo);
cmd.Parameters.AddWithValue("@SupplierModeOfTerms", Details.SupplierModeOfTerms);
cmd.Parameters.AddWithValue("@SupplierTerms", Details.SupplierTerms);
cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("@PurchaserID", Details.PurchaserID);
cmd.Parameters.AddWithValue("@PurchaserName", Details.PurchaserName);
cmd.Parameters.AddWithValue("@POReturnStatus", POReturnStatus.Posted.ToString("d"));
cmd.Parameters.AddWithValue("@DebitMemoStatus", Details.DebitMemoStatus.ToString("d"));
cmd.Parameters.AddWithValue("@Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPTracking", clsAPLinkConfigDetails.ChartOfAccountIDAPTracking);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPBills", clsAPLinkConfigDetails.ChartOfAccountIDAPBills);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPFreight", clsAPLinkConfigDetails.ChartOfAccountIDAPFreight);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPVDeposit", clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPContra", clsAPLinkConfigDetails.ChartOfAccountIDAPContra);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPLatePayment", clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment);
cmd.Parameters.AddWithValue("@DebitMemoID", Details.DebitMemoID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public long Insert(DebitMemoDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails();
string SQL = "INSERT INTO tblPODebitMemo (" +
"MemoNo, " +
"MemoDate, " +
"SupplierID, " +
"SupplierCode, " +
"SupplierContact, " +
"SupplierAddress, " +
"SupplierTelephoneNo, " +
"SupplierModeOfTerms, " +
"SupplierTerms, " +
"RequiredPostingDate, " +
"BranchID, " +
"PurchaserID, " +
"PurchaserName, " +
"POReturnStatus, " +
"DebitMemoStatus, " +
"Remarks, " +
"ChartOfAccountIDAPTracking, " +
"ChartOfAccountIDAPBills, " +
"ChartOfAccountIDAPFreight, " +
"ChartOfAccountIDAPVDeposit, " +
"ChartOfAccountIDAPContra, " +
"ChartOfAccountIDAPLatePayment" +
") VALUES (" +
"@MemoNo, " +
"@MemoDate, " +
"@SupplierID, " +
"@SupplierCode, " +
"@SupplierContact, " +
"@SupplierAddress, " +
"@SupplierTelephoneNo, " +
"@SupplierModeOfTerms, " +
"@SupplierTerms, " +
"@RequiredPostingDate, " +
"@BranchID, " +
"@PurchaserID, " +
"@PurchaserName, " +
"@POReturnStatus, " +
"@DebitMemoStatus, " +
"@Remarks, " +
"@ChartOfAccountIDAPTracking, " +
"@ChartOfAccountIDAPBills, " +
"@ChartOfAccountIDAPFreight, " +
"@ChartOfAccountIDAPVDeposit, " +
"@ChartOfAccountIDAPContra, " +
"@ChartOfAccountIDAPLatePayment" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@MemoNo", Details.MemoNo);
cmd.Parameters.AddWithValue("@MemoDate", Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("@SupplierCode", Details.SupplierCode);
cmd.Parameters.AddWithValue("@SupplierContact", Details.SupplierContact);
cmd.Parameters.AddWithValue("@SupplierAddress", Details.SupplierAddress);
cmd.Parameters.AddWithValue("@SupplierTelephoneNo", Details.SupplierTelephoneNo);
cmd.Parameters.AddWithValue("@SupplierModeOfTerms", Details.SupplierModeOfTerms);
cmd.Parameters.AddWithValue("@SupplierTerms", Details.SupplierTerms);
cmd.Parameters.AddWithValue("@RequiredPostingDate", Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("@PurchaserID", Details.PurchaserID);
cmd.Parameters.AddWithValue("@PurchaserName", Details.PurchaserName);
cmd.Parameters.AddWithValue("@POReturnStatus", POReturnStatus.Posted.ToString("d"));
cmd.Parameters.AddWithValue("@DebitMemoStatus", Details.DebitMemoStatus.ToString("d"));
cmd.Parameters.AddWithValue("@Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPTracking", clsAPLinkConfigDetails.ChartOfAccountIDAPTracking);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPBills", clsAPLinkConfigDetails.ChartOfAccountIDAPBills);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPFreight", clsAPLinkConfigDetails.ChartOfAccountIDAPFreight);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPVDeposit", clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPContra", clsAPLinkConfigDetails.ChartOfAccountIDAPContra);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPLatePayment", clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(POReturnDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails();
string SQL= "UPDATE tblPODebitMemo SET " +
"MemoNo = @MemoNo, " +
"MemoDate = @MemoDate, " +
"SupplierID = @SupplierID, " +
"SupplierCode = @SupplierCode, " +
"SupplierContact = @SupplierContact, " +
"SupplierAddress = @SupplierAddress, " +
"SupplierTelephoneNo = @SupplierTelephoneNo, " +
"SupplierModeOfTerms = @SupplierModeOfTerms, " +
"SupplierTerms = @SupplierTerms, " +
"RequiredPostingDate = @RequiredPostingDate, " +
"BranchID = @BranchID, " +
"PurchaserID = @PurchaserID, " +
"PurchaserName = @PurchaserName, " +
"Remarks = @Remarks, " +
"ChartOfAccountIDAPTracking = @ChartOfAccountIDAPTracking, " +
"ChartOfAccountIDAPBills = @ChartOfAccountIDAPBills, " +
"ChartOfAccountIDAPFreight = @ChartOfAccountIDAPFreight, " +
"ChartOfAccountIDAPVDeposit = @ChartOfAccountIDAPVDeposit, " +
"ChartOfAccountIDAPContra = @ChartOfAccountIDAPContra, " +
"ChartOfAccountIDAPLatePayment = @ChartOfAccountIDAPLatePayment " +
"WHERE DebitMemoID = @DebitMemoID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmReturnNo = new MySqlParameter("@MemoNo",MySqlDbType.String);
prmReturnNo.Value = Details.MemoNo;
cmd.Parameters.Add(prmReturnNo);
MySqlParameter prmReturnDate = new MySqlParameter("@MemoDate",MySqlDbType.DateTime);
prmReturnDate.Value = Details.MemoDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmReturnDate);
MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64);
prmSupplierID.Value = Details.SupplierID;
cmd.Parameters.Add(prmSupplierID);
MySqlParameter prmSupplierCode = new MySqlParameter("@SupplierCode",MySqlDbType.String);
prmSupplierCode.Value = Details.SupplierCode;
cmd.Parameters.Add(prmSupplierCode);
MySqlParameter prmSupplierContact = new MySqlParameter("@SupplierContact",MySqlDbType.String);
prmSupplierContact.Value = Details.SupplierContact;
cmd.Parameters.Add(prmSupplierContact);
MySqlParameter prmSupplierAddress = new MySqlParameter("@SupplierAddress",MySqlDbType.String);
prmSupplierAddress.Value = Details.SupplierAddress;
cmd.Parameters.Add(prmSupplierAddress);
MySqlParameter prmSupplierTelephoneNo = new MySqlParameter("@SupplierTelephoneNo",MySqlDbType.String);
prmSupplierTelephoneNo.Value = Details.SupplierTelephoneNo;
cmd.Parameters.Add(prmSupplierTelephoneNo);
MySqlParameter prmSupplierModeOfTerms = new MySqlParameter("@SupplierModeOfTerms",MySqlDbType.Int16);
prmSupplierModeOfTerms.Value = Details.SupplierModeOfTerms;
cmd.Parameters.Add(prmSupplierModeOfTerms);
MySqlParameter prmSupplierTerms = new MySqlParameter("@SupplierTerms",MySqlDbType.Int16);
prmSupplierTerms.Value = Details.SupplierTerms;
cmd.Parameters.Add(prmSupplierTerms);
MySqlParameter prmRequiredPostingDate = new MySqlParameter("@RequiredPostingDate",MySqlDbType.DateTime);
prmRequiredPostingDate.Value = Details.RequiredPostingDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmRequiredPostingDate);
MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int16);
prmBranchID.Value = Details.BranchID;
cmd.Parameters.Add(prmBranchID);
MySqlParameter prmPurchaserID = new MySqlParameter("@PurchaserID",MySqlDbType.Int64);
prmPurchaserID.Value = Details.PurchaserID;
cmd.Parameters.Add(prmPurchaserID);
MySqlParameter prmPurchaserName = new MySqlParameter("@PurchaserName",MySqlDbType.String);
prmPurchaserName.Value = Details.PurchaserName;
cmd.Parameters.Add(prmPurchaserName);
MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String);
prmRemarks.Value = Details.Remarks;
cmd.Parameters.Add(prmRemarks);
MySqlParameter prmChartOfAccountIDAPTracking = new MySqlParameter("@ChartOfAccountIDAPTracking",MySqlDbType.Int32);
prmChartOfAccountIDAPTracking.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPTracking;
cmd.Parameters.Add(prmChartOfAccountIDAPTracking);
MySqlParameter prmChartOfAccountIDAPBills = new MySqlParameter("@ChartOfAccountIDAPBills",MySqlDbType.Int32);
prmChartOfAccountIDAPBills.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPBills;
cmd.Parameters.Add(prmChartOfAccountIDAPBills);
MySqlParameter prmChartOfAccountIDAPFreight = new MySqlParameter("@ChartOfAccountIDAPFreight",MySqlDbType.Int32);
prmChartOfAccountIDAPFreight.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPFreight;
cmd.Parameters.Add(prmChartOfAccountIDAPFreight);
MySqlParameter prmChartOfAccountIDAPVDeposit = new MySqlParameter("@ChartOfAccountIDAPVDeposit",MySqlDbType.Int32);
prmChartOfAccountIDAPVDeposit.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit;
cmd.Parameters.Add(prmChartOfAccountIDAPVDeposit);
MySqlParameter prmChartOfAccountIDAPContra = new MySqlParameter("@ChartOfAccountIDAPContra",MySqlDbType.Int32);
prmChartOfAccountIDAPContra.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPContra;
cmd.Parameters.Add(prmChartOfAccountIDAPContra);
MySqlParameter prmChartOfAccountIDAPLatePayment = new MySqlParameter("@ChartOfAccountIDAPLatePayment",MySqlDbType.Int32);
prmChartOfAccountIDAPLatePayment.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment;
cmd.Parameters.Add(prmChartOfAccountIDAPLatePayment);
MySqlParameter prmDebitMemoID = new MySqlParameter("@DebitMemoID",MySqlDbType.Int64);
prmDebitMemoID.Value = Details.DebitMemoID;
cmd.Parameters.Add(prmDebitMemoID);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public long Insert(PODetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "INSERT INTO tblPO (" +
"PONo, " +
"PODate, " +
"SupplierID, " +
"SupplierCode, " +
"SupplierContact, " +
"SupplierAddress, " +
"SupplierTelephoneNo, " +
"SupplierModeOfTerms, " +
"SupplierTerms, " +
"SupplierTINNo, " +
"SupplierLTONo, " +
"RequiredDeliveryDate, " +
"RID, " +
"BranchID, " +
"PurchaserID, " +
"PurchaserName, " +
"Status, " +
"Remarks, " +
"ChartOfAccountIDAPTracking, " +
"ChartOfAccountIDAPBills, " +
"ChartOfAccountIDAPFreight, " +
"ChartOfAccountIDAPVDeposit, " +
"ChartOfAccountIDAPContra, " +
"ChartOfAccountIDAPLatePayment, " +
"IncludeIneSales" +
") VALUES (" +
"@PONo, " +
"@PODate, " +
"@SupplierID, " +
"@SupplierCode, " +
"@SupplierContact, " +
"@SupplierAddress, " +
"@SupplierTelephoneNo, " +
"@SupplierModeOfTerms, " +
"@SupplierTerms, " +
"@SupplierTINNo, " +
"@SupplierLTONo, " +
"@RequiredDeliveryDate, " +
"@RID, " +
"@BranchID, " +
"@PurchaserID, " +
"@PurchaserName, " +
"@Status, " +
"@Remarks, " +
"@ChartOfAccountIDAPTracking, " +
"@ChartOfAccountIDAPBills, " +
"@ChartOfAccountIDAPFreight, " +
"@ChartOfAccountIDAPVDeposit, " +
"@ChartOfAccountIDAPContra, " +
"@ChartOfAccountIDAPLatePayment, " +
"@IncludeIneSales" +
");";
cmd.Parameters.AddWithValue("@PONo", Details.PONo);
cmd.Parameters.AddWithValue("@PODate", Details.PODate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("@SupplierCode", Details.SupplierCode);
cmd.Parameters.AddWithValue("@SupplierContact", Details.SupplierContact);
cmd.Parameters.AddWithValue("@SupplierAddress", Details.SupplierAddress);
cmd.Parameters.AddWithValue("@SupplierTelephoneNo", Details.SupplierTelephoneNo);
cmd.Parameters.AddWithValue("@SupplierModeOfTerms", Details.SupplierModeOfTerms);
cmd.Parameters.AddWithValue("@SupplierTerms", Details.SupplierTerms);
cmd.Parameters.AddWithValue("@SupplierTINNo", Details.SupplierTINNo);
cmd.Parameters.AddWithValue("@SupplierLTONo", Details.SupplierLTONo);
cmd.Parameters.AddWithValue("@RequiredDeliveryDate", Details.RequiredDeliveryDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@RID", Details.RID);
cmd.Parameters.AddWithValue("@BranchID", Details.BranchID);
cmd.Parameters.AddWithValue("@PurchaserID", Details.PurchaserID);
cmd.Parameters.AddWithValue("@PurchaserName", Details.PurchaserName);
cmd.Parameters.AddWithValue("@Status", Details.Status.ToString("d"));
cmd.Parameters.AddWithValue("@Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPTracking", clsAPLinkConfigDetails.ChartOfAccountIDAPTracking);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPBills", clsAPLinkConfigDetails.ChartOfAccountIDAPBills);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPFreight", clsAPLinkConfigDetails.ChartOfAccountIDAPFreight);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPVDeposit", clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPContra", clsAPLinkConfigDetails.ChartOfAccountIDAPContra);
cmd.Parameters.AddWithValue("@ChartOfAccountIDAPLatePayment", clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment);
cmd.Parameters.AddWithValue("@IncludeIneSales", Details.IncludeIneSales);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public long Insert(TransferInDetails Details)
{
try
{
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
APLinkConfigDetails clsAPLinkConfigDetails = clsERPConfig.APLinkDetails();
string SQL = "INSERT INTO tblTransferIn (" +
"TransferInNo, " +
"TransferInDate, " +
"SupplierID, " +
"SupplierCode, " +
"SupplierContact, " +
"SupplierAddress, " +
"SupplierTelephoneNo, " +
"SupplierModeOfTerms, " +
"SupplierTerms, " +
"RequiredDeliveryDate, " +
"BranchID, " +
"TransferrerID, " +
"TransferrerName, " +
"Status, " +
"Remarks, " +
"ChartOfAccountIDAPTracking, " +
"ChartOfAccountIDAPBills, " +
"ChartOfAccountIDAPFreight, " +
"ChartOfAccountIDAPVDeposit, " +
"ChartOfAccountIDAPContra, " +
"ChartOfAccountIDAPLatePayment" +
") VALUES (" +
"@TransferInNo, " +
"@TransferInDate, " +
"@SupplierID, " +
"@SupplierCode, " +
"@SupplierContact, " +
"@SupplierAddress, " +
"@SupplierTelephoneNo, " +
"@SupplierModeOfTerms, " +
"@SupplierTerms, " +
"@RequiredDeliveryDate, " +
"@BranchID, " +
"@TransferrerID, " +
"@TransferrerName, " +
"@Status, " +
"@Remarks, " +
"@ChartOfAccountIDAPTracking, " +
"@ChartOfAccountIDAPBills, " +
"@ChartOfAccountIDAPFreight, " +
"@ChartOfAccountIDAPVDeposit, " +
"@ChartOfAccountIDAPContra, " +
"@ChartOfAccountIDAPLatePayment" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmTransferInNo = new MySqlParameter("@TransferInNo",MySqlDbType.String);
prmTransferInNo.Value = Details.TransferInNo;
cmd.Parameters.Add(prmTransferInNo);
MySqlParameter prmTransferInDate = new MySqlParameter("@TransferInDate",MySqlDbType.DateTime);
prmTransferInDate.Value = Details.TransferInDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmTransferInDate);
MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64);
prmSupplierID.Value = Details.SupplierID;
cmd.Parameters.Add(prmSupplierID);
MySqlParameter prmSupplierCode = new MySqlParameter("@SupplierCode",MySqlDbType.String);
prmSupplierCode.Value = Details.SupplierCode;
cmd.Parameters.Add(prmSupplierCode);
MySqlParameter prmSupplierContact = new MySqlParameter("@SupplierContact",MySqlDbType.String);
prmSupplierContact.Value = Details.SupplierContact;
cmd.Parameters.Add(prmSupplierContact);
MySqlParameter prmSupplierAddress = new MySqlParameter("@SupplierAddress",MySqlDbType.String);
prmSupplierAddress.Value = Details.SupplierAddress;
cmd.Parameters.Add(prmSupplierAddress);
MySqlParameter prmSupplierTelephoneNo = new MySqlParameter("@SupplierTelephoneNo",MySqlDbType.String);
prmSupplierTelephoneNo.Value = Details.SupplierTelephoneNo;
cmd.Parameters.Add(prmSupplierTelephoneNo);
MySqlParameter prmSupplierModeOfTerms = new MySqlParameter("@SupplierModeOfTerms",MySqlDbType.Int16);
prmSupplierModeOfTerms.Value = Details.SupplierModeOfTerms;
cmd.Parameters.Add(prmSupplierModeOfTerms);
MySqlParameter prmSupplierTerms = new MySqlParameter("@SupplierTerms",MySqlDbType.Int16);
prmSupplierTerms.Value = Details.SupplierTerms;
cmd.Parameters.Add(prmSupplierTerms);
MySqlParameter prmRequiredDeliveryDate = new MySqlParameter("@RequiredDeliveryDate",MySqlDbType.DateTime);
prmRequiredDeliveryDate.Value = Details.RequiredDeliveryDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmRequiredDeliveryDate);
MySqlParameter prmBranchID = new MySqlParameter("@BranchID",MySqlDbType.Int16);
prmBranchID.Value = Details.BranchID;
cmd.Parameters.Add(prmBranchID);
MySqlParameter prmTransferrerID = new MySqlParameter("@TransferrerID",MySqlDbType.Int64);
prmTransferrerID.Value = Details.TransferrerID;
cmd.Parameters.Add(prmTransferrerID);
MySqlParameter prmTransferrerName = new MySqlParameter("@TransferrerName",MySqlDbType.String);
prmTransferrerName.Value = Details.TransferrerName;
cmd.Parameters.Add(prmTransferrerName);
MySqlParameter prmStatus = new MySqlParameter("@Status",MySqlDbType.Int16);
prmStatus.Value = Details.Status.ToString("d");
cmd.Parameters.Add(prmStatus);
MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String);
prmRemarks.Value = Details.Remarks;
cmd.Parameters.Add(prmRemarks);
MySqlParameter prmChartOfAccountIDAPTracking = new MySqlParameter("@ChartOfAccountIDAPTracking",MySqlDbType.Int32);
prmChartOfAccountIDAPTracking.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPTracking;
cmd.Parameters.Add(prmChartOfAccountIDAPTracking);
MySqlParameter prmChartOfAccountIDAPBills = new MySqlParameter("@ChartOfAccountIDAPBills",MySqlDbType.Int32);
prmChartOfAccountIDAPBills.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPBills;
cmd.Parameters.Add(prmChartOfAccountIDAPBills);
MySqlParameter prmChartOfAccountIDAPFreight = new MySqlParameter("@ChartOfAccountIDAPFreight",MySqlDbType.Int32);
prmChartOfAccountIDAPFreight.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPFreight;
cmd.Parameters.Add(prmChartOfAccountIDAPFreight);
MySqlParameter prmChartOfAccountIDAPVDeposit = new MySqlParameter("@ChartOfAccountIDAPVDeposit",MySqlDbType.Int32);
prmChartOfAccountIDAPVDeposit.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPVDeposit;
cmd.Parameters.Add(prmChartOfAccountIDAPVDeposit);
MySqlParameter prmChartOfAccountIDAPContra = new MySqlParameter("@ChartOfAccountIDAPContra",MySqlDbType.Int32);
prmChartOfAccountIDAPContra.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPContra;
cmd.Parameters.Add(prmChartOfAccountIDAPContra);
MySqlParameter prmChartOfAccountIDAPLatePayment = new MySqlParameter("@ChartOfAccountIDAPLatePayment",MySqlDbType.Int32);
prmChartOfAccountIDAPLatePayment.Value = clsAPLinkConfigDetails.ChartOfAccountIDAPLatePayment;
cmd.Parameters.Add(prmChartOfAccountIDAPLatePayment);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
