public string DataTransformFromPaymentToAdvance(PaymentsAndReciept.AccountTypes.Payment_GeneralDataType _Payment,out PaymentsAndReciept.AccountTypes.AdvancePaymentDataType _AdvanceData)
{
_AdvanceData = new AccountTypes.AdvancePaymentDataType();
try
{
_AdvanceData.AdvDate = _Payment.PayActualDate;
_AdvanceData.AdvStatus = 0;
_AdvanceData.AdvType = _Payment.PayToCatID;
_AdvanceData.Dr = _Payment.Cr ;
_AdvanceData.FDr = _Payment.FCr ;
_AdvanceData.Exrate = _Payment.CurRate ;
_AdvanceData.IssuedReference = _Payment.PaymentID ;
_AdvanceData.RvcAmount = 0;
_AdvanceData.ToID = 0;
_AdvanceData.ToName = _Payment.PayToName ;
return "True";
}
catch (Exception ex)
{
return ex.Message;
}
}
public string GetExistAdvancePayment(string ADVReference, out AccountTypes.AdvancePaymentDataType _ExistData)
{
_ExistData = new AccountTypes.AdvancePaymentDataType();
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Select "
+ "SysID,"
+ "ADVReference,"
+ "AdvType,"
+ "ToID,"
+ "ToName,"
+ "Dr,"
+ "FDr,"
+ "Exrate,"
+ "AdvDate,"
+ "IssuedReference,"
+ "RvcAmount,"
+ "AdvStatus"
+ " from tbladvanced"
+ " Where 1=1 "
+ " and ADVReference=@ADVReference";
oSqlCommand.Parameters.AddWithValue("@ADVReference", ADVReference);
DataRow r = Mycommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data AdvancePayment");
if (r != null)
{
try
{
bool resp = false;
int inSysID = 0;
resp = int.TryParse(r["SysID"].ToString(), out inSysID);
_ExistData.SysID = inSysID;
_ExistData.ADVReference = r["ADVReference"].ToString();
int inAdvType = 0;
resp = int.TryParse(r["AdvType"].ToString(), out inAdvType);
_ExistData.AdvType = inAdvType;
int inToID = 0;
resp = int.TryParse(r["ToID"].ToString(), out inToID);
_ExistData.ToID = inToID;
_ExistData.ToName = r["ToName"].ToString();
decimal deDr = 0;
resp = decimal.TryParse(r["Dr"].ToString(), out deDr);
_ExistData.Dr = deDr;
decimal deFDr = 0;
resp = decimal.TryParse(r["FDr"].ToString(), out deFDr);
_ExistData.FDr = deFDr;
decimal deExrate = 0;
resp = decimal.TryParse(r["Exrate"].ToString(), out deExrate);
_ExistData.Exrate = deExrate;
DateTime dtAdvDate = new DateTime(1900, 1, 1);
resp = DateTime.TryParse(r["AdvDate"].ToString(), out dtAdvDate);
if (resp)
_ExistData.AdvDate = dtAdvDate;
else
_ExistData.AdvDate = new DateTime(1900, 1, 1);
_ExistData.IssuedReference = r["IssuedReference"].ToString();
decimal deRvcAmount = 0;
resp = decimal.TryParse(r["RvcAmount"].ToString(), out deRvcAmount);
_ExistData.RvcAmount = deRvcAmount;
int inAdvStatus = 0;
resp = int.TryParse(r["AdvStatus"].ToString(), out inAdvStatus);
_ExistData.AdvStatus = inAdvStatus;
return "True";
}
catch (Exception ex)
{
return ex.Message;
}
}
else
return "data not found ";
}
