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 "; }