public AddEditRole(string code)
{
this.code = code;
InitializeComponent();
addOrEdit = false;
Connect.GetItem("role", code);
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["Name"];
}
public AddEditPoints(string p)
{
itemCode = p;
InitializeComponent();
addOrEdit = false;
Connect.GetItem("point", itemCode);
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["Name"];
tInfo.Text = Connect.Items["Prim"];
}
public AddEditClient(string _code)
{
InitializeComponent();
code = _code;
Connect.GetItem("client", code);
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["name"];
tSName.Text = Connect.Items["surname"];
tPatron.Text = Connect.Items["patronymic"];
tTel.Text = Connect.Items["tel"];
}
private void cbService_SelectedIndexChanged(object sender, EventArgs e)
{
if (!mode && !editState)
{
DataRow[] rows = service.Select($"Name='{cbService.SelectedItem.ToString()}'");
string id = rows[0][0].ToString();
Connect.GetItem("service", id);
tSumToPay.Text = Connect.Items["Price"];
}
else
{
}
}
public AddEditReport(string item, string code)
{
InitializeComponent();
FontsLoad();
tabBody.Enabled = false;
this.Width = 530; //
this.code = code;
this.item = item;
Connect.GetItem("report", item);
tName.Text = Connect.Items["name"];
ParseText(Connect.Items["textbody"], Connect.Items["sqlbody"]);
}
public AddEditReport(string item)
{
InitializeComponent();
FontsLoad();
Connect.GetItem("report", item);
rtbBody.Text = Connect.Items["textbody"];
tQuery.Text = Connect.Items["sqlbody"];
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["name"];
lItems.Items.Add("ObjID");
this.Width = 690;
this.item = item;
}
public AddEditService(string _code)
{
InitializeComponent();
addOrEdit = false;
code = _code;
for (int i = 0; i < table.Rows.Count; i++)
{
cbPoints.Items.Add(table.Rows[i][1].ToString());
}
code = _code;
addOrEdit = false;
Connect.GetItem("service", code);
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["Name"];
tPrice.Text = Connect.Items["Price"];
}
public AddEditMaster(string _code)
{
InitializeComponent();
for (int i = 0; i < table.Rows.Count; i++)
{
cbPoints.Items.Add(table.Rows[i][1].ToString());
}
code = _code;
addOrEdit = false;
Connect.GetItem("master", code);
tCode.Text = Connect.Items["id"];
tName.Text = Connect.Items["Name"];
tFullName.Text = Connect.Items["FullName"];
cbPoints.SelectedItem = Connect.Items["Point_ID"];
cbIsActive.Checked = Convert.ToBoolean(Int16.Parse(Connect.Items["isactive"]));
}
public AddEditUser(string _code)
{
InitializeComponent();
addOrEdit = false;
code = _code;
for (int i = 0; i < points.Rows.Count; i++)
{
cbPoints.Items.Add(points.Rows[i][1].ToString());
}
for (int i = 0; i < roles.Rows.Count; i++)
{
cbRole.Items.Add(roles.Rows[i][1].ToString());
}
Connect.GetItem("user", code);
tCode.Text = Connect.Items["id"];
tLogin.Text = Connect.Items["Login"];
tName.Text = Connect.Items["UserName"];
tFullname.Text = Connect.Items["FullName"];
tPassword.Text = Connect.Items["Password"];
cbIsActive.Checked = Convert.ToBoolean(Int16.Parse(Connect.Items["isactive"]));
}
private void GetData(string code)
{
Connect.GetItem("card", code);
this.Text = this.Text + " " + Connect.Items["id"];
tClentSName.Text = Connect.Items["family"];
tClentName.Text = Connect.Items["clientname"];
tClientPatron.Text = Connect.Items["patron"];
tClientTel.Text = Connect.Items["tel"];
cbService.SelectedItem = Connect.Items["service"];
cbMaster.SelectedItem = Connect.Items["master"];
dtPlanDelivery.Value = Convert.ToDateTime(Connect.Items["datedelivery"]);
cbIsDone.Checked = Convert.ToBoolean(Int16.Parse(Connect.Items["isdone"]));
tSumToPay.Text = Connect.Items["forpay"];
dtPay.Value = Convert.ToDateTime(Connect.Items["datepay"]);
tSumPay.Text = Connect.Items["paysum"];
cbPayType.SelectedItem = Connect.Items["paytype"];
cbUser.SelectedItem = Connect.Items["user"];
dtReg.Value = Convert.ToDateTime(Connect.Items["datereg"]);
cbTypeReq.SelectedItem = Connect.Items["requesttype"];
tPrim.Text = Connect.Items["prim"];
}
