public ActionResult Update(int id)
{
var model = new BranchModel
{
Branch = manager.Get(id)
};
return(View(model));
}
protected override void BindData()
{
if (ID > 0)
{
var table = BranchManager.Get(ID);
if (table.Count == 0)
{
throw new ArgumentException("მონაცემი არ მოიძებნა.");
}
CompanyID = table[0].CompanyID;
Code = table[0].Code;
BranchName = table[0].Name;
Address = table[0].Address;
Phone = table[0].Phone;
Fax = table[0].Fax;
ActFormat = table[0].ActFormat;
ID = table[0].ID;
Status = (DatabaseStatus)table[0].StatusID;
ModifierID = table[0].ModifierID;
ModifiedDate = table[0].ModifiedDate;
ApproverID = table[0].ApproverID;
}
else
{
ModifierID = BaseGlobalVariable.UserID;
ModifiedDate = BaseGlobalVariable.ServerDateTime;
}
}
public ActionResult Delete(int id)
{
var organization = _branchManager.Get(id);
if (organization == null)
{
return(HttpNotFound());
}
_branchManager.Remove(organization);
return(View("BranchList"));
}
private void Print(Reports.ReportName reportName)
{
try
{
Application.DoEvents();
Cursor = Cursors.WaitCursor;
var rate1 = DictionaryManager.GetCurrencyRate(CurrencyCode, StartDate);
var rate2 = DictionaryManager.GetCurrencyRate(GlobalVariable.MyCompanyConditionalUnitCurrencyCode, StartDate);
var crossRate = rate2 / rate1;
var ds = new Zek.DataModel.DS_TradeOrder();
Zek.DataModel.DS_TradeOrder.T_HeaderRow hrow = ds.T_Header.NewT_HeaderRow();
hrow.HeaderID = ProductDistributionID;
hrow.OrderNumber = ProductDistributionID.ToString();
hrow.OrderDate = StartDate;
hrow.SubTotal = SubTotal;
hrow.VATAmt = TaxAmt;
hrow.Freight = Freight;
hrow.TotalDue = TotalDue;
hrow.CurrencyCode = CurrencyCode;
hrow.CurrencyName = NumToStrHelper.ToCurrencyName(CurrencyCode);
hrow.CurrencyCoin = NumToStrHelper.ToCurrencyCoin(CurrencyCode);
hrow.CurrencyRate = rate2;
hrow.ProductCurrencyRate = rate2;
hrow.VendorName = GlobalVariable.MyCompanyName + " (" + lookFromBranch.Text + ")";
hrow.VendorTaxCode = GlobalVariable.MyCompanyTaxCode;
hrow.VendorAddress = GlobalVariable.MyCompanyAddress;
hrow.VendorPhone = GlobalVariable.MyCompanyPhone;
hrow.CustomerName = GlobalVariable.MyCompanyName + " (" + lookToBranch.Text + ")";
hrow.CustomerTaxCode = GlobalVariable.MyCompanyTaxCode;
hrow.CustomerAddress = GlobalVariable.MyCompanyAddress;
hrow.CustomerPhone = GlobalVariable.MyCompanyPhone;
var fromBranch = BranchManager.Get(FromBranchID);
if (fromBranch.Count > 0)
{
hrow.ShipperName = GlobalVariable.MyCompanyName + " (" + fromBranch[0].Name + ")";
hrow.ShipperTaxCode = GlobalVariable.MyCompanyTaxCode;
hrow.ShipperAddress = fromBranch[0].Address;
hrow.ShipperPhone = fromBranch[0].Phone;
hrow.VendorAddress = hrow.ShipperAddress;
hrow.VendorPhone = hrow.ShipperPhone;
}
var toBranch = BranchManager.Get(ToBranchID);
if (toBranch.Count > 0)
{
hrow.ShipToName = GlobalVariable.MyCompanyName + " (" + fromBranch[0].Name + ")";
hrow.ShipToTaxCode = GlobalVariable.MyCompanyTaxCode;
hrow.ShipToAddress = toBranch[0].Address;
hrow.ShipToPhone = toBranch[0].Phone;
hrow.CustomerAddress = hrow.ShipToAddress;
hrow.CustomerPhone = hrow.ShipToPhone;
}
ds.T_Header.AddT_HeaderRow(hrow);
if (!string.IsNullOrEmpty(GlobalVariable.MyCompanyBankName))
{
ds.T_Header[0].VenderBankInfo = GlobalVariable.MyCompanyBankName;
}
if (!string.IsNullOrEmpty(GlobalVariable.MyCompanyBankCode))
{
ds.T_Header[0].VenderBankInfo += ", კოდი " + GlobalVariable.MyCompanyBankCode;
}
if (!string.IsNullOrEmpty(GlobalVariable.MyCompanyBankAccountNumber))
{
ds.T_Header[0].VenderBankInfo += ", ა/ა " + GlobalVariable.MyCompanyBankAccountNumber;
}
ds.T_Header[0].VenderBankInfo = ds.T_Header[0].VenderBankInfo.TrimStart(' ', ',');
var i = 1;
foreach (var row in ds_Production.SP_GetProductDistributionDetail)
{
Zek.DataModel.DS_TradeOrder.T_DetailRow newRow = ds.T_Detail.NewT_DetailRow();
newRow.HeaderID = ProductDistributionID;
newRow.DetailID = i++;
newRow.Line = row.OrdinalNumber;
newRow.ProductName = row.MedicamentName;
if (!row.IsSerieNull())
{
newRow.Serie = row.Serie;
}
newRow.Quantity = row.DistributeQty;
newRow.UnitMeasure = "ცალი";
newRow.UnitPrice = row.UnitPrice;
newRow.StockedQty = row._ResidualQty;
newRow.PackQty = row.UnitsInStock;
if (!row.IsValidDateNull())
{
newRow.ValidDate = row.ValidDate;
}
newRow.Manufacturer = (!row.IsBrandNameNull() ? row.BrandName + " " : string.Empty);
if (!row.IsCountryNameNull())
{
newRow.ManufactureCountry = row.CountryName;
}
ds.T_Detail.AddT_DetailRow(newRow);
}
Zek.Report.ReportHelper.Show(MdiParent, Text, reportName, ds);
//ReportViewerForm.Show(MdiParent, Text, reportName, ds);
}
catch (Exception ex)
{
ExceptionHelper.Show(this, ex, "შეცდომა ამობეჭვდისას", MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
protected override bool SaveData()
{
foreach (CheckedListBoxItem item in chklstTable.Items)
{
if (item.CheckState != CheckState.Checked || !item.Enabled)
{
continue;
}
var objectName = (ObjectNames)ConvertHelper.ToInt32(item.Value);
var modifiedDate = SynchronizationManager.GetDate(objectName, false);
var table = new DataTable();
switch (objectName)
{
case ObjectNames.SynchronizeDate:
Win32Native.SetLocalTime(SynchronizationManager.GetDate(ObjectNames.None, true));
InitSynchronizedCheckedListBoxItem(item);
break;
//case ObjectNames.SalesOrderHeader:
// DateTime serverDateTime = SynchronizationManager.GetDate(ObjectNames.None, true);
// DS_Sales.SP_GetSalesOrderHeaderDataTable header = Apothex.DataManagment.Sales.SalesManager.GetSalesOrderHeader(serverDateTime.Date, false);
// DS_Sales.SP_GetSalesOrderDetailDataTable detail = Apothex.DataManagment.Sales.SalesManager.GetSalesOrderDetail(serverDateTime.Date, false);
// DS_Card.T_CardHandleDataTable card = CardManager.GetCardHandle(serverDateTime.Date, false);
// using (DataSet ds = new DataSet("root"))
// {
// DataSetHelper.SetColumnMappingType(header);
// DataSetHelper.SetColumnMappingType(detail);
// DataSetHelper.SetColumnMappingType(card);
// DataSetHelper.RemoveColumns(header, true,
// header.SalesOrderIDColumn,
// header.BranchIDColumn,
// header.OrderDateColumn,
// header.OverheadNumberColumn,
// header.CustomerIDColumn,
// header.SubTotalColumn,
// header.TaxAmtColumn,
// header.FreightColumn,
// header.CurrencyCodeColumn,
// header.CurrencyRateIDColumn,
// header.PaymentMethodIDColumn,
// header.RevisionNumberColumn,
// header.StatusColumn,
// header.ModifiedUserIDColumn,
// header.ModifiedDateColumn,
// header.ApproverUserIDColumn,
// header.rowguidColumn
// );
// DataSetHelper.RemoveColumns(detail, true, detail.SalesOrderDetailIDColumn,
// detail.SalesOrderIDColumn,
// detail.ProductLocationIDColumn,
// detail.SaleQtyColumn,
// detail.UnitPriceColumn,
// detail.UnitPriceDiscountColumn,
// detail.OrdinalNumberColumn,
// detail.ModifiedUserIDColumn,
// detail.ModifiedDateColumn,
// detail.ActionColumn
// );
// ds.Tables.Add(header);
// ds.Tables.Add(detail);
// ds.Tables.Add(card);
// Synchronize(objectName, ds, true);
// ds.Tables.Remove(detail);
// ds.Tables.Remove(card);
// DataSetHelper.RemoveColumns(header, true, header.SalesOrderIDColumn);
// Synchronize(objectName, ds, false);
// InitSynchronizedCheckedListBoxItem(item);
// }
// break;
case ObjectNames.SalesOrderHeader:
SynchronizationManager.SynchronizeSalesOrder(0);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.ProductLocation:
table = SynchronizationManager.GetSyncProductLocation(0, 0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.Currency:
table = SynchronizationManager.GetSyncCurrency(string.Empty, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.CardUnitRate:
table = SynchronizationManager.GetSyncCardUnitRate();
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.CardDiscountSchema:
table = SynchronizationManager.GetSyncCardDiscountSchema();
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.MyCompany:
var mycompany = SynchronizationManager.GetSyncMyCompany(0, modifiedDate, DatabaseAction.Synchronize);
if (mycompany.Count > 0)
{
var branch = BranchManager.Get(GlobalVariable.BranchID);
if (branch.Count > 0 && !branch[0].IsCompanyIDNull())
{
var company = PersonManager.GetCompany(branch[0].CompanyID);
if (company.Count > 0)
{
mycompany[0].MyCompanyName = company[0].Name;
mycompany[0].TaxCode = company[0].TaxCode;
mycompany[0].DirectorName = string.Empty;
mycompany[0].CountryCode = company[0].CountryCode;
mycompany[0].City = string.Empty;
mycompany[0].Address = company[0].Address;
mycompany[0].Phone = company[0].Phone;
mycompany[0].Fax = company[0].Fax;
if (!company[0].IsBankIDNull())
{
mycompany[0].BankID = company[0].BankID;
}
else
{
mycompany[0].SetBankIDNull();
}
mycompany[0].BankAccountNumber = company[0].BankAccountNumber;
}
}
}
table = mycompany;
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.Branch:
table = SynchronizationManager.GetSyncBranch(0, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.User:
table = SynchronizationManager.GetSyncUser(0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.UserPermission:
table = SynchronizationManager.GetSyncUserPermission(0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.PaymentMethod:
table = SynchronizationManager.GetSyncPaymentMethod(0, modifiedDate, DatabaseAction.Synchronize);
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
case ObjectNames.OperationType:
table = SynchronizationManager.GetOperationType();
Synchronize(objectName, table, false);
InitSynchronizedCheckedListBoxItem(item);
break;
}
}
return(true);
}
