private void dvgAllAtmUsersEditing_SelectionChanged(object sender, EventArgs e) { DataGridView dgv = (DataGridView)sender; try { if (dgv.SelectedRows.Count > 0) { string currentUserId = dgv.SelectedRows[0].Cells[0].Value.ToString(); userId = int.Parse(currentUserId); AtmUserModel userData = this.userService.GetAtmUserData(userId); txtAtmUserName.Text = userData.Name.ToString(); txtAtmUserSurname.Text = userData.Surname.ToString(); txtAtmUserContactNumber.Text = userData.ContactNumber.ToString(); txtAtmUserContactMail.Text = userData.Email.ToString(); txtAtmUserBranch.Text = userData.Branch.ToString(); txtAtmUserCompany.Text = userData.Company.ToString(); txtAtmUserWorkPlace.Text = userData.UserType.ToString(); } } catch (Exception ex) { this.ShowErrorMessage(ex); } }
public List <AtmUserModel> GetAllUsers() { DataTable data = new DataTable(); using (SqlConnection con = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); //Create Technician List List <AtmUserModel> _users = new List <AtmUserModel>(); try { cmd = new SqlCommand("procGetAllAtmUsers", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); da.SelectCommand = cmd; da.Fill(dt); cmd.Connection.Close(); foreach (DataRow row in dt.Rows) { AtmUserModel _user = new AtmUserModel(); _user.Id = Convert.ToInt32(row["Atm_user_ID"]); _user.Name = row["Name"].ToString(); _user.Name = row["Surname"].ToString(); _user.Name = row["Contact_number"].ToString(); _user.Name = row["Contact_email"].ToString(); _user.Name = row["Branch"].ToString(); _user.Name = row["Company"].ToString(); _user.Name = row["Atm_user_name"].ToString(); _user.Name = row["Atm_user_password"].ToString(); _user.Name = row["User_type"].ToString(); _users.Add(_user); } } catch (Exception x) { MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); //pl.MySQLConn.Close(); } return(_users); } }
private void btnSaveInterventions_Click(object sender, EventArgs e) { //MessageBox.Show(dateOfInter.ToShortDateString()); AtmModel atm = new AtmModel(); //TO DO Rješit USERA DA SE LOGIRA , Globalnu variablu stavit var userid = 1; AtmUserModel user = new AtmUserModel(); user.Id = userid; //ako je punjenje foreach (DataGridViewRow item in dgvAddAtmToIntervention.Rows) { DataGridViewComboBoxCell cb = (DataGridViewComboBoxCell)item.Cells[4]; if (cb.Value != null) { atm.Id = Convert.ToInt32(item.Cells[5].Value);//id switch (cb.Value.ToString()) { case "Punjenje": int a = Convert.ToInt32(item.Cells[6].Value); int b = Convert.ToInt32(item.Cells[7].Value); var flagRefill = this.orderService.AddRefillOrder(dateOfInter, atm, user, a, b); break; case "Greska": var flagError = this.orderService.AddErrorOrder(dateOfInter, atm, user); break; case "Kvar": var flagMal = this.orderService.AddMalfunctionOrder(dateOfInter, atm, user); break; case "Zadrzana kartica": break; default: throw new ArgumentException("Nepoznata intervencija"); } } else { MessageBox.Show("Odaberite intervenciju"); }//end if } }
public bool AddAtmUser(AtmUserModel user) { using (SqlConnection con = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter();//maknit var rowsAffected = 0; try { //TO DO napravit storanu procc za update component cmd = new SqlCommand("procAddAtmUser", con); cmd.Parameters.Add(new SqlParameter("@Name", user.Name)); cmd.Parameters.Add(new SqlParameter("@Surname", user.Surname)); cmd.Parameters.Add(new SqlParameter("@Contact_number", user.ContactNumber)); cmd.Parameters.Add(new SqlParameter("@Contact_email", user.Email)); cmd.Parameters.Add(new SqlParameter("@Branch", user.Branch)); cmd.Parameters.Add(new SqlParameter("@Company", user.Company)); cmd.Parameters.Add(new SqlParameter("@Atm_user_name", user.UserName)); cmd.Parameters.Add(new SqlParameter("@Atm_user_password", user.UserPassword)); cmd.Parameters.Add(new SqlParameter("@User_type", user.UserType)); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); rowsAffected = cmd.ExecuteNonQuery(); cmd.Connection.Close(); } catch (Exception x) { MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); //pl.MySQLConn.Close(); } if (rowsAffected > 0) { return(true); } else { return(false); } } }
private void BtnAddNewUser_Click(object sender, EventArgs e) { try { if (this.ValidateUpdate()) { AtmUserModel userModel = new AtmUserModel(); userModel.Name = txtNewAtmUserName.Text.Trim(); userModel.Surname = txtNewAtmUserSurname.Text.Trim(); userModel.ContactNumber = txtNewAtmUserContactNumber.Text.Trim(); userModel.Email = txtNewAtmUserContactMail.Text.Trim(); userModel.Branch = txtNewAtmUserBranch.Text.Trim(); userModel.Company = txtNewAtmUserCompany.Text.Trim(); userModel.UserName = txtNewAtmUserUsername.Text.Trim(); userModel.UserPassword = txtNewAtmUserPassword.Text.Trim(); userModel.UserType = txtNewAtmUserWorkplace.Text.Trim(); //Add new AtmUser and return bool var flag = this.userService.AddAtmUser(userModel); this.Close(); if (flag) { MessageBox.Show( Resources.Update_Successful_Message, Resources.Update_Successful_Message_Title, MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show( this.errorMessage, Resources.Update_Error_Message_Title, MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.ShowErrorMessage(ex); } }
private void btnRegisterNewMalfunctionOrder_Click(object sender, EventArgs e) { //TO DO Rješit USERA DA SE LOGIRA , Globalnu variablu stavit //Login var userid = 1; AtmUserModel user = new AtmUserModel(); user.Id = userid; DateTime date = new DateTime(2018, 1, 1); AtmModel atm = this.atmService.GetAtmByOrderId(orderId); var flag = this.orderService.AddMalfunctionOrder(date, atm, user); DataTable data = this.orderService.GetAllOrdersByDate(date); this.LoadDataGridView(data); }
public AtmUserModel GetAtmUserData(int userId) { DataTable data = new DataTable(); //DataRow dataRow; AtmUserModel _atmUser = new AtmUserModel(); using (SqlConnection con = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); //DataRow dataRow = null; try { cmd = new SqlCommand("procGetAtmUserDataById", con); cmd.Parameters.Add(new SqlParameter("@Atm_user_ID", userId)); //cmd.Parameters.Add(new SqlParameter("@Component_name", componentName)); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); da.SelectCommand = cmd; da.Fill(dt); cmd.Connection.Close(); _atmUser.Id = Convert.ToInt16(dt.Rows[0]["Atm_user_ID"]); _atmUser.Name = dt.Rows[0]["Name"].ToString(); _atmUser.Surname = dt.Rows[0]["Surname"].ToString(); _atmUser.ContactNumber = dt.Rows[0]["Contact_number"].ToString(); _atmUser.Email = dt.Rows[0]["Contact_email"].ToString(); _atmUser.Branch = dt.Rows[0]["Branch"].ToString(); _atmUser.Company = dt.Rows[0]["Company"].ToString(); _atmUser.UserType = dt.Rows[0]["User_type"].ToString(); //dataRow = dt.Rows.Count > 0 ? dt.Rows[0] : null; } catch (Exception x) { MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); //pl.MySQLConn.Close(); } return(_atmUser); } }
private void BtnUpdateAtmUser_Click(object sender, EventArgs e) { try { if (this.ValidateUpdate()) { AtmUserModel atmUser = new AtmUserModel() { Id = this.userId, Name = txtAtmUserName.Text.Trim(), Surname = txtAtmUserSurname.Text.Trim(), ContactNumber = txtAtmUserContactNumber.Text.Trim(), Email = txtAtmUserContactMail.Text.Trim(), Branch = txtAtmUserBranch.Text.Trim(), Company = txtAtmUserCompany.Text.Trim(), UserType = txtAtmUserWorkPlace.Text.Trim(), }; var flag = this.userService.UpdateAtmUser(atmUser); if (flag) { this.LoadAtmUsersGridView(); MessageBox.Show( Resources.Update_Successful_Message, Resources.Update_Successful_Message_Title, MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show( this.errorMessage, Resources.Update_Error_Message_Title, MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { this.ShowErrorMessage(ex); } }
public bool AddRefillOrder(DateTime orderDate, AtmModel atm, AtmUserModel user, int refillNewBill100, int refillNewBill200) { using (SqlConnection con = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter();//maknit var rowsAffected = 0; try { cmd = new SqlCommand("procAddRefillOrder", con); cmd.Parameters.Add(new SqlParameter("@Order_date", orderDate)); cmd.Parameters.Add(new SqlParameter("@Atm_ID", atm.Id)); cmd.Parameters.Add(new SqlParameter("@Atm_user_ID", user.Id)); cmd.Parameters.Add(new SqlParameter("@Refill_new_bill_100", refillNewBill100)); cmd.Parameters.Add(new SqlParameter("@Refill_new_bill_200", refillNewBill200)); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); rowsAffected = cmd.ExecuteNonQuery(); cmd.Connection.Close(); } catch (Exception x) { MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); //pl.MySQLConn.Close(); } if (rowsAffected > 0) { return(true); } else { return(false); } } }
public bool AddRefillOrder(DateTime orderDate, AtmModel atm, AtmUserModel user, int refillNewBill100, int refillNewBill200) { return(this.orderAccess.AddRefillOrder(orderDate, atm, user, refillNewBill100, refillNewBill200)); }
public bool AddMalfunctionOrder(DateTime orderDate, AtmModel atm, AtmUserModel user) { return(this.orderAccess.AddMalfunctionOrder(orderDate, atm, user)); }
public bool UpdateAtmUser(AtmUserModel user) { return(this.userAccess.UpdateAtmUser(user)); }
public bool AddAtmUser(AtmUserModel user) { return(this.userAccess.AddAtmUser(user)); }