private void Delete_Click(object sender, RoutedEventArgs e)
{
User usedBy;
if (recordData != null)
{
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
usedBy = connection.AccessValidation(nameof(UserData.CustomerId), recordData.Id);
if (usedBy == null || usedBy.Id == UserData.Id)
{
UserData.CustomerId = recordData.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.CustomerId));
}
}
if (usedBy == null || usedBy.Id == UserData.Id)
{
LoadingControl.Visibility = Visibility.Visible;
MessageBoxResult result = MessageWindow.Show($"Deleting", $"Are you sure want to delete:\n{recordData.Name} ?", MessageWindowButton.YesNo, MessageWindowImage.Warning);
if (result == MessageBoxResult.Yes)
{
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
var query = $"Select * From Inquiry._Inquiries Where CustomerId = {recordData.Id}";
Customer CheckCustomer = connection.QueryFirstOrDefault <Customer>(query);
if (CheckCustomer == null)
{
connection.Execute($"Delete From [Customer].[_Customers] Where Id = {recordData.Id} ");
connection.Execute($"Delete From [Customer].[_Contacts] Where CustomerId = {recordData.Id} ");
RecordsData.Remove(recordData);
UserData.CustomerId = null;
connection.UserAccessUpdate(UserData, nameof(UserData.CustomerId));
}
else
{
MessageWindow.Show("Deleting", $"You can't delete {recordData.Name} data \n Because its used in projects data", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
else
{
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
UserData.CustomerId = null;
connection.UserAccessUpdate(UserData, nameof(UserData.CustomerId));
}
}
LoadingControl.Visibility = Visibility.Collapsed;
}
else
{
MessageWindow.Show($"Access", $"This customer data underwork by {usedBy.Name}!", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
private void Quote_Click(object sender, RoutedEventArgs e)
{
if (InquiriesList.SelectedItem is Inquiry inquiryData)
{
User usedBy;
Quotation quotationData = new Quotation()
{
InquiryId = inquiryData.Id, Inquiry = inquiryData
};
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
usedBy = connection.AccessValidation(nameof(quotationData.InquiryId), inquiryData.Id);
if (usedBy == null)
{
string query = $"Select MAX(Number) as Number From [Quotation].[_Qoutations] Where Year = {DateTime.Now.Year}";
quotationData.Number = connection.QueryFirstOrDefault <Quotation>(query).Number + 1;
quotationData.Year = DateTime.Now.Year;
quotationData.Month = DateTime.Now.Month;
quotationData.Code =
$"ER-{quotationData.Number:000}/{UserData.UserCode}/{quotationData.Month}/{quotationData.Year}/R00";
quotationData.ReviseDate = DateTime.Now;
quotationData.Id = Convert.ToInt32(connection.Insert <Quotation>(quotationData));
Term.GetDefaultTerms(connection, quotationData.Id);
UserData.InquiryId = inquiryData.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.InquiryId));
UserData.QuotationId = quotationData.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.QuotationId));
}
}
if (usedBy == null)
{
var quotationWindow = new QuotationWindow()
{
UserData = this.UserData,
OpenPanelsWindow = true,
QuotationData = quotationData
};
this.Close();
quotationWindow.ShowDialog();
}
else
{
MessageWindow.Show($"Access", $"This inquiry underwork by {usedBy.Name}!", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
private void Edit_Click(object sender, RoutedEventArgs e)
{
User usedBy;
if (recordData != null)
{
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
usedBy = connection.AccessValidation(nameof(UserData.ContactId), recordData.Id);
if (usedBy == null || usedBy.Id == UserData.Id)
{
UserData.ContactId = recordData.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.ContactId));
}
}
if (usedBy == null)
{
LoadingControl.Visibility = Save.Visibility = Cancel.Visibility = Visibility.Visible;
Done.Visibility = Visibility.Collapsed;
foreach (object control in Body.Children)
{
if (control is TextBlock || control is StackPanel)
{
}
else
{
if (((Control)control).Name == "Company")
{
}
else
{
((Control)control).IsEnabled = true;
}
}
}
action = Actions.Edit;
oldData = new Contact();
oldData.Update(recordData);
}
else
{
MessageWindow.Show($"Access", $"This contact data underwork by {usedBy.Name}!", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (InquiriesList.SelectedItem is Inquiry inquiry)
{
User usedBy;
Quotation quotation;
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
usedBy = connection.AccessValidation(nameof(UserData.InquiryId), inquiry.Id);
quotation = connection.QueryFirstOrDefault <Quotation>($"Select * From Quotation._Quotations Where InquiryId = {inquiry.Id}");
if (usedBy == null)
{
UserData.InquiryId = inquiry.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.InquiryId));
}
}
if (quotation != null)
{
MessageWindow.Show($"Access", $"Can't delete this Inquiry!", MessageWindowButton.OK, MessageWindowImage.Warning);
return;
}
if (usedBy == null || usedBy.Id == UserData.Id)
{
MessageBoxResult result = MessageWindow.Show("Deleting", $"Do you want to Delete Inquiy: \n{inquiry.RegisterCode}?", MessageWindowButton.YesNo, MessageWindowImage.Warning);
if (result == MessageBoxResult.Yes)
{
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
connection.Execute($"Delete From [Inquiry].[_Inquiries] Where Id = {inquiry.Id}");
connection.Execute($"Delete From [Inquiry].[_ProjectsContacts] Where InquiryId = {inquiry.Id}");
inquiriesData.Remove(inquiry);
}
}
}
else
{
MessageWindow.Show($"Access", $"This inquiry underwork by {usedBy.Name}!", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
private void Edit_ClicK(object sender, RoutedEventArgs e)
{
if (InquiriesList.SelectedItem is Inquiry inquiry)
{
User usedBy;
Quotation quotation;
using (SqlConnection connection = new SqlConnection(Database.ConnectionString))
{
usedBy = connection.AccessValidation(nameof(UserData.InquiryId), inquiry.Id);
quotation = connection.QueryFirstOrDefault <Quotation>($"Select * From [Quotation].[_Quotations] Where InquiryId = {inquiry.Id}");
if (usedBy == null)
{
UserData.InquiryId = inquiry.Id;
connection.UserAccessUpdate(UserData, nameof(UserData.InquiryId));
}
}
if (quotation != null)
{
if (quotation.Status != Statuses.Running.ToString())
{
MessageWindow.Show($"Access", $"Can't edit this Inquiry!", MessageWindowButton.OK, MessageWindowImage.Warning);
return;
}
}
if (usedBy == null || usedBy.Id == UserData.Id)
{
var inquiryWindow = new InquiryWindow()
{
UserData = this.UserData,
WindowMode = Actions.Edit,
InquiryData = inquiry,
};
inquiryWindow.ShowDialog();
}
else
{
MessageWindow.Show($"Access", $"This inquiry underwork by {usedBy.Name}!", MessageWindowButton.OK, MessageWindowImage.Warning);
}
}
}
