public async Task GetLedgerAsyncFailTest()
{
Ledgers ledgers = new Ledgers();
await Assert.ThrowsExceptionAsync <LedgerException>(() =>
ledgers.GetLedgerAsync("3170DA37CE2B7F045F889594CBC323D88686D2E90E8FFD2BBCD9BAD12E416DB6"));
}
public override async Task OnNavigatedToAsync(object parameter, NavigationMode mode, IDictionary <string, object> suspensionState)
{
if (suspensionState.Any())
{
}
await Task.CompletedTask;
var sett = Services.SettingsServices.SettingsService.Instance.OrganisationId;
Views.Busy.SetBusy(true, "Loading ledger list");
var temp = await AccountingServices.ListLedgers(sett);
Views.Busy.SetBusy(false);
if (temp.result)
{
Ledgers = temp.data as List <Ledgers>;
RaisePropertyChanged("Ledgers");
}
if (parameter == null)
{
account = new Accounts();
account.date = DateTime.Now;
RaisePropertyChanged("account");
}
else
{
account = parameter as Accounts;
selectedcredit = Ledgers.Where(x => x.id.Equals(account.credit)).FirstOrDefault();
selecteddebit = Ledgers.Where(x => x.id.Equals(account.debit)).FirstOrDefault();
RaisePropertyChanged("selectedcredit");
RaisePropertyChanged("selecteddebit");
RaisePropertyChanged("account");
}
}
public async static Task <Status> AddLedger(Ledgers ledger)
{
try
{
if (ledger.id == null)
{
await MobileService.GetTable <Ledgers>().InsertAsync(ledger);
}
else
{
await MobileService.GetTable <Ledgers>().UpdateAsync(ledger);
}
return(new Models.Status()
{
result = true, message = "Successfully Added"
});
}
catch (Exception e)
{
return(new Models.Status()
{
result = false, message = e.ToString()
});
}
}
public void LedgersTests_ComputeAgingProcLifo_DateLastPay()
{
string suffix = MethodBase.GetCurrentMethod().Name;
Patient pat = PatientT.CreatePatient(fName: "Aging_DateLastPay", suffix: suffix);
Procedure proc95 = ProcedureT.CreateProcedure(pat, "D0270", ProcStat.C, "", 1000, DateTime.Today.AddDays(-95));
Procedure proc85 = ProcedureT.CreateProcedure(pat, "D1110", ProcStat.C, "", 100, DateTime.Today.AddDays(-85));
Payment pay50 = PaymentT.MakePayment(pat.PatNum, 50, DateTime.Today.AddDays(-50));
Adjustment adj40_1 = AdjustmentT.MakeAdjustment(pat.PatNum, 4, DateTime.Today.AddDays(-40), proc85.ProcDate, proc85.ProcNum);
Adjustment adj40_2 = AdjustmentT.MakeAdjustment(pat.PatNum, 6, DateTime.Today.AddDays(-40), proc85.ProcDate, proc85.ProcNum);
Payment pay2 = PaymentT.MakePayment(pat.PatNum, 50, DateTime.Today.AddDays(-2));
int agingProcLifoPrev = PrefC.GetInt(PrefName.AgingProcLifo);
try {
PrefT.UpdateInt(PrefName.AgingProcLifo, (int)YN.No);
Dictionary <long, DataRow> dictAging = Ledgers.GetAgingGuarTransTable(DateTime.Today, new List <long> {
pat.Guarantor
}, hasDateLastPay: true);
Assert.AreEqual(PIn.Date(dictAging[pat.Guarantor]["DateLastPay"].ToString()), pay2.PayDate);
PrefT.UpdateInt(PrefName.AgingProcLifo, (int)YN.Yes);
dictAging = Ledgers.GetAgingGuarTransTable(DateTime.Today, new List <long> {
pat.Guarantor
}, hasDateLastPay: true);
Assert.AreEqual(PIn.Date(dictAging[pat.Guarantor]["DateLastPay"].ToString()), pay2.PayDate);
}
finally {
PrefT.UpdateInt(PrefName.AgingProcLifo, agingProcLifoPrev);
}
}
public EditLedger(string sellerName)
: this()
{
Ledgers editLedger = new Ledgers();
editLedger = DAL_Ledgers.LoadLedger(sellerName);
this.DataContext = editLedger;
}
private void DrawLedgerOptions(Rect region)
{
Listing_Standard listing = new Listing_Standard(GameFont.Small);
listing.Begin(new Rect(0f, 0f, region.width, Text.LineHeight));
(Rect nameLabel, Rect nameField) = listing.GetRect(Text.LineHeight).ToForm(0.4f);
Widgets.Label(nameLabel, "Ledger name");
selectedLedger.Name = Widgets.TextField(nameField, selectedLedger.Name);
if (!selectedLedger.Name.NullOrEmpty() && SettingsHelper.DrawClearButton(nameField))
{
selectedLedger.Name = selectedLedger.Id.ToString();
}
listing.End();
string manageText = "Manage Ledger";
string deleteText = "Delete Ledger";
string resetText = "Reset Ledger";
float buttonWidth = Mathf.Max(
Text.CalcSize(manageText).x,
Text.CalcSize(deleteText).x,
Text.CalcSize(resetText).x
) + 12f;
listing.Gap(Text.LineHeight * 2.5f);
Rect buttonColumnRect = new Rect(
region.width - buttonWidth,
listing.CurHeight,
buttonWidth,
region.height - listing.CurHeight
);
listing.Begin(buttonColumnRect);
if (listing.ButtonText(manageText))
{
ManageLedgerWindow window = new ManageLedgerWindow(selectedLedger);
Find.WindowStack.TryRemove(window.GetType());
Find.WindowStack.Add(window);
}
if (listing.ButtonText(deleteText))
{
selectedLedger.RemoveLedger();
activeLedger = Ledgers.ActiveLedger();
selectedLedger = activeLedger;
}
if (listing.ButtonText(resetText))
{
selectedLedger.LedgerRecords = new List <LedgerRecord>();
}
listing.End();
}
public async Task GetLedgerAsyncTest()
{
Ledgers ledgers = new Ledgers();
Ledger ledger = await ledgers.GetLedgerAsync("3170DA37CE2B7F045F889594CBC323D88686D2E90E8FFD2BBCD9BAD12E416DB5");
Assert.IsNotNull(ledger);
Assert.IsTrue(ledger.Accepted);
Assert.AreEqual("8AD73E49A34D8B9C31BC13B8A97C56981E45EE70225EF4892E8B198FEC5A1F7D", ledger.AccountHash);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
contrDashProvList.FillData();
//prodProvs
List <Color> listColorsProd = DashboardQueries.GetProdProvColors();
List <List <int> > listDataProd = DashboardQueries.GetProdProvs(contrDashProdProvs.DateStart, contrDashProdProvs.DateEnd);
contrDashProdProvs.FillData(Lans.g(this, "Production by Prov"), 1000, listColorsProd, listDataProd);
//A/R
List <Color> listColorsAR = new List <Color>();
listColorsAR.Add(Colors.Firebrick);
List <DashboardAR> listDashARIn = DashboardARs.Refresh(contrDashAR.DateStart);
if (listDashARIn.Count == 0)
{
//Make a guess as to how long the user might have to wait.
double agingInMilliseconds = Ledgers.GetAgingComputationTime();
//Aging will be run a total of 13 times.
agingInMilliseconds = agingInMilliseconds * 13;
TimeSpan timeSpan = TimeSpan.FromMilliseconds(agingInMilliseconds);
string timeEstimate = "";
if (timeSpan.Minutes > 0)
{
timeEstimate += timeSpan.Minutes + " " + Lans.g(this, "minutes and") + " ";
}
timeEstimate += timeSpan.Seconds + " " + Lans.g(this, "seconds");
MessageBoxResult result = MessageBox.Show(Lans.g(this,
"A one-time routine needs to be run that will take about") + "\r\n"
+ timeEstimate + ". " + Lans.g(this, "Continue?"), "", MessageBoxButton.OKCancel);
if (result != MessageBoxResult.OK)
{
Close();
return;
}
}
List <DashboardAR> listDashAROut = DashboardQueries.GetAR(contrDashAR.DateStart, contrDashAR.DateEnd, listDashARIn);
List <List <int> > listDataAR = new List <List <int> >();
//1 dimensional for now.
listDataAR.Add(listDashAROut.OrderBy(x => x.DateCalc).Select(x => (int)x.BalTotal).ToList());
contrDashAR.FillData(Lans.g(this, "Accounts Receivable"), 1000, listColorsAR, listDataAR);
//ProdInc
contrDashProdInc.FillData();
//new pat
List <Color> listColorsNP = new List <Color>();
listColorsNP.Add(Colors.Chocolate);
List <List <int> > listDataNP = DashboardQueries.GetNewPatients(contrDashNewPat.DateStart, contrDashNewPat.DateEnd);
contrDashNewPat.FillData(Lans.g(this, "New Patients"), 1, listColorsNP, listDataNP);
}
private void CheckAgingProcLifo(long patNum, double bal_0_30, double bal_31_60, double bal_61_90, double balOver90, double payPlanDue, YN prefVal)
{
int agingProcLifoPrev = PrefC.GetInt(PrefName.AgingProcLifo);
try {
PrefT.UpdateInt(PrefName.AgingProcLifo, (int)prefVal);
Ledgers.ComputeAging(patNum, DateTime.Today);
PatAssertBalances(patNum, bal_0_30, bal_31_60, bal_61_90, balOver90, payPlanDue);
}
finally {
PrefT.UpdateInt(PrefName.AgingProcLifo, agingProcLifoPrev);
}
}
public IHttpActionResult SaveSupplier(SupplierProfileAC supplier)
{
try
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
if (MerchantContext.Permission.IsAllowToCreateSupplierProfile)
{
var supplierProfileAC = _supplierProfileContext.SaveSupplierProfile(supplier, companyId);
if (supplierProfileAC != null && supplierProfileAC.Id > 0)
{
Ledgers ledgers = new Ledgers();
ledgers.Address = supplierProfileAC.AddressEn;
ledgers.State = "Gujarat";
ledgers.CompanyId = MerchantContext.CompanyDetails.Id;
ledgers.LedgerName = supplierProfileAC.NameEn + "Ledgers";
ledgers.Name = ledgers.LedgerName;
ledgers.CreatedDateTime = DateTime.UtcNow;
ledgers.GroupId = 6;
ledgers.ParentLedgerId = null;
ledgers.Balance = 0;
ledgers.SuplierId = supplierProfileAC.Id;
_iAccountingRepository.AddAccountLedger(ledgers);
}
return(Ok(supplierProfileAC));
}
else
{
return(Ok(new { status = StringConstants.PermissionDenied }));
}
}
else
{
return(BadRequest());
}
}
catch (PhoneNumberIsAlreadyExists)
{
return(BadRequest("PhoneNumberIsAlreadyExists"));
}
catch (EmailisAlreadyExists)
{
return(BadRequest("EmailisAlreadyExists"));
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
private void SetLedger(LedgerViewModel ledgerData)
{
if (ledgerData == null)
{
throw new ArgumentNullException(nameof(ledgerData));
}
var existingLedger = Ledgers.FirstOrDefault(a => a.LedgeCode == ledgerData.LedgeCode);
if (existingLedger != null)
{
Ledgers.Remove(existingLedger);
}
Ledgers.Add(ledgerData);
}
public void SetLedger(Ledger ledger)
{
if (ledger == null)
{
throw new ArgumentNullException(nameof(ledger));
}
var existingLedger = Ledgers.FirstOrDefault(a => a.LedgeCode == ledger.LedgeCode);
if (existingLedger != null)
{
Ledgers.Remove(existingLedger);
}
Ledgers.Add(ledger);
}
public IHttpActionResult SaveLedger(LedgerAccountAC ledger)
{
try
{
bool isValidGroup = true;
if (ledger.isSubAccountChecked)
{
Ledgers ledgres = _ledgerAccountRepository.GetLedgersByLedgersId(ledger.ParentLedgerId);
if (ledgres != null && ledgres.Group.Id != ledger.GroupId)
{
isValidGroup = false;
}
}
if (isValidGroup)
{
Ledgers newLedgers = new Ledgers();
newLedgers.CreatedDateTime = DateTime.UtcNow;
newLedgers.CompanyId = CurrentCompanyId;
newLedgers.GroupId = ledger.GroupId;
newLedgers.GroupTypId = ledger.GroupTypeId;
newLedgers.LedgerName = ledger.LedgerName;
newLedgers.LedgersDate = ledger.ledgersDate != null?Convert.ToDateTime(ledger.ledgersDate).ToLocalTime() : ledger.ledgersDate;
newLedgers.Name = newLedgers.LedgerName;
newLedgers.Balance = ledger.Balance;
newLedgers.IsEditable = true;
if (ledger.ParentLedgerId != 0)
{
newLedgers.ParentLedgerId = ledger.ParentLedgerId;
}
newLedgers.Description = ledger.Description;
int id = _ledgerAccountRepository.SaveLedgers(newLedgers);
if (id != 0)
{
return(Ok(new { _isResult = id }));
}
else
{
return(Ok(new { _isResult = "NotValidLedgerName" }));
}
}
return(Ok(new { _isResult = "NotValidGroup" }));
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
/// <summary>Creates patient objects corresponding to the totalPat parameter. Each patient has a procedure
/// and statement created on the specified date. Aging is run for each patient.</summary>
public static void CreatePatWithProcAndStatement(int totalPat, DateTime dateTimeSentStmt = default(DateTime), bool hasPortalAccessInfo = false,
PatientStatus patStatus = PatientStatus.Patient, StatementMode stmtMode = StatementMode.Mail, bool hasSignedTil = false, double procFee = 0)
{
for (int i = 0; i < totalPat; i++)
{
Patient patient = CreatePatient("", 0, 0, "", "", ContactMethod.Email, "", "", "", default(DateTime), 0, 0, hasPortalAccessInfo, patStatus, hasSignedTil);
DateTime dateProc = DateTime.Today.AddDays(-1);
//Create a completed procedure that was completed the day before the first payplan charge date AND before the payment plan creation date.
ProcedureT.CreateProcedure(patient, "D1100", ProcStat.C, "", procFee, dateProc);
//Run Ledgers to update the patient balance from the procedure fee
Ledgers.ComputeAging(patient.PatNum, dateTimeSentStmt);
//Insert a statement that was sent during the "bill in advance days" for the payment plan charge AND before the payment plan creation date.
StatementT.CreateStatement(patient.PatNum, mode_: stmtMode, isSent: true, dateSent: dateTimeSentStmt);
}
}
/// <summary>
/// This method used for add account ledeger. -An
/// </summary>
/// <param name="accountLedger"></param>
/// <returns></returns>
public int AddAccountLedger(Ledgers accountLedger)
{
try
{
accountLedger.CreatedDateTime = DateTime.UtcNow;
_accountLedgerContext.Add(accountLedger);
_accountLedgerContext.SaveChanges();
return(accountLedger.Id);
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
public Ledgers LoadLedgers()
{
XmlSerializer xs = new XmlSerializer(typeof(Ledgers));
if (!File.Exists(_ledgerPath))
{
Ledgers ledgers = new Ledgers();
FileStream tempfs = new FileStream(_ledgerPath,
FileMode.Create);
xs.Serialize(tempfs, ledgers);
tempfs.Close();
}
FileStream fs = new FileStream(_ledgerPath,
FileMode.OpenOrCreate);
var _ledgers = (Ledgers)xs.Deserialize(fs);
fs.Close();
//associate the ledger with a contact
Contacts contacts = LoadContacts();
foreach (var ledger in _ledgers)
{
foreach (var contact in contacts)
{
if (contact.Id == ledger.ContactId)
{
ledger.Contact = contact;
}
}
}
Categories categories = LoadCategories();
foreach (var ledger in _ledgers)
{
foreach (var category in categories)
{
if (category.Id == ledger.CategoryId)
{
ledger.Category = category;
}
}
}
return _ledgers;
}
public LedgersWindow()
{
this.doCloseButton = true;
if (Ledgers.Instance.All.Count == 0)
{
Log.Message("Detected no ledgers, creating new");
selectedLedger = Ledger.NewLedger();
}
activeLedger = Ledgers.ActiveLedger();
if (selectedLedger == null)
{
selectedLedger = activeLedger;
}
}
public void OrderLedgers()
{
if (VchType != "Contra" && VchType != "Purchase" && VchType != "Receipt" && VchType != "Credit Note")
{
Ledgers.Sort((x, y) => y.LedgerName.CompareTo(x.LedgerName)); //First Sort Ledger list Using Ledger Names
Ledgers.Sort((x, y) => y.Amount.CompareTo(x.Amount)); //Next sort Ledger List Using Ledger Amounts
}
else
{
Ledgers.Sort((x, y) => x.LedgerName.CompareTo(y.LedgerName)); //First Sort Ledger list Using Ledger Names
Ledgers.Sort((x, y) => x.Amount.CompareTo(y.Amount)); //Next sort Ledger List Using Ledger Amounts
}
//Looop Through all Ledgers
Ledgers.ForEach(c =>
{
//Sort Bill Allocations
c.BillAllocations.Sort((x, y) => x.Name.CompareTo(y.Name)); //First Sort BillAllocations Using Bill Numbers
c.BillAllocations.Sort((x, y) => x.Amount.CompareTo(y.Amount)); //Next sort BillAllocationst Using Amounts
c.CostCategoryAllocations.Sort((x, y) => x.CostCategoryName.CompareTo(y.CostCategoryName));
c.CostCategoryAllocations.ForEach(cc =>
{
cc.CostCenterAllocations.Sort((x, y) => x.Name.CompareTo(y.Name));
cc.CostCenterAllocations.Sort((x, y) => x.Amount.CompareTo(y.Amount));
});
//sort Inventory Allocations
c.InventoryAllocations.Sort((x, y) => x.ActualQuantity.CompareTo(y.ActualQuantity));
c.InventoryAllocations.Sort((x, y) => x.Amount.CompareTo(y.Amount));
c.InventoryAllocations.ForEach(inv =>
{
inv.BatchAllocations.Sort((x, y) => x.GodownName.CompareTo(y.GodownName));
inv.BatchAllocations.Sort((x, y) => x.Amount.CompareTo(y.Amount));
inv.CostCategoryAllocations.Sort((x, y) => x.CostCategoryName.CompareTo(y.CostCategoryName));
inv.CostCategoryAllocations.ForEach(cc =>
{
cc.CostCenterAllocations.Sort((x, y) => x.Name.CompareTo(y.Name));
cc.CostCenterAllocations.Sort((x, y) => x.Amount.CompareTo(y.Amount));
});
});
});
}
public void LedgersTests_ComputeAgingProcLifo_InsWoEst_And_InsPayEst()
{
string suffix = MethodBase.GetCurrentMethod().Name;
Patient pat = PatientT.CreatePatient(fName: "Aging_InsEst", suffix: suffix);
InsuranceInfo insInfo = InsuranceT.AddInsurance(pat, "AgingInsEst");
Procedure proc95 = ProcedureT.CreateProcedure(pat, "D0270", ProcStat.C, "", 1000, DateTime.Today.AddDays(-95));
ClaimProc cp95 = new ClaimProc();
ClaimProcs.CreateEst(cp95, proc95, insInfo.PriInsPlan, insInfo.PriInsSub);
cp95.Status = ClaimProcStatus.NotReceived;
cp95.InsEstTotal = 800;
cp95.InsPayEst = 800;
cp95.WriteOffEst = 200;
cp95.WriteOff = 200;
ClaimProcs.Update(cp95);
Procedure proc85 = ProcedureT.CreateProcedure(pat, "D1110", ProcStat.C, "", 100, DateTime.Today.AddDays(-85));
ClaimProc cp85 = new ClaimProc();
ClaimProcs.CreateEst(cp85, proc85, insInfo.PriInsPlan, insInfo.PriInsSub);
cp85.Status = ClaimProcStatus.NotReceived;
cp85.InsEstTotal = 60;
cp85.InsPayEst = 60;
cp85.WriteOffEst = 40;
cp85.WriteOff = 40;
ClaimProcs.Update(cp85);
int agingProcLifoPrev = PrefC.GetInt(PrefName.AgingProcLifo);
try {
PrefT.UpdateInt(PrefName.AgingProcLifo, (int)YN.No);
Dictionary <long, DataRow> dictAging = Ledgers.GetAgingGuarTransTable(DateTime.Today, new List <long> {
pat.Guarantor
});
Assert.AreEqual(PIn.Double(dictAging[pat.Guarantor]["InsPayEst"].ToString()), 860);
Assert.AreEqual(PIn.Double(dictAging[pat.Guarantor]["InsWoEst"].ToString()), 240);
PrefT.UpdateInt(PrefName.AgingProcLifo, (int)YN.Yes);
dictAging = Ledgers.GetAgingGuarTransTable(DateTime.Today, new List <long> {
pat.Guarantor
});
Assert.AreEqual(PIn.Double(dictAging[pat.Guarantor]["InsPayEst"].ToString()), 860);
Assert.AreEqual(PIn.Double(dictAging[pat.Guarantor]["InsWoEst"].ToString()), 240);
}
finally {
PrefT.UpdateInt(PrefName.AgingProcLifo, agingProcLifoPrev);
}
}
public ManageLedgerWindow(Ledger ledger = null)
{
this.doCloseButton = true;
if (ledger == null)
{
activeLedger = Ledgers.ActiveLedger();
}
else
{
activeLedger = ledger;
}
if (activeLedger.Points != null && activeLedger.Points.Count > 0)
{
selectedViewerName = activeLedger.Points.FirstOrDefault().Key;
selectedViewerPoints = activeLedger.Points[selectedViewerName];
}
}
public bool CheckSelectedLedgerIsBankAccount(int ledgerId)
{
try
{
bool result = false;
Ledgers ledgers = _ledgerContext.Fetch(x => x.Id == ledgerId).FirstOrDefault();
if (ledgers != null && ledgers.GroupId == (int)AccountGroup.Bank)
{
result = true;
}
return(result);
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
public override async Task OnNavigatedToAsync(object parameter, NavigationMode mode, IDictionary <string, object> suspensionState)
{
if (suspensionState.Any())
{
}
await Task.CompletedTask;
if (parameter != null)
{
ledger = parameter as Ledgers;
SelectedItem = ledger.group;
RaisePropertyChanged("ledger");
RaisePropertyChanged("SelectedItem");
}
else
{
ledger = new Ledgers();
RaisePropertyChanged("ledger");
}
}
public int SaveLedgers(Ledgers ledger)
{
try
{
//check the ledger name is exists or not
int ledgerCount = _ledgerContext.Fetch(x => x.LedgerName == ledger.LedgerName && x.CompanyId == ledger.CompanyId).Count();
if (ledgerCount > 0)
{
return(0);
}
_ledgerContext.Add(ledger);
_ledgerContext.SaveChanges();
return(ledger.Id);
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
public void LedgersTests_ComputeAgingForPaysplitsAllocatedToDiffPats()
{
string suffix = MethodBase.GetCurrentMethod().Name;
Patient patDad = PatientT.CreatePatient(fName: "Father", suffix: suffix); //Father-guarantor
Patient patChild = PatientT.CreatePatient(fName: "Child", suffix: suffix); //Child
PatientT.SetGuarantor(patChild, patDad.PatNum);
Procedure proc1 = ProcedureT.CreateProcedure(patChild, "D1110", ProcStat.C, "", 50, DateTime.Today.AddDays(-45));
Procedure proc2 = ProcedureT.CreateProcedure(patChild, "D0120", ProcStat.C, "", 40, DateTime.Today.AddDays(-45));
Ledgers.ComputeAging(patDad.PatNum, DateTime.Today);
patDad = Patients.GetPat(patDad.PatNum);
Assert.AreEqual(90, patDad.Bal_31_60);
Patient patMom = PatientT.CreatePatient(fName: "Mom", suffix: suffix); //Mom is not associated to the father and childs account
long patNum = patMom.PatNum;
//complete procedures for patMom.
Procedure proc3 = ProcedureT.CreateProcedure(patMom, "D1110", ProcStat.C, "", 50, DateTime.Today.AddDays(-1));
Procedure proc4 = ProcedureT.CreateProcedure(patMom, "D0120", ProcStat.C, "", 40, DateTime.Today.AddDays(-1));
//Compute aging. Check that the aging is correct before we continue
Ledgers.ComputeAging(patNum, DateTime.Today);
patMom = Patients.GetPat(patNum);
Assert.AreEqual(90, patMom.Bal_0_30);
//patMom will now make a payment for her procedures and patChilds
Payment pay = PaymentT.MakePaymentNoSplits(patNum, 100, clinicNum: proc3.ClinicNum);
List <PaySplit> listPaySplits = new List <PaySplit>();
listPaySplits.Add(PaySplitT.CreateSplit(proc3.ClinicNum, patNum, pay.PayNum, 0, DateTime.Today, proc3.ProcNum, proc3.ProvNum, 50, 0));
//Create a paysplit for patChild. PatChild is from a different family.
listPaySplits.Add(PaySplitT.CreateSplit(proc1.ClinicNum, patChild.PatNum, pay.PayNum, 0, DateTime.Today, proc1.ProcNum, proc1.ProvNum, 50, 0));
//This should compute the aging for the
string strErrorMsg = Ledgers.ComputeAgingForPaysplitsAllocatedToDiffPats(patNum, listPaySplits);
Assert.IsTrue(string.IsNullOrEmpty(strErrorMsg));
patDad = Patients.GetPat(patDad.PatNum);
Assert.AreEqual(40, patDad.Bal_31_60);
//Compute patMom aging to verify that it is correct.
Ledgers.ComputeAging(patNum, DateTime.Today);
patMom = Patients.GetPat(patNum);
Assert.AreEqual(40, patMom.Bal_0_30);
}
public int UpdateLedgers(Ledgers ledgers)
{
try
{
//check the ledger name is exists or not
int ledgerCount = _ledgerContext.Fetch(x => x.LedgerName == ledgers.LedgerName && x.CompanyId == ledgers.CompanyId && x.Id != ledgers.Id).Count();
if (ledgerCount > 0)
{
return(0);
}
ledgers.ModifiedDateTime = DateTime.UtcNow;
_ledgerContext.Update(ledgers);
_ledgerContext.SaveChanges();
return(ledgers.Id);
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
public JsonResult Post(Ledgers ld)
{
string query = @"insert into dbo.ledgers (ledger_name,legder_phone,ledger_type,inserted_date,ledger_address, ledger_email) values ('" + ld.ledger_name + @"' , '" + ld.legder_phone + @"' , '" + ld.ledger_type + @"' , '" + ld.inserted_date + @"' , '" + ld.ledger_address + @"' , '" + ld.ledger_email + @"') ";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("APIcon");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Added Successfully"));
}
public JsonResult Get(Ledgers ld)
{
string query = @"select * from dbo.ledgers where ledger_name='" + ld.ledger_name + "' ";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("APIcon");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);
myReader.Close();
myCon.Close();
}
}
return(new JsonResult(table));
}
public IHttpActionResult UpdateLedgers(LedgerAccountAC ledgerAccountAc)
{
try
{
Ledgers ledgers = _ledgerAccountRepository.GetLedgersByLedgersId(ledgerAccountAc.LedgerId);
if (ledgers != null)
{
ledgers.LedgerName = ledgerAccountAc.LedgerName;
ledgers.Name = ledgerAccountAc.LedgerName;
int id = _ledgerAccountRepository.UpdateLedgers(ledgers);
if (id == 0)
{
return(Ok(new { _isResult = "NotValidLedgerName" }));
}
}
return(Ok(new { _isResult = true }));
}
catch (Exception ex)
{
_errorLog.LogException(ex);
throw;
}
}
public JsonResult Put(int id, Ledgers ld)
{
string query = @"update dbo.ledgers set
ledger_name= '" + ld.ledger_name + @"' , legder_phone= '" + ld.legder_phone + @"' , ledger_type = '" + ld.ledger_type + @"' , ledger_address = '" + ld.ledger_address + @"' , ledger_email = '" + ld.ledger_email + @"' where ledgerid = '" + id + "'";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("APIcon");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Updated Successfully"));
}
public Ledgers GetLedger(SqlConnection con, int LedgerID)
{
DataTable ds = new DataTable();
Ledgers objLdgr = new Ledgers();
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from T_Ledgers WHERE LedgerID=@LedgerID ", con);
da.SelectCommand.Parameters.Add("@LedgerID", SqlDbType.Int).Value = LedgerID;
da.Fill(ds);
da.Dispose();
if (ds.Rows.Count == 0)
{
return(null);
}
objLdgr.LedgerID = ds.Rows[0].Field <int>("LedgerID");
objLdgr.LedgerName = ds.Rows[0].Field <string>("LedgerName");
objLdgr.LedgerTypeID = ds.Rows[0].Field <int>("LedgerTypeID");
objLdgr.Address = ds.Rows[0].Field <string>("Address");
objLdgr.BankAccountType = ds.Rows[0].Field <string>("bankAccType");
objLdgr.BusinessType = ds.Rows[0].Field <string>("BusinessType");
objLdgr.ContactPerson = ds.Rows[0].Field <string>("ContactPerson");
objLdgr.CountryID = ds.Rows[0].Field <int>("CountryID");
objLdgr.CurrencyID = ds.Rows[0].Field <int>("CurrencyID");
objLdgr.Email = ds.Rows[0].Field <string>("Email");
objLdgr.Fax = ds.Rows[0].Field <string>("Fax");
objLdgr.Phone = ds.Rows[0].Field <string>("Phone");
objLdgr.Remarks = ds.Rows[0].Field <string>("Remarks");
objLdgr.TeamMemberID = ds.Rows[0].Field <object>("TeamID") == null?-1:ds.Rows[0].Field <int>("TeamID");
objLdgr.AccountID = ds.Rows[0].Field <object>("AccountID") == null ? -1 : ds.Rows[0].Field <int>("AccountID");;
}
catch (Exception ex)
{
throw ex;
}
return(objLdgr);
}
public Ledgers.DAILYCLOSINGDatesDataTable GetDailyClosingDates(bool usecn=false,string othercn="p")
{
var ta = new LedgersTableAdapters.DAILYCLOSINGDatesTableAdapter {Connection = {ConnectionString = usecn?othercn:_constr}};
var ds = new Ledgers().DAILYCLOSINGDates;
ta.Fill(ds);
return ds;
}
public void SaveLedgers(Ledgers ledgers)
{
XmlSerializer xs = new XmlSerializer(typeof(Ledgers));
FileStream fs = new FileStream(_ledgerPath,
FileMode.Truncate);
xs.Serialize(fs, ledgers);
fs.Close();
}
public Ledgers.DAILYCLOSINGDataTable GetDailyClosing()
{
var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new Ledgers().DAILYCLOSING;
ta.FillByCompany(ds, Utils.Company);
return ds;
}
public Ledgers.DAILYCLOSINGDataTable GetLastClosing(DateTime d1, bool isdate)
{
var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new Ledgers().DAILYCLOSING;
if (isdate)
ta.FillByMaxdateToDate(ds, Utils.Company,d1);
else
ta.FillByMaxdate(ds, Utils.Company);
return ds;
}
public string DoDeleteInvoice(Ledgers.ARAPRECEIPTSDETAILSRow drdet)
{
return new PurchasePayment().DoDeleteInvoice(drdet);
}
public string DoDeleteInvoice(Ledgers.ARAPRECEIPTSDETAILSRow dr)
{
SqlTransaction tran = null;
var isnew = false;
string retval = string.Empty;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var taLedger = new LEDGERSTableAdapter();
taLedger.AssignConnection(cn, tran);
//ARAPRECEIPTSDETAILS
// var cmd = new SqlCommand(cmdtxt, cn, tran);
var cmd = new SqlCommand();
cmd.Connection = cn;
cmd.Transaction = tran;
var cmdtxt = "delete from ARAPRECEIPTSDETAILS where tranid = " + dr.TRANID + "";
cmd.CommandText = cmdtxt;
cmd.ExecuteNonQuery();
cmdtxt = "update ARAPRECEIPTS set AMOUNT = AMOUNT - " + dr.INVAMOUNT + " where ARAPTRANID =" + dr.ARAPTRANID;
cmd.CommandText = cmdtxt;
cmd.ExecuteNonQuery();
cmdtxt = "update APARMAIN set BALANCE = " + dr.INVAMOUNT + " , PAIDAMOUNT = 0 where tranid = " + dr.TRANID;
cmd.CommandText = cmdtxt;
cmd.ExecuteNonQuery();
taLedger.Insert("S", dr.REFNO, DateTime.Now.Date, dr.INVOICEDATE, dr.ARAPTRANID, dr.INVOICENO,
- dr.INVAMOUNT, 0, 18, Utils.Company, Utils.Userid, "Purchase Reverse");
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public Ledgers.COMMISIONMASTDataTable GetCommissionMast(string commid = null, bool useconstr = false, string newconstr = "p")
{
var dt = new Ledgers().COMMISIONMAST;
var ta = new LedgersTableAdapters.COMMISIONMASTTableAdapter
{
Connection = { ConnectionString = useconstr ? newconstr : _constr }
};
if (commid == null)
{
ta.Fill(dt);
}
else
{
ta.FillByCOMID(dt, commid);
}
return dt;
}
private void calculateBalance()
{
_ledgers = _checkbook.LoadLedgers();
runningBalance = 0;
foreach (Ledger ledger in _ledgers)
{
runningBalance = ledger.Amount + runningBalance;
}
labelLedgerBalanceAmount.Text = runningBalance.ToString();
}
public Ledgers.COMMISIONDETAILDataTable GetCommissionDetail(string commid = null,bool isRemote=false)
{
var dt = new Ledgers().COMMISIONDETAIL;
string _sysnstr = Utils.ConnectionstringSync;
if (isRemote)
{
if (Utils.Company != "01")
{
_sysnstr = new SqlAsyncConnectionString(6, true);
}
}
var ta = new LedgersTableAdapters.COMMISIONDETAILTableAdapter
{
Connection = { ConnectionString = isRemote ? _sysnstr : _constr }
};
if (commid == null)
{
ta.Fill(dt);
}
else
{
ta.FillByCOMID(dt, commid);
}
return dt;
}
public string DoPost(string batchno,Ledgers.ARAPRECEIPTSDETAILSDataTable dt)
{
string retval = string.Empty;
SqlTransaction tran = null;
try
{
var cn = new SqlConnection(_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ta = new ARAPRECEIPTSTableAdapter();
var tadet = new ARAPRECEIPTSDETAILSTableAdapter();
var taLedger = new LEDGERSTableAdapter();
ta.AssignConnection(cn,tran);// tadet.AssignConnection(cn,tran);
taLedger.AssignConnection(cn,tran);
string arapno = string.Empty;
foreach (Ledgers.ARAPRECEIPTSDETAILSRow drdet in dt.Rows)
{
if (drdet.RowState != DataRowState.Deleted)
{
arapno = drdet.ARAPTRANID;
var cmdtxt = "update APARMAIN set PAIDAMOUNT = 0 , BALANCE = INVAMOUNT where TRANID = " + drdet.TRANID;
var cmd = new SqlCommand(cmdtxt, cn, tran);
cmd.ExecuteNonQuery();
taLedger.Insert("S", drdet.REFNO, DateTime.Now.Date, drdet.INVOICEDATE, batchno,
drdet.INVOICENO, - drdet.INVAMOUNT, 0, 18, Utils.Company, Utils.Userid,"Payment Reverse");
}
}
tran.Commit();
//tadet.DeleteByARAPTRANID(batchno);
//ta.DeleteByARAPTRANID(batchno);
ta.DoPost(batchno);
retval = "1";
}
catch (Exception ex)
{
if (tran != null) tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public string DoUpLoadPromotions(Ledgers.COMMISIONMASTRow CommisionmastRow, Ledgers.COMMISIONDETAILDataTable commisiondetail,bool isRemote=false)
{
var dm = new DataManager();
string retval;
SqlTransaction tran = null;
try
{
if (isRemote)
_syncConstr = Utils.Connectionstring;
var cn = new SqlConnection(_syncConstr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new Ledgers();
var dt = ds.COMMISIONMAST;
var dtdetail = ds.COMMISIONDETAIL;
var taCommMain = new COMMISIONMASTTableAdapter();
var taCommDetail = new COMMISIONDETAILTableAdapter();
// Assaign Transaction
taCommMain.AssignConnection(cn, tran);
taCommDetail.AssignConnection(cn, tran);
var dr = (Ledgers.COMMISIONMASTRow)dt.NewRow();
dr.PRMOFRM = CommisionmastRow.PRMOFRM;
dr.PRMOTO = CommisionmastRow.PRMOTO;
dr.PROMONAME = CommisionmastRow.PROMONAME;
dr.STOREID = CommisionmastRow.STOREID;
dr.EMPNO = CommisionmastRow.EMPNO;
dr.STATUS = CommisionmastRow.STATUS;
dr.COMID = CommisionmastRow.COMID;
dr.USERID = CommisionmastRow.USERID;
dr.UDATE = DateTime.Now;
dt.Rows.Add(dr);
taCommMain.Update(dt);
//LEDGER
foreach (Ledgers.COMMISIONDETAILRow ditemdetarow in commisiondetail)
{
var newdetrow = dtdetail.NewRow();
foreach (DataColumn dc in commisiondetail.Columns)
{
if (!dc.ReadOnly)
{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
}
}
dtdetail.Rows.Add(newdetrow);
}
taCommDetail.Update(dtdetail);
if (isRemote)
{
var dmu = new CommissionSetup();
dmu.UpdateSync(dr.COMID, true);
}
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public string DoSave()
{
string retval = "0";
SqlTransaction tran = null;
var cn = new SqlConnection(_constr);
try
{
cn.Open();
var tadet = new LedgersTableAdapters.COMMISIONDETAILTableAdapter();
var tam = new LedgersTableAdapters.COMMISIONMASTTableAdapter {Connection = {ConnectionString = _constr}};
var dt = new Ledgers().COMMISIONMAST;
tam.Fill(dt);
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
tam.AssignConnection(cn, tran);
tadet.AssignConnection(cn, tran);
bool isnew = false;
var dr = dt.FindByCOMID(CommisionmastRow.COMID);
if (dr != null)
{
dr.BeginEdit();
Utils.CommissionNo = CommisionmastRow.COMID;
dr.EUSERID = Utils.Userid;
dr.EDATE = DateTime.Now.Date;
}
else
{
isnew = true;
var autoid = new DataManager().GetAutoId(15);
autoid++;
Utils.CommissionNo = new DataManager().CreateFormatedAutoNo(autoid);
dr = (Ledgers.COMMISIONMASTRow) dt.NewRow();
dr.PRMOFRM = CommisionmastRow.PRMOFRM;
dr.PRMOTO = CommisionmastRow.PRMOTO;
dr.PROMONAME = CommisionmastRow.PROMONAME;
dr.STOREID = CommisionmastRow.STOREID;
dr.EMPNO = CommisionmastRow.EMPNO;
dr.STATUS = CommisionmastRow.STATUS;
dr.COMID = Utils.CommissionNo;
dr.USERID = Utils.Userid;
dr.UDATE = DateTime.Now.Date;
}
foreach (Ledgers.COMMISIONDETAILRow crow in Commisiondetail.Rows)
{
crow.COMID = Utils.CommissionNo;
}
if (isnew)
{
dt.Rows.Add(dr);
tam.Update(dt);
}
else
{
dr.EndEdit();
tam.Update(dt);
}
tadet.Update(Commisiondetail);
new DataManager().UpdateAutoNum(15);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
retval = ex.ToString();
if (tran != null && cn.State == ConnectionState.Open)
{
tran.Rollback();
}
}
return retval;
}
public void updateGetItemsFromTextFileTable(Ledgers.TEXTFILESDATADataTable dsa)
{//TEXTFILESDATA
var ta = new LedgersTableAdapters.TEXTFILESDATATableAdapter { Connection = { ConnectionString = _constr } };
ta.Update(dsa);
}
public Ledgers.DAILYCLOSINGDataTable GetSPCP(DateTime d1,int spcp,bool useconstr,string newconstr)
{
var ta = new LedgersTableAdapters.DAILYCLOSINGTableAdapter { Connection = { ConnectionString = useconstr ? newconstr : _constr } };
var ds = new Ledgers().DAILYCLOSING;
if (spcp == 1)
ta.FillBySPCP(ds, d1, 2);
else if (spcp == 2)
ta.FillBySPCP(ds, d1, 3);
return ds;
}
public Ledgers.APARMAINDataTable GetSupCustUnPaidInvoices(string refno, string ctype)
{
var ta = new LedgersTableAdapters.APARMAINTableAdapter {Connection = {ConnectionString = _constr}};
var ds = new Ledgers().APARMAIN;
ta.FillByCustSup(ds, ctype, refno, Utils.Company);
return ds;
}
public string DoSave(Ledgers.ARAPRECEIPTSRow drmain,Ledgers.ARAPRECEIPTSDETAILSDataTable dt)
{
SqlTransaction tran = null;
var isnew = false;
string retval = string.Empty;
try
{
var cn = new SqlConnection (_constr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var taPurPaid = new ARAPRECEIPTSTableAdapter {Connection = {ConnectionString = _constr}};
var dtmain = new Ledgers.ARAPRECEIPTSDataTable();
var ds = taPurPaid.Fill(dtmain);
var taPurPaidDet = new ARAPRECEIPTSDETAILSTableAdapter();
var taApAr = new LedgersTableAdapters.APARMAINTableAdapter();
var taLedger = new LedgersTableAdapters.LEDGERSTableAdapter();
taLedger.AssignConnection(cn, tran);
taPurPaid.AssignConnection(cn,tran);
var dm = new DataManager();
taPurPaidDet.AssignConnection(cn,tran);
var dr = dtmain.FindByARAPTRANID(drmain.ARAPTRANID);
if (dr != null)
{
dr.BeginEdit();
}
else
{
dr = (Ledgers.ARAPRECEIPTSRow) dtmain.NewRow();
Utils.PurPayment = dm.GetAutoId(19).ToString("D6");
drmain.ARAPTRANID =Utils.PurPayment;
dr.ARAPTRANID = Utils.PurPayment;
isnew = true;
}
dr.AMOUNT = drmain.AMOUNT;
dr.TDATE = drmain.TDATE;
dr.BANKID = drmain.BANKID;
dr.POSTED = false;
string cmdtxt = string.Empty;
foreach (Ledgers.ARAPRECEIPTSDETAILSRow drdet in dt.Rows)
{
if (drdet.RowState != DataRowState.Deleted)
{
drdet.ARAPTRANID = dr.ARAPTRANID;
cmdtxt = "update APARMAIN set PAIDAMOUNT = " + drdet.AppliedAmt +
", BALANCE = 0 where TRANID = " + drdet.TRANID;
var cmd = new SqlCommand(cmdtxt, cn, tran);
cmd.ExecuteNonQuery();
taLedger.Insert("S", drdet.REFNO, DateTime.Now.Date, drdet.INVOICEDATE, dr.ARAPTRANID,drdet.INVOICENO, drdet.INVAMOUNT,0, 18, Utils.Company, Utils.Userid, "Purchase Payment");
}
}
if (isnew)
{
dtmain.Rows.Add(dr);
taPurPaid.Update(dtmain);
}
else
{
dr.EndEdit();
taPurPaid.Update(dr);
}
taPurPaidDet.Update(dt);
tran.Commit();
dm.UpdateAutoNum(19);
retval = "1";
}
catch (Exception ex)
{
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
public int InsertUpdateLedgers(Ledgers objLdgr, SqlConnection con)
{
int ID = 0;
try
{
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "spInsertUpdateLedgers";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@LedgerID", SqlDbType.Int).Value = objLdgr.LedgerID;
com.Parameters.Add("@LedgerName", SqlDbType.VarChar, 100).Value = objLdgr.LedgerName;
com.Parameters.Add("@LedgerTypeID", SqlDbType.Int).Value = objLdgr.LedgerTypeID;
com.Parameters.Add("@Address", SqlDbType.VarChar, 500).Value = objLdgr.Address;
com.Parameters.Add("@CountryID", SqlDbType.Int).Value = objLdgr.CountryID;
com.Parameters.Add("@CurrencyID", SqlDbType.Int).Value = objLdgr.CurrencyID;
com.Parameters.Add("@ContactPerson", SqlDbType.VarChar, 500).Value = objLdgr.ContactPerson;
if (objLdgr.BankAccountType == "NULL")
{
com.Parameters.Add("@bankAccType", SqlDbType.VarChar, 500).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@bankAccType", SqlDbType.VarChar, 500).Value = objLdgr.BankAccountType;
}
com.Parameters.Add("@BusinessType", SqlDbType.VarChar, 500).Value = objLdgr.BusinessType;
com.Parameters.Add("@Phone", SqlDbType.VarChar, 100).Value = objLdgr.Phone;
com.Parameters.Add("@Fax", SqlDbType.VarChar, 100).Value = objLdgr.Fax;
com.Parameters.Add("@Email", SqlDbType.VarChar, 100).Value = objLdgr.Email;
if (objLdgr.TeamMemberID == -1)
{
com.Parameters.Add("@TeamID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@TeamID", SqlDbType.Int).Value = objLdgr.TeamMemberID;
}
com.Parameters.Add("@Remarks", SqlDbType.VarChar, 500).Value = objLdgr.Remarks;
if (objLdgr.AccountID == -1)
{
com.Parameters.Add("@AccountID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@AccountID", SqlDbType.Int).Value = objLdgr.AccountID;
}
if (objLdgr.LedgerID <= 0)
{
SqlParameter retValParam = com.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
retValParam.Direction = System.Data.ParameterDirection.ReturnValue;
com.ExecuteNonQuery();
ID = Convert.ToInt32(retValParam.Value);
//SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(TransMID),0) FROM T_Transaction_Master", con, trans);
//ID = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
com.ExecuteNonQuery();
ID = objLdgr.LedgerID;
// ID = Convert.ToInt32(com.Parameters["@TransMID"].Value);
}
//com.ExecuteNonQuery();
//if (objLdgr.LedgerID == 0)
//{
// SqlCommand cmd = new SqlCommand("SELECT ISNULL(MAX(LedgerID),0) FROM T_Ledgers", con, trans);
// ID = Convert.ToInt32(cmd.ExecuteScalar());
//}
//else
// ID = objLdgr.LedgerID;
}
catch (Exception ex)
{
throw ex;
}
return(ID);
}
public string DoUploadPromotionItems(Ledgers.PROMOITEMSDataTable dtp,bool isRemote)
{
string retval;
SqlTransaction tran = null;
try
{
//isRemote true mean data downloading in local machine , isremote false mean data uploading in sync
if (isRemote)
_syncConstr = Utils.Connectionstring;
var cn = new SqlConnection(_syncConstr);
cn.Open();
tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
var ds = new Ledgers();
//var dt = ds.COMMISIONMAST;
var dtdetail = ds.PROMOITEMS;
var taCommMain = new PROMOITEMSTableAdapter();
taCommMain.AssignConnection(cn, tran);
var clstock = new StockMaster();
var clitem = new ItemMaster();
foreach (Ledgers.PROMOITEMSRow ditemdetarow in dtp.Rows)
{
var newdetrow = dtdetail.NewRow();
//dtdetail.TIDColumn.AutoIncrement = false;
//dtdetail.TIDColumn.ReadOnly = false;
if (isRemote)
{
clstock.UpdateSpriceByItemno(ditemdetarow.ITEMNO, ditemdetarow.NEWPRICE, ref cn, ref tran);
clitem.UpdateSpriceByItemno(ditemdetarow.ITEMNO, ditemdetarow.NEWPRICE, ref cn, ref tran);
}
foreach (DataColumn dc in dtp.Columns)
{
//if (!dc.ReadOnly)
//{
newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
// }
}
dtdetail.Rows.Add(newdetrow);
}
taCommMain.Update(dtdetail);
tran.Commit();
retval = "1";
}
catch (Exception ex)
{
if (tran != null)
tran.Rollback();
retval = ex.ToString();
}
return retval;
}
private void LoadLedgers()
{
_ledgers = _checkbook.LoadLedgers();
BindingList<Ledger> blist = new BindingList<Ledger>(_ledgers);
dataGridView1.DataSource = blist;
}
public string UpdatePointsDetails(Ledgers.CUSTOMERPOINTSRow dr)
{
return new Customer().UpdatePointsDetails(dr.CUSTNO,dr.POINTS,dr.COMP,dr.REDIMDT, dr.REDMIVOU,dr.REDIMAMT, true, _syncConstr);
}
