private void TxtToCurrencyId_TextChanged(object sender, EventArgs e)
{
if (int.TryParse(txtToCurrencyId.Text, out int currencyid))
{
txtToCurrencyEnglish.Text = DBControllersFactory.FK(MODELS.Currency, currencyid);
}
}
public ServiceForm()
{
InitializeComponent(); if (DesignMode || (Site != null && Site.DesignMode))
{
return;
}
CntrlCN = DBControllersFactory.Contract();
CntrlCG = DBControllersFactory.BillingCategory();
CntrlCU = DBControllersFactory.Currency();
CntrlVT = DBControllersFactory.VAT();
//template
Mapper["Id"] = txtId;
Mapper["CreatedBy"] = txtCreatedBy;
Mapper["CreatedOn"] = txtCreatedOn;
Mapper["UpdatedBy"] = txtUpdatedBy;
Mapper["UpdatedOn"] = txtUpdatedOn;
Mapper["ReadOnly"] = chkReadOnly;
//data
Mapper["BillingCategoryId"] = txtBillingCategoryId;
Mapper["ContractId"] = txtContractId;
Mapper["CurrencyId"] = txtCurrencyId;
Mapper["Price"] = txtPrice;
Mapper["Expired"] = chkExpired;
Mapper["EffectiveFromDate"] = txtEffectiveFromDate;
Mapper["VATId"] = txtVATId;
//actions
SaveButton = btnSave;
DeleteButton = btnDelete;
NewButton = btnNew;
//pick lists
PickList[btnPLContract] = txtContractId;
PickList[btnPLCurrency] = txtCurrencyId;
PickList[btnPLService] = txtId;
PickList[btnPLVAT] = txtVATId;
}
private static void InitContextMenuTranslate()
{
cms.Items.Add(tsmi);
tsmi.Click += (xs, xe) => {
if (MainView.Instance.CntrlWD.GetCurrentLanguageId() == 0)
{
return;
}
Control lcntrl = ((ContextMenuStrip)((ToolStripMenuItem)xs).Owner).SourceControl;
var txt = lcntrl.Text;
var trn = InputBox.Prompt("Translate", $"Translate [{txt}] to:");
if (trn != null)
{
WordModel wm = new WordModel {
WordInEnglish = txt
};
WordModel fw = MainView.Instance.CntrlWD.Find(wm, "WordInEnglish");
if (fw == null)
{
MainView.Instance.CntrlWD.Save(wm);
}
wm = MainView.Instance.CntrlWD.Select(wm, "Id", false, "WordInEnglish").FirstOrDefault();
WordLanguageModel wlm = new WordLanguageModel {
WordInLanguage = trn,
LanguageId = MainView.Instance.CntrlWD.GetCurrentLanguageId(),
WordId = wm.Id
};
DBControllersFactory.WordLanguage().Save(wlm);
lcntrl.Text = trn;
MainView.Instance.CntrlWD[txt] = trn;
}
};
}
private ProfileEntitlementView OpenProfileEntitlement(ProfileEntitlementModel pe)
{
var form = new Form();
var view = (ProfileEntitlementForm)DBViewsFactory.GetView(MODELS.ProfileEntitlement);
pe.ProfileId = Model.Id;
view.SetModel(pe);
view.Dock = DockStyle.Fill;
form.Controls.Add(view);
form.FormBorderStyle = FormBorderStyle.FixedToolWindow;
form.StartPosition = FormStartPosition.CenterScreen;
form.Size = new System.Drawing.Size(430, 430);
view.SetNewButtonEnabled(false);
view.SetDeleteButtonEnabled(false);
view.DisableChangeProfile();
bool isnew = pe.Id == 0;
view.AfterSave += (b) => {
pe.EntitlementId = view.Model.EntitlementId;
pe.ProfileId = view.Model.ProfileId;
var model = DBControllersFactory.ProfileEntitlement().Find(pe, "ProfileId", "EntitlementId");
if (isnew)
{
profileEntitlements.Add(model);
}
else
{
profileEntitlements[profileEntitlements.IndexOf(profileEntitlements.Where(x => x.Id == pe.Id).First())] = model;
}
RequeryEntitlements();
form.Close();
};
form.Show();
return(view);
}
public ProfileForm()
{
InitializeComponent(); if (DesignMode || (Site != null && Site.DesignMode))
{
return;
}
//template
Mapper["Id"] = PickList[btnPLProfile] = txtId;
Mapper["CreatedBy"] = txtCreatedBy;
Mapper["CreatedOn"] = txtCreatedOn;
Mapper["UpdatedBy"] = txtUpdatedBy;
Mapper["UpdatedOn"] = txtUpdatedOn;
Mapper["ReadOnly"] = chkReadOnly;
//data
Mapper["ProfileName"] = txtProfileName;
Mapper["ProfileDesc"] = txtProfileDesc;
//actions
SaveButton = btnSave;
DeleteButton = btnDelete;
NewButton = btnNew;
//pick lists
PickList[btnPLEntitlementGroup] = txtEntitlementGroupId;
entitlements = DBControllersFactory.Entitlement().Read().ToList();
}
internal void WhenAuthenticated(UserModel um)
{
UserController CntrlUS = DBControllersFactory.User();
var menu = CntrlUS.GetMenu(um);
var megs = new Dictionary <string, TreeViewItem>();
foreach (var t in menu)
{
if (megs.ContainsKey(t.Item1) == false)
{
megs[t.Item1] = new TreeViewItem {
Name = t.Item1, Header = t.Item1
};
Tree.Items.Add(megs[t.Item1]);
}
TreeViewItem mitem = new TreeViewItem {
Name = t.Item3, Header = t.Item2
};
megs[t.Item1].Items.Add(mitem);
if ("Word".Equals(mitem.Header))
{
mitem.Foreground = Brushes.Red;
mitem.MouseDoubleClick += (s, e) => {
TabItem tabItem = new TabItem()
{
Content = new DictionaryUC()
};
Tab.Items.Add(tabItem);
tabItem.Header = "Word";
tabItem.IsSelected = true;
};
}
}
}
private void BtnEditPE_Click(object sender, EventArgs e)
{
var model = new ProfileEntitlementModel {
Id = lstProfileEntitlements.SelectedValue.ToInteger()
};
OpenProfileEntitlement(model).SetModel(DBControllersFactory.ProfileEntitlement().Find(model, "Id"));
}
public UserController()
{
CntrlAU = DBControllersFactory.Audit();
CntrlEG = DBControllersFactory.EntitlementGroup();
CntrlET = DBControllersFactory.Entity();
CntrlEN = DBControllersFactory.Entitlement();
CntrlPE = DBControllersFactory.ProfileEntitlement();
}
private void TxtId_TextChanged(object sender, EventArgs e)
{
profileEntitlements = DBControllersFactory.ProfileEntitlement().Read(new ProfileEntitlementModel()
{
ProfileId = Model.Id
}, "ProfileId").ToList();
txtEntitlementGroupId.Text = "";
RequeryEntitlements();
RequeryUsers();
}
private void BtnDeletePE_Click(object sender, EventArgs e)
{
int peId = lstProfileEntitlements.SelectedValue.ToInteger();
DBControllersFactory.ProfileEntitlement().Delete(new ProfileEntitlementModel {
Id = peId
});
profileEntitlements.RemoveAt(profileEntitlements.IndexOf(profileEntitlements.Where(x => x.Id == peId).First()));
lstProfileEntitlements.Items.RemoveAt(lstProfileEntitlements.SelectedIndices[0]);
}
public WordController() : base()
{
CurrentLanguage = LanguageState.Default;
CntrlWL = DBControllersFactory.WordLanguage();
CntrlLG = DBControllersFactory.Language();
foreach (var w in Select(new WordModel {
}, "Id,WordInEnglish"))
{
en[w.WordInEnglish] = w.WordInEnglish;
}
}
public void AddRowFromArray(object[] cells)
{
var item = new ListViewItem(DBControllersFactory.GetFKSource(Columns[0].Name, cells[0].ToString()));
for (int i = 1; i < Columns.Count; i++)
{
item.SubItems.Add(DBControllersFactory.GetFKSource(Columns[i].Name, cells[i]));
}
if ("".Equals(Filter) || (item + ":" + string.Join("|", item.SubItems.OfType <ListViewItem.ListViewSubItem>().Select(x => x.Text))).ToLower().Contains(Filter.ToLower()))
{
Items.Add(item);
}
}
private MainView()
{
InitializeComponent(); if (DesignMode || (Site != null && Site.DesignMode))
{
return;
}
CntrlLG = DBControllersFactory.Language();
CntrlWD = DBControllersFactory.Word();
CntrlEG = DBControllersFactory.EntitlementGroup();
CntrlEN = DBControllersFactory.Entitlement();
CntrlET = DBControllersFactory.Entity();
CntrlPE = DBControllersFactory.ProfileEntitlement();
CntrlUS = DBControllersFactory.User();
}
protected void Page_Load(object sender, EventArgs e)
{
MVCHISSession.Instance.Initialize();
CntrlDC = DBControllersFactory.Word();
foreach (var dm in CntrlDC.Read())
{
DropDownList1.Items.Add(dm.Id.ToString());
}
//DropDownList1.DataSource = CntrlDC.Read();
//DropDownList1.DataValueField = "Id";
//DropDownList1.DataTextField = "WordInEnglish";
}
public void InitializeDBValues() {
foreach (var pe in Read()) { Delete(pe); }
var es = DBControllersFactory.Entitlement().Read();
var ps = DBControllersFactory.Profile().Read();
foreach(ProfileModel p in ps) {
foreach(EntitlementModel e in es) {
Save(new ProfileEntitlementModel() {
ProfileId=p.Id,
EntitlementId=e.Id,
AllowRead=true,
AllowUpdate=true,
AllowCreate=true,
});
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
UserModel um = new UserModel {
UserName = txtUserName.Text,
UserPassword = txtPassword.Password
};
UserController controller = DBControllersFactory.User();
if (controller.Autheniticate(um) == null)
{
MessageBox.Show("Access Denied");
}
else
{
//MessageBox.Show("Successful");
MainWindow.Instance.WhenAuthenticated(um);
}
}
private void SQLView_Load(object sender, EventArgs e)
{
contextMenuStripEntities.Items.Clear();
Dictionary <char, ToolStripMenuItem> parent = new Dictionary <char, ToolStripMenuItem>();
foreach (var entity in DBControllersFactory.Entity().Read().OrderBy(x => x.EntityName))
{
char pname = entity.EntityName[0];
if (parent.ContainsKey(pname) == false)
{
parent[pname] = new ToolStripMenuItem($"{pname}");
contextMenuStripEntities.Items.Add(parent[pname]);
}
parent[pname].DropDownItems.Add(entity.EntityName).Click += (ms, me) => {
txtSQL.Text = controller.GetDLL(entity.EntityName);
};
}
}
private void BtnEditWordInLanguage_Click(object sender, EventArgs e)
{
if (lstWordInLanguages.SelectedIndices.Count > 0)
{
int index = lstWordInLanguages.SelectedIndices[0];
WordLanguageView view = OpenWordLanguage(WordLanguages[index]);
view.AfterSave += delegate(bool status) {
if (status)
{
WordLanguages[index] = view.Model;
ListViewItem item = new ListViewItem();
item.SubItems[0].Text = view.Model.Id.ToString();
item.SubItems[1].Text = DBControllersFactory.FK(MODELS.Language, view.Model.LanguageId);
item.SubItems[2].Text = view.Model.WordInLanguage;
lstWordInLanguages.Items[index] = item;
}
};
}
}
public ContractForm()
{
InitializeComponent(); if (DesignMode || (Site != null && Site.DesignMode))
{
return;
}
CntrlCL = DBControllersFactory.Client();
CntrlCG = DBControllersFactory.BillingCategory();
CntrlSR = DBControllersFactory.Service();
CntrlCU = DBControllersFactory.Currency();
CntrlVT = DBControllersFactory.VAT();
//template
Mapper["Id"] = txtId;
Mapper["CreatedBy"] = txtCreatedBy;
Mapper["CreatedOn"] = txtCreatedOn;
Mapper["UpdatedBy"] = txtUpdatedBy;
Mapper["UpdatedOn"] = txtUpdatedOn;
Mapper["ReadOnly"] = chkReadOnly;
//data
Mapper["ContractCode"] = txtContractCode;
Mapper["StartDate"] = txtStartDate;
Mapper["EndDate"] = txtEndDate;
Mapper["ClientId"] = txtClientId;
Mapper["IsActive"] = chkIsActive;
Mapper["Conditions"] = txtConditions;
//actions
SaveButton = btnSave;
DeleteButton = btnDelete;
NewButton = btnNew;
//pick lists
PickList[btnPLClient] = txtClientId;
PickList[btnPLContract] = txtId;
Services = new List <ServiceModel>();
ModelChanged = delegate() {
Console.WriteLine("-==================== model changed");
RequeryServicesGrid();
};
}
protected void Page_Load(object sender, EventArgs e)
{
CntrlUS = DBControllersFactory.User();
CntrlPE = DBControllersFactory.ProfileEntitlement();
MVCHIS.Common.MVCHISSession.Instance.Initialize();
Login1.Visible = MVCHISSession.Instance.CurrentUser == null;
//DictionaryUC1.Visible = false;
Login1.GoClicked += (um) => {
UserController uc = DBControllersFactory.User();
um = uc.Autheniticate(um);
if (um == null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "error", "alert('Login denied')", true);
}
else
{
WhenAuthenticated(um);
}
};
}
//private CountryController CntrlCY;
public ClientForm()
{
InitializeComponent(); if (DesignMode || (Site != null && Site.DesignMode))
{
return;
}
//template
Mapper["Id"] = txtId;
Mapper["CreatedBy"] = txtCreatedBy;
Mapper["CreatedOn"] = txtCreatedOn;
Mapper["UpdatedBy"] = txtUpdatedBy;
Mapper["UpdatedOn"] = txtUpdatedOn;
Mapper["ReadOnly"] = chkReadOnly;
//data
Mapper["ClientTypeId"] = txtClientTypeId;
Mapper["ShortName"] = txtShortName;
Mapper["LongName"] = txtLongName;
Mapper["NameArabic"] = txtNameArabic;
Mapper["DateOfBirth"] = txtDateOfBirth;
Mapper["IsActive"] = chkIsActive;
Mapper["BillingAddress"] = txtBillingAddress;
Mapper["PhoneNumber"] = txtPhoneNumber;
Mapper["FaxNumber"] = txtFaxNumber;
Mapper["Website"] = txtWebsite;
Mapper["CountryId"] = txtCountryId;
//actions
SaveButton = btnSave;
DeleteButton = btnDelete;
NewButton = btnNew;
//pick lists
PickList[btnPLCountry] = txtCountryId;
PickList[btnPLClientType] = txtClientTypeId;
PickList[btnPLClientShortName] = txtId;
CntrlCO = DBControllersFactory.Contact();
CntrlCI = DBControllersFactory.ClientIdentification();
CntrlID = DBControllersFactory.Identification();
CntrlCC = DBControllersFactory.ClientContact();
}
private void TxtProfileId_TextChanged(object sender, EventArgs e)
{
txtProfileName.Text = DBControllersFactory.FK(MODELS.Profile, txtProfileId.Text);
}
private void TxtClient_TextChanged(object sender, EventArgs e)
{
txtClientShortName.Text = DBControllersFactory.FK(MODELS.Client, txtClientId.Text);
}
private void TxtIdentificationType_TextChanged(object sender, EventArgs e)
{
txtIdentificationTypeEnglish.Text = DBControllersFactory.FK(MODELS.IdentificationType, txtIdentificationTypeId.Text);
}
private void TxtCityId_TextChanged(object sender, EventArgs e)
{
txtCityEnglish.Text = DBControllersFactory.FK(MODELS.City, txtCityId.Text);
}
private void TxtCountryId_TextChanged(object sender, EventArgs e)
{
txtCountryCode.Text = DBControllersFactory.FK(MODELS.Country, txtCountryId.Text);
}
private void TxtCompoundId_TextChanged(object sender, EventArgs e)
{
txtCompoundName.Text = DBControllersFactory.FK(MODELS.Compound, txtCompoundId.Text);
}
private void TxtBuildingTypeId_TextChanged(object sender, EventArgs e)
{
txtBuildingTypeCode.Text = DBControllersFactory.FK(MODELS.BuildingType, txtBuildingTypeId.Text);
}
private void TxtId_TextChanged(object sender, EventArgs e)
{
txtUserName.Text = DBControllersFactory.FK(MODELS.User, txtId.Text);
}
public void Test()
{
MVCHIS.Common.MVCHISSession.Instance.Initialize();
json(DBControllersFactory.Room().Read());
}
