public FrmEditUser(int id)
{
InitializeComponent();
this.Id = id;
this.Details = DBLayer.Users.GetDetails(id);
tbCode.Text = this.Details.Barcode;
tbFIO.Text = this.Details.FIO;
tbJobTitle.Text = this.Details.JobTitle;
cbIsAdmin.Checked = this.Details.IsAdmin;
tbLogin.Text = this.Details.Login;
tbPassword.Text = this.Details.Password;
try
{
urDet = DBLayer.UserRate.GetDetails(this.Id);
}
catch { }
tbBar.Text = urDet.PercentForSales.ToString();
tbServices.Text = urDet.PercentForService.ToString();
tbAbonements.Text = urDet.PercentForClients.ToString();
tbConstant.Text = urDet.Constant.ToString();
tbFitness.Text = urDet.PercentForFitness.ToString();
tbMassage.Text = urDet.PercentForMassage.ToString();
LoadData();
LoadAdminsData();
}
public static void Insert(DBLayer.UserRate.Details det)
{
string sql = "INSERT INTO UserRate (UserId, Constant, PercentForClients, PercentForSales, PercentForService, PercentForFitness, PercentForMassage) ";
sql += " VALUES (" + det.UserId.ToString() + ", " + det.Constant.ToString() + ", " + det.PercentForClients.ToString().Replace(",", ".") + ", " + det.PercentForSales.ToString().Replace(",", ".") + ", " + det.PercentForService.ToString().Replace(",", ".") + ", " + det.PercentForFitness.ToString().Replace(",", ".") + ", " + det.PercentForMassage.ToString().Replace(",", ".") + ")";
ZFort.DB.Execute.ExecuteString_void(sql);
}
public static void Update(DBLayer.UserRate.Details det)
{
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [UserId] = " + det.UserId.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [Constant] = " + det.Constant.ToString() + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [PercentForClients] = " + det.PercentForClients.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [PercentForSales] = " + det.PercentForSales.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [PercentForService] = " + det.PercentForService.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [PercentForFitness] = " + det.PercentForFitness.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
ZFort.DB.Execute.ExecuteString_void("UPDATE UserRate SET [PercentForMassage] = " + det.PercentForMassage.ToString().Replace(",", ".") + " WHERE [Id] = " + det.Id.ToString());
}
public static ArrayList GetList()
{
string sql = "SELECT ur.*, u.FIO FROM UserRate As ur INNER JOIN Users As u ON ur.UserId = u.[Id]";
DataTable dt = ZFort.DB.Execute.ExecuteString_DataTable(sql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
DBLayer.UserRate.Details det = new DBLayer.UserRate.Details();
if (!dr.IsNull("Id"))
{
det.Id = Convert.ToInt32(dr["Id"]);
}
if (!dr.IsNull("Constant"))
{
det.Constant = Convert.ToDouble(dr["Constant"]);
}
if (!dr.IsNull("PercentForClients"))
{
det.PercentForClients = Convert.ToDouble(dr["PercentForClients"]);
}
if (!dr.IsNull("PercentForSales"))
{
det.PercentForSales = Convert.ToDouble(dr["PercentForSales"]);
}
if (!dr.IsNull("UserId"))
{
det.UserId = Convert.ToInt32(dr["UserId"]);
}
al.Add(det);
}
return(al);
}
