private bool ApprovalClientName(string search) { Models.DataBaseContext dataBaseContext = null; dataBaseContext = new Models.DataBaseContext(); Models.PermanentClient permanentClient = dataBaseContext.PermanentClients .Where(current => string.Compare(current.Full_Name, search) == 0) .FirstOrDefault(); if (permanentClient != null) { return(true); } else { return(false); } }
//-----End of coding line. #region Founctions //----- #region Validation_ClientID private bool Validation_ClientID(string clientID) { bool status = false; Models.DataBaseContext dataBaseContext = null; dataBaseContext = new Models.DataBaseContext(); Models.PermanentClient client = dataBaseContext.PermanentClients .Where(current => string.Compare(current.Client_ID, clientID) == 0) .FirstOrDefault(); if (client == null) { status = true; } else { status = false; } return(status); }
//----- #endregion /SearchClientTextBox #region DeletePermancentClientButton_Click private void DeletePermancentClientButton_Click(object sender, System.EventArgs e) { if (permanentClientDataGridView.Rows.Count >= 1) { System.Windows.Forms.DialogResult dialogResult = Mbb.Windows.Forms.MessageBox.Show (text: $"{permanentClientDataGridView.CurrentRow.Cells[0].Value} حذف گردد؟!", caption: "حذف رکورد", icon: Mbb.Windows.Forms.MessageBoxIcon.Warning, button: Mbb.Windows.Forms.MessageBoxButtons.YesNo); if (dialogResult == System.Windows.Forms.DialogResult.Yes) //----جهت حذف مشترک { string clientID = permanentClientDataGridView.CurrentRow.Cells[0].Value.ToString(); string clientName = permanentClientDataGridView.CurrentRow.Cells[1].Value.ToString(); using (DataBaseContext dataBaseContext = new DataBaseContext()) { Models.PermanentClient permanentClient = dataBaseContext.PermanentClients .Where(current => string.Compare(current.Client_ID, clientID) == 0) .FirstOrDefault(); if (permanentClient != null) { var entry = dataBaseContext.Entry(permanentClient); if (entry.State == EntityState.Detached) { dataBaseContext.PermanentClients.Attach(permanentClient); } } #region EventLog Username = Program.AuthenticatedUser.Username; FullName = $"{Program.AuthenticatedUser.First_Name} {Program.AuthenticatedUser.Last_Name}"; EventDate = $"{Infrastructure.Utility.PersianCalendar(System.DateTime.Now)}"; EventTime = $"{Infrastructure.Utility.ShowTime()}"; EventTitle = EventTitle = $"{clientName} حذف گردید."; Infrastructure.Utility.EventLog (username: Username, fullName: FullName, eventDate: EventDate, eventTime: EventTime, eventTitle: EventTitle); #endregion /EventLog dataBaseContext.PermanentClients.Remove(permanentClient); dataBaseContext.SaveChanges(); PermanentClientListLoaded(); } Infrastructure.Utility.WindowsNotification (message: "کد مورد نظر حذف گردید!", caption: Infrastructure.PopupNotificationForm.Caption.موفقیت); } } else { Mbb.Windows.Forms.MessageBox.Show (text: $"موردی برای حذف وجود ندارد!", caption: "اخطار", icon: Mbb.Windows.Forms.MessageBoxIcon.Warning, button: Mbb.Windows.Forms.MessageBoxButtons.Ok); return; } }
//----- #endregion /FullNameTextBox #region SaveButton_Click private void SaveButton_Click(object sender, System.EventArgs e) { Models.DataBaseContext dataBaseContext = null; try { dataBaseContext = new Models.DataBaseContext(); string errorMessage = null; #region Validate //----- if (string.IsNullOrWhiteSpace(clientIDTextBox.Text) || string.Compare(clientIDTextBox.Text, "کد شناسه") == 0) { errorMessage = "فیلد کد شناسه را تکمیل کنید!"; } if (string.IsNullOrWhiteSpace(fullNameTextBox.Text) || string.Compare(fullNameTextBox.Text, "نام کامل") == 0) { if (errorMessage != null) { errorMessage += System.Environment.NewLine; } errorMessage += "فیلد نام کامل را تکمیل کنید!"; } if (errorMessage != null) { if (string.IsNullOrWhiteSpace(clientIDTextBox.Text) || string.Compare(clientIDTextBox.Text, "کد شناسه") == 0) { clientIDTextBox.Focus(); } else if (string.IsNullOrWhiteSpace(fullNameTextBox.Text) || string.Compare(fullNameTextBox.Text, "نام کامل") == 0) { fullNameTextBox.Focus(); } Mbb.Windows.Forms.MessageBox.Show (text: errorMessage, caption: "خطای ورودی", icon: Mbb.Windows.Forms.MessageBoxIcon.Error, button: Mbb.Windows.Forms.MessageBoxButtons.Ok); return; } //----- #endregion /Validate System.Windows.Forms.DialogResult dialogResult; string message = $"کد شناسه {ClientID} ذخیره گردد؟."; dialogResult = Mbb.Windows.Forms.MessageBox.Show (text: message, caption: "ذخیره اطلاعات", icon: Mbb.Windows.Forms.MessageBoxIcon.Question, button: Mbb.Windows.Forms.MessageBoxButtons.YesNo); if (dialogResult == System.Windows.Forms.DialogResult.Yes) { Models.PermanentClient client = dataBaseContext.PermanentClients .Where(current => string.Compare(current.Client_ID, ClientID) == 0) .FirstOrDefault(); if (client == null) { RegisterDate = Infrastructure.Utility.PersianCalendar(System.DateTime.Now); RegisterTime = Infrastructure.Utility.ShowTime(); client = new Models.PermanentClient { Client_ID = ClientID, Full_Name = ClientFullName, Register_Date = $"{RegisterTime} - {RegisterDate}", Last_Order = "00:00:00 - 0000/00/00", Number_Order = 0, Edit_Date = "00:00:00 - 0000/00/00", }; dataBaseContext.PermanentClients.Add(client); dataBaseContext.SaveChanges(); if (ClientManegmentForm.PermanentClientListForm != null) { ClientManegmentForm.PermanentClientListForm.PermanentClientListLoaded(); } #region EventLog Username = Program.AuthenticatedUser.Username; FullName = $"{Program.AuthenticatedUser.First_Name} {Program.AuthenticatedUser.Last_Name}"; EventDate = $"{Infrastructure.Utility.PersianCalendar(System.DateTime.Now)}"; EventTime = $"{Infrastructure.Utility.ShowTime()}"; EventTitle = $"ثبت مشتری با کد {ClientID} و نام {ClientFullName}"; Infrastructure.Utility.EventLog (username: Username, fullName: FullName, eventDate: EventDate, eventTime: EventTime, eventTitle: EventTitle); #endregion /EventLog } } else { return; } string successMessage = $"اطلاعات کاربر {ClientID} با موفقیت ذخیره گرید!"; Infrastructure.Utility.WindowsNotification (message: successMessage, caption: Infrastructure.PopupNotificationForm.Caption.موفقیت); AllClear(); } catch (System.Exception ex) { Infrastructure.Utility.ExceptionShow(ex); } finally { if (dataBaseContext != null) { dataBaseContext.Dispose(); dataBaseContext = null; } } }