/// <summary>
/// Loescht eine Auftragsposition und ggf. die Amtlichen Gebuehren dazu
/// </summary>
/// <param name="dbContext">DB Kontext</param>
/// <param name="orderItemId">AuftragspositionID</param>
public static void RemoveOrderItem(DataClasses1DataContext dbContext, int orderItemId)
{
var orderItemToDelete = dbContext.OrderItem.FirstOrDefault(q => q.Id == orderItemId);
if (orderItemToDelete != null)
{
if (orderItemToDelete.Status > (int)OrderItemStatusTypes.Open)
throw new Exception("Der Auftragsstatus ist nicht mehr Offen, löschen nicht möglich");
if (orderItemToDelete.Order.DocketList != null)
throw new Exception("Laufzettel wurde bereits erstellt, löschen nicht möglich");
if (orderItemToDelete.Order.PackingList != null)
throw new Exception("Lieferschein wurde bereits erstellt, löschen nicht möglich");
var itemsAnzahl = dbContext.OrderItem.Count(q => q.Id != orderItemId && q.SuperOrderItemId != orderItemId && q.OrderNumber == orderItemToDelete.OrderNumber);
if (itemsAnzahl == 0)
throw new Exception("Mind. eine Position muss pro Auftrag verfügbar sein");
var hasChildItems = dbContext.OrderItem.FirstOrDefault(q => q.SuperOrderItemId == orderItemToDelete.Id);
dbContext.OrderItem.DeleteOnSubmit(hasChildItems);
if (orderItemToDelete.SuperOrderItemId.HasValue == true)
{
RemoveOrderItem(dbContext, orderItemToDelete.SuperOrderItemId.Value);
}
dbContext.OrderItem.DeleteOnSubmit(orderItemToDelete);
dbContext.WriteLogItem("Auftragsposition " + orderItemToDelete.ProductName + " mit der Auftragsnummer " + orderItemToDelete.Order.OrderNumber + " wurde gelöscht.",
LogTypes.DELETE, orderItemToDelete.Id, "OrderItem");
}
}
/// <summary>
/// Gibt alle Herstellern by HSN zurück
/// </summary>
/// <param name="hsn">HSN des Herstellers.</param>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <returns>Herstellers</returns>
public static string GetMakeByHSN(string hsn)
{
string hsnResult = string.Empty;
bool atLeastOneHSNFound = false;
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var hsnQuery = from make in dbContext.Make
where make.HSN == hsn
select make.Name;
foreach (string hsnName in hsnQuery)
{
atLeastOneHSNFound = true;
hsnResult += hsnName + " ";
}
hsnResult = "Hersteller: " + hsnResult;
if (atLeastOneHSNFound == false)
{
hsnResult = "Wir haben kein Hersteller mit dem Nummer " + hsn + " gefunden";
}
return hsnResult;
}
/// <summary>
/// Erstellt einen neuen Rechnungslauf Datensatz
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GenerateInvoiceRunButton_Click(object sender, EventArgs e)
{
InvoiceRunError.Text="";
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
try
{
Guid? customerId=null;
Guid? invoiceType = null;
if(CustomerDropDownList.SelectedValue != string.Empty)customerId=new Guid(CustomerDropDownList.SelectedValue);
if (RechnungsTypComboBox.SelectedValue != string.Empty && RechnungsTypComboBox.Enabled==true) invoiceType = new Guid(RechnungsTypComboBox.SelectedValue);
InvoiceRunReport run = new InvoiceRunReport()
{
Id = Guid.NewGuid(),
CustomerId = customerId,
InvoiceTypeId = invoiceType,
CreateDate = DateTime.Now
};
dbContext.InvoiceRunReport.InsertOnSubmit(run);
dbContext.SubmitChanges();
RadGridInvoiceRun.MasterTableView.ClearChildEditItems();
RadGridInvoiceRun.MasterTableView.ClearEditItems();
RadGridInvoiceRun.Rebind();
}
catch (Exception ex)
{
InvoiceRunError.Visible = true;
InvoiceRunError.Text = "Rechnungslauf Fehler " + ex.Message;
dbContext.WriteLogItem("Rechnungslauf Error " + ex.Message, LogTypes.ERROR, "Rechnungslauf");
}
}
}
protected void ChangeSaveBtn_Click(object sender, EventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext(Int32.Parse(Session["CurrentUserId"].ToString())); // hier kommt die Loggingid
try
{
if (txbNewPassword.Text == txbRepeatPWD.Text)
{
var thisUser = dbContext.User.SingleOrDefault(q => q.Id == Int32.Parse(Session["CurrentUserId"].ToString()));
if (thisUser != null)
{
thisUser.ChangePassword(txbNewPassword.Text, txbOldPWD.Text, dbContext);
dbContext.SubmitChanges();
RadWindowManagerChangePassword.RadAlert("Das Passwort wurde erfolgreich geändert", 380, 180, "Info", "");
}
else
{
Response.Redirect("../login.aspx");
}
}
else
{
FailureText.Text = "Die neuen Passwörter stimmen nicht überein";
}
}
catch (Exception ex)
{
FailureText.Text = ex.Message;
dbContext.WriteLogItem("ChangePassowrd Error: " + ex.Message, LogTypes.ERROR, "User");
}
}
public Kundendaten GetCustomerProductInformation(string username, string password, string InternalId)
{
Kundendaten knd = new Kundendaten();
List<Guid> allowedCustomers = new List<Guid>();
try
{
allowedCustomers = CheckLogin.CheckUser(username, password, InternalId);
if (allowedCustomers.Count > 0)
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext(new Guid(ConfigurationManager.AppSettings["currentUser"])))
{
dbContext.WriteLogItem("Zugriff von der IP Adresse: " + this.Context.Request.UserHostAddress + "Webservice GetCustomerInformation()", LogTypes.INFO);
ValidateOrderType.GetCutomerInformation(out knd, allowedCustomers, dbContext);
}
}
else
{
throw new Exception("Für Ihre Daten konnten keine Kunden gefunden werden!");
}
}
catch(Exception ex)
{
throw new Exception("Fehler beim verabeiten der Daten, bitte wiederholen Sie den Vorgang" + Environment.NewLine + "Fehlermeldung: " + ex.Message);
}
return knd;
}
/// <summary>
/// Erstelle zu der jeweiligen Rechnung ein neues Erlöskonto
/// </summary>
/// <param name="dbContext">DB Kontext</param>
/// <param name="inv">Rechnungsobjekt</param>
public static void CreateAccounts(DataClasses1DataContext dbContext, Invoice inv)
{
List<_Accounts> acc = null;
acc = Accounts.generateAccountNumber(dbContext,inv.Id).ToList();
if (acc != null && acc.Count() == inv.InvoiceItem.Count)
{
foreach (var thisItems in acc)
{
var myAccount = new InvoiceItemAccountItem
{
InvoiceItemId = thisItems.InvoiceItemId,
RevenueAccountText = thisItems.AccountNumber
};
var contains = dbContext.InvoiceItemAccountItem.FirstOrDefault(q => q.InvoiceItemId ==
thisItems.InvoiceItemId && q.RevenueAccountText == thisItems.AccountNumber.Trim());
if (contains != null)
{
contains.RevenueAccountText = thisItems.AccountNumber.Trim();
}
else
{
dbContext.InvoiceItemAccountItem.InsertOnSubmit(myAccount);
}
dbContext.SubmitChanges();
}
}
else
{
throw new Exception("Die Rechnung konnte nicht gedruckt werden, da nicht alle Dienstleistungen ein Erlöskonto haben! Sie können die Erlöskonten im Reiter 'Rechnung erstellen' zuweisen und die Rechnung erneut drucken.");
}
}
public static void CreateAccount(Guid? AccountNumber, Price _object, DataClasses1DataContext dbContext, bool withLocation = false)
{
if (AccountNumber != null)
{
IQueryable<PriceAccount> myAccount = null;
if (withLocation == false)
{
myAccount = dbContext.PriceAccount.Where(q => q.PriceId == _object.Id && q.Price.LocationId == null);
}
else
{
myAccount = dbContext.PriceAccount.Where(q => q.PriceId == _object.Id && q.Price.LocationId == _object.LocationId);
}
if (myAccount.Count() > 0)
{
dbContext.PriceAccount.DeleteAllOnSubmit<PriceAccount>(myAccount);
dbContext.SubmitChanges();
}
if (myAccount.Count() == 0)
{
var myNewAccount = new PriceAccount
{
PriceId = _object.Id,
AccountId = AccountNumber.Value
};
dbContext.PriceAccount.InsertOnSubmit(myNewAccount);
dbContext.SubmitChanges();
}
}
}
//Checked if amt.gebühr UND mind.eine Dienstleistung vorhanden ist
protected bool CheckDienstleistungAndAmtGebuhr(Guid orderId)
{
bool DienstVorhanden = false;
bool AmtGebuhVorhanden = false;
using (DataClasses1DataContext dbContext = new DataClasses1DataContext(new Guid(Session["CurrentUserId"].ToString())))
{
var searchOrderQuery = dbContext.Order.SingleOrDefault(q => q.Id == orderId);
if (searchOrderQuery != null)
{
foreach (OrderItem item in searchOrderQuery.OrderItem)
{
if (item.IsAuthorativeCharge == true)
{
AmtGebuhVorhanden = true;
}
else if (item.IsAuthorativeCharge == false)
{
DienstVorhanden = true;
}
}
}
}
if (AmtGebuhVorhanden == true && DienstVorhanden == true)
return true;
else
return false;
}
protected void RadGridAllChanges_DetailTableDataBind(object source, GridNeedDataSourceEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
try
{
RadGrid sender = source as RadGrid;
Panel item = sender.Parent as Panel;
Label lblReferenceId = item.FindControl("lblReferenceId") as Label;
Label lblTableName = item.FindControl("lblTableName") as Label;
DataTable t = new DataTable();
if (lblReferenceId.Text != string.Empty || lblTableName.Text != string.Empty)
{
var tableColumns = dbContext.ChangeLogColumNames.SingleOrDefault(q => q.TableName == lblTableName.Text);
string thisSelect = "";
if (tableColumns != null)
{
string idName = tableColumns.IdColumnName;
foreach (var col in tableColumns.ColumnNames.Split(';'))
{
if (thisSelect == string.Empty)
{
thisSelect = "[" + col + "]";
}
else
{
thisSelect += ",[" + col + "]";
}
}
dbContext.Connection.Close();
string myQuery = "";
if (thisSelect != string.Empty && idName != string.Empty && lblTableName.Text != string.Empty)
{
myQuery = "select " + thisSelect + " from [" + lblTableName.Text + "] where " + idName + " ='" + lblReferenceId.Text + "'";
using (SqlConnection c = new SqlConnection(dbContext.Connection.ConnectionString))
{
c.Open();
using (SqlDataAdapter a = new SqlDataAdapter(myQuery, c))
{
a.Fill(t);
}
}
sender.DataSource = t;
}
}
else
{
setEmptyDataSet(((RadGrid)sender));
}
}
else
{
setEmptyDataSet(((RadGrid)sender));
}
}
catch (Exception ex)
{
dbContext.WriteLogItem("Fehler beim generieren des ChangeLogs Details. " + ex.Message, LogTypes.ERROR);
dbContext.SubmitChanges();
}
}
protected void AllChangesLinq_Selected(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext con = new DataClasses1DataContext();
var changes = from chang in con.ChangeLog
let tableName = chang.TableName
let status = chang.TableProperty
let allStates = con.OrderStatus
let myOrder = con.Order
let myOrderItem=con.OrderItem
let Ref = (!chang.ReferenceId.HasValue)?Guid.Empty: chang.ReferenceId.Value
where chang.TableName == "Order" || chang.TableName == "OrderItem"
select new OrderLogging
{
LogId = chang.Expr1,
TableName = tableName,
Name = chang.Name,
FirstName = chang.FirstName,
Login = chang.Login,
Type= tableName=="Order" ? "Auftrag":"Auftragsposition",
Date = chang.Date,
ReferenceId = (!chang.ReferenceId.HasValue)?Guid.Empty: chang.ReferenceId.Value,
TranslatedText = TranslatedText(status,chang.Text, allStates),
OrderNumber = tableName == "Order" ? myOrder.FirstOrDefault(q => q.Id == Ref).Ordernumber : myOrderItem.FirstOrDefault(q => q.Id == Ref).Order.Ordernumber
};
changes = changes.OrderByDescending(q=>q.OrderNumber);
e.Result = changes;
}
protected void bSaveClick(object sender, EventArgs e)
{
ResetErrorLabels();
if (checkFields() == true)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext(((Guid)Session["CurrentUserId"]));
try
{
var createUser = KVSCommon.Database.User.CreateUser(txbUserLogin.Text, txbUserPassword1.Text, txbUserNachname.Text, txbUserVorname.Text, txbUserTitle.Text, dbContext);
if (hasContactData() == true)
{
var createContact = Contact.CreateContact(txbUserPhone.Text, txbUserFax.Text, txbUserMobile.Text, txbUserEmail.Text, dbContext);
createUser.Contact = createContact;
}
dbContext.SubmitChanges();
RadWindowManagerCreateUser.RadAlert("Der Benutzer wurde erfolgreich angelegt!", 380, 180, "Info", "");
txbUserLogin.Text=""; txbUserPassword1.Text=""; txbUserNachname.Text="";
txbUserVorname.Text = ""; txbUserTitle.Text = "";
txbUserPhone.Text = ""; txbUserFax.Text = ""; txbUserMobile.Text = ""; txbUserEmail.Text = "";
}
catch (Exception ex)
{
RadWindowManagerCreateUser.RadAlert(Server.HtmlEncode(ex.Message).RemoveLineEndings(), 380, 180, "Fehler", "");
try
{
dbContext.WriteLogItem("Create User Error " + ex.Message, LogTypes.ERROR, "User");
dbContext.SubmitChanges();
}
catch { }
}
}
}
protected void AllChangesLinq_Selected(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext con = new DataClasses1DataContext();
var changes = from chang in con.ChangeLog orderby chang.Expr1 descending
select chang;
e.Result = changes;
}
// public void cmbCustomerProducts_OnLoad(object sender, EventArgs e)
public void cmbCustomerProducts_OnLoad(RadComboBox Box)
{
using (DataClasses1DataContext dbContext = new DataClasses1DataContext())
{
try
{
if (Session["editableProductId"] != null && !String.IsNullOrEmpty(Session["editableProductId"].ToString()))
{
string myProductId = Session["editableProductId"].ToString();
Box.Visible = true;
var myCustomers = from cust in dbContext.Customer
join lCust in dbContext.LargeCustomer on cust.Id equals lCust.CustomerId
orderby cust.Name ascending
select new
{
CustomerId = cust.Id,
CustomerName = String.IsNullOrEmpty(cust.MatchCode) ? cust.Name : cust.Name + "(" + cust.MatchCode + ")",
IsChecked = dbContext.CustomerProduct.SingleOrDefault(q => q.ProductId == Int32.Parse(myProductId) && q.CustomerId == cust.Id) != null ? true : false
};
Box.DataSource = myCustomers;
Box.DataBind();
}
}
catch (Exception ex)
{
dbContext.WriteLogItem("Product Error " + ex.Message, LogTypes.ERROR, "Product");
throw new Exception(ex.Message);
}
}
}
/// <summary>
/// Erstellt einen Laufkunden.
/// </summary>
/// <param name="name">Name des Kunden.</param>
/// <param name="firstName">Vorname des Kunden.</param>
/// <param name="title">Anrede.</param>
/// <param name="gender">Geschlecht.</param>
/// <param name="street">Straße.</param>
/// <param name="streetnumber">Hausnummer.</param>
/// <param name="zipcode">Postleitzahl.</param>
/// <param name="city">Straße.</param>
/// <param name="country">Land.</param>
/// <param name="phone">Telefonnummer.</param>
/// <param name="fax">Faxnummer.</param>
/// <param name="mobilephone">Mobiltelefonnummer.</param>
/// <param name="email">Emailaddresse.</param>
/// <param name="vat">Mehrwersteuersatz für den Kunden.</param>
/// <param name="termOfCredit">Zahlungsziel (in Tagen).</param>
/// <param name="customerNumber">Kundennummer.</param>
/// <param name="dbContext">Datenbankkontext für die Transaktion.</param>
/// <returns>Den neuen Laufkunden.</returns>
public static SmallCustomer CreateSmallCustomer(string name, string firstName, string title, string gender, string street, string streetnumber, string zipcode, string city,
string country, string phone, string fax, string mobilephone, string email, decimal vat, int? termOfCredit, string customerNumber, DataClasses1DataContext dbContext)
{
if (string.IsNullOrEmpty(name))
{
throw new ArgumentNullException("Der Name darf nicht leer sein.");
}
var customer = Customer.CreateCustomer(name, street, streetnumber, zipcode, city, country, phone, fax, mobilephone, email, vat, termOfCredit, customerNumber);
customer._dbContext = dbContext;
var person = new Person()
{
FirstName = firstName,
Name = name,
Gender = gender,
Title = title
};
var smallCustomer = new SmallCustomer()
{
Customer = customer,
Person = person
};
dbContext.SmallCustomer.InsertOnSubmit(smallCustomer);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Kunde " + firstName + " " + name + " wurde angelegt.", LogTypes.INSERT, customer.Id, "SmallCustomer");
return smallCustomer;
}
protected void GetAllCustomerDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var query = from cust in dbContext.Customer
select cust;
e.Result = query;
}
protected void GetAllPermissionProfileDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var query = from permissions in dbContext.PermissionProfile
where permissions.UserPermissionProfile.Any(q => q.UserId == new Guid(e.WhereParameters["Id"].ToString())) == false
orderby permissions.Name
select new { permissions.Id, permissions.Name, permissions.Description };
e.Result = query;
}
/// <summary>
/// Gibt die Mastergrid zurück (Informationen zur allen Rechnungen)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void getAllInvoiceDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var query = from cust in dbContext.Customer
join inv in dbContext.Invoice on cust.Id equals inv.CustomerId
join inn in dbContext.InvoiceNumber on inv.Id equals inn.InvoiceId
where inv.IsPrinted == true
select new
{
TableId = "Outer",
InvoiceNumber_ = inn.Number,
CustomerId=cust.Id,
CreateDate= inv.CreateDate,
Printed = (inv.IsPrinted)? "Ja": "Nein",
inv.PrintDate,
InvoiceRecipient = inv.InvoiceRecipient,
CustomerName = //cust.Name,
cust.SmallCustomer != null &&
cust.SmallCustomer.Person != null ?
cust.SmallCustomer.Person.FirstName + " " +
cust.SmallCustomer.Person.Name : cust.Name,
CustomerNumber = cust.CustomerNumber,
DebitorNumber = cust.Debitornumber,
InternalAccountNumber = cust.MatchCode,
NettoSum = inv.NetSum,
Discount = inv.discount
};
if (CustomerNameBox.SelectedIndex > 0)
{
query = query.Where(q => q.CustomerId == Int32.Parse(CustomerNameBox.SelectedValue));
}
if (RechnungsnummerSearchBox.Text != string.Empty && isNumber(RechnungsnummerSearchBox.Text))
{
query = query.Where(q => q.InvoiceNumber_ == int.Parse(RechnungsnummerSearchBox.Text));
}
if (DebitorennummerSearchBox.Text != string.Empty)
{
query = query.Where(q => q.DebitorNumber == DebitorennummerSearchBox.Text);
}
if (RechnungsempfaengerSearchBox.Text != string.Empty)
{
query = query.Where(q => q.InvoiceRecipient == RechnungsempfaengerSearchBox.Text);
}
if (KontonummerSearchBox.Text != string.Empty)
{
query = query.Where(q => q.InternalAccountNumber == KontonummerSearchBox.Text);
}
if (FromDateSearchBox.SelectedDate != null)
{
query = query.Where(q => q.CreateDate >= FromDateSearchBox.SelectedDate);
}
if (ToDateSearchBox.SelectedDate != null)
{
query = query.Where(q => q.CreateDate <= ToDateSearchBox.SelectedDate);
}
e.Result = query;
}
/// <summary>
/// Löscht die angegebene Bank aus der Datenbank.
/// </summary>
/// <param name="adressId">Id der Bank.</param>
/// <param name="dbContext"></param>
public static void DeleteBank(int bankId, DataClasses1DataContext dbContext)
{
BankAccount bank = dbContext.BankAccount.SingleOrDefault(q => q.Id == bankId);
if (bank != null)
{
dbContext.WriteLogItem("bank gelöscht.", LogTypes.DELETE, bankId, "BankAccount");
dbContext.BankAccount.DeleteOnSubmit(bank);
}
}
public static void CreateCustomers()
{
DataClasses1DataContext dbContext = new DataClasses1DataContext(new Guid("E6232890-B6E9-4AA4-B68C-36CF5C9A0918"));
var allCustomers = from cat in dbContext.temp_Customers2
select new { cat };
foreach (var allc in allCustomers)
{
var existsCustomer = dbContext.Customer.FirstOrDefault(q => q.CustomerNumber == allc.cat.Kundennummer);
if (existsCustomer != null)
{
existsCustomer.LogDBContext = dbContext;
existsCustomer.Name = allc.cat.Firma;
existsCustomer.Adress.Street = allc.cat.Strasse;
existsCustomer.Adress.StreetNumber = allc.cat.Hausnummer;
existsCustomer.Adress.Zipcode = allc.cat.Zip;
existsCustomer.Adress.City = allc.cat.Ort;
existsCustomer.Adress.Country = allc.cat.Land;
existsCustomer.Contact.LogDBContext = dbContext;
existsCustomer.Contact.Phone = allc.cat.Telefon;
existsCustomer.Contact.Fax = allc.cat.Telefax;
existsCustomer.Contact.Email = allc.cat.EMAIL;
existsCustomer.MatchCode = allc.cat.Matchcode;
existsCustomer.Debitornumber = allc.cat.Debitorenkonto;
Guid? myPersonId = null;
if ((allc.cat.Name != string.Empty || allc.cat.Vorname != string.Empty || allc.cat.Zusatz != string.Empty) && existsCustomer.LargeCustomer.PersonId == null)
{
myPersonId = Person.CreatePerson(dbContext, allc.cat.Vorname, allc.cat.Name, allc.cat.Anrede, allc.cat.Zusatz).Id;
}
else if ((allc.cat.Name != string.Empty || allc.cat.Vorname != string.Empty || allc.cat.Zusatz != string.Empty) && existsCustomer.LargeCustomer.PersonId != null)
{
existsCustomer.LargeCustomer.Person.LogDBContext= dbContext;
existsCustomer.LargeCustomer.Person.Title = allc.cat.Anrede;
existsCustomer.LargeCustomer.Person.Name = allc.cat.Name;
existsCustomer.LargeCustomer.Person.FirstName = allc.cat.Vorname;
existsCustomer.LargeCustomer.Person.Extension = allc.cat.Zusatz;
}
dbContext.SubmitChanges();
}
else
{
Guid? myPersonId = null;
if (allc.cat.Name != string.Empty || allc.cat.Vorname != string.Empty || allc.cat.Zusatz != string.Empty)
{
myPersonId = Person.CreatePerson(dbContext, allc.cat.Vorname, allc.cat.Name, allc.cat.Anrede, allc.cat.Zusatz).Id;
}
LargeCustomer.CreateLargeCustomer(dbContext, allc.cat.Firma, allc.cat.Strasse, allc.cat.Hausnummer, allc.cat.Zip, allc.cat.Ort, allc.cat.Land, allc.cat.Telefon, allc.cat.Telefax, "", allc.cat.EMAIL, 0, true, false, null,
allc.cat.Kundennummer,
allc.cat.Matchcode, allc.cat.Debitorenkonto, myPersonId, new Guid("DB455FDA-46E8-432E-9251-662F91258F6B"));
}
//LargeCustomer.CreateLargeCustomer(dbContext, allc.cat.Name, allc.cat.Strasse, allc.cat.Hausnummer, allc.cat.Zip, allc.cat.Ort, allc.cat.Ort, allc.cat.Telefon, allc.cat.Telefax, "", allc.cat.EMAIL, 0, true, false, null, allc.cat.Kundennummer, allc.cat.Matchcode, allc.cat.Debitorenkonto);
}
}
/// <summary>
/// Datasource fuer die Kundenliste
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void CustomerLinq_Selected(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext con = new DataClasses1DataContext();
var customerQuery = from cust in con.Customer
where cust.Id == cust.LargeCustomer.CustomerId
select new { Name = cust.Name, Value = cust.Id, Matchcode = cust.MatchCode, Kundennummer = cust.CustomerNumber };
e.Result = customerQuery;
}
/// <summary>
/// Löscht den angegeben Kontakt aus der Datenbank
/// </summary>
/// <param name="adressId">Id des Kontakts.</param>
/// <param name="dbContext"></param>
public static void DeleteContact(int contactId, DataClasses1DataContext dbContext)
{
Contact contact = dbContext.Contact.SingleOrDefault(q => q.Id == contactId);
if (contact != null)
{
dbContext.WriteLogItem("Contact gelöscht.", LogTypes.DELETE, contactId, "Contact");
dbContext.Contact.DeleteOnSubmit(contact);
}
}
protected void CustomerName_Selected(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext con = new DataClasses1DataContext();
var CustomerName = from cust in con.Customer
select new
{
Name = cust.SmallCustomer != null && cust.SmallCustomer.Person != null ? cust.SmallCustomer.Person.FirstName + " " + cust.SmallCustomer.Person.Name : cust.Name,
Value = cust.Id, Matchcode = cust.MatchCode, Kundennummer = cust.CustomerNumber };
e.Result = CustomerName;
}
/// <summary>
/// Gibt alle Daten zum gewaehlten Kunden zurueck
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void AbrechnungLinq_Selected(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext con = new DataClasses1DataContext();
Guid customerId = Guid.Empty;
if (CustomerDropDownList.SelectedValue != string.Empty)
customerId = new Guid(CustomerDropDownList.SelectedValue);
if (customerId != Guid.Empty)
{
var invoiceQuery = from inv in con.Invoice
where inv.CustomerId == customerId
&& (inv.canceled == null || inv.canceled == false)
orderby inv.CreateDate descending
select new
{
invoiceId = inv.Id,
customerNumber = inv.Customer.CustomerNumber,
Matchcode = inv.Customer.MatchCode,
customerName = //inv.Customer.Name,
inv.Customer.SmallCustomer != null &&
inv.Customer.SmallCustomer.Person != null ?
inv.Customer.SmallCustomer.Person.FirstName + " " +
inv.Customer.SmallCustomer.Person.Name : inv.Customer.Name,
createDate = inv.CreateDate,
isPrinted = inv.IsPrinted,
isPrintedMEssage = (inv.IsPrinted) ? "Gedruckt/Gebucht" : "Offen",
recipient = inv.InvoiceRecipient,
invoiceNumber = inv.InvoiceNumber != null ? inv.InvoiceNumber.Number.ToString() : String.Empty
};
e.Result = invoiceQuery;
}
else
{
var invoiceQuery = from inv in con.Invoice
where (inv.canceled == null || inv.canceled == false)
orderby inv.CreateDate descending
select new
{
invoiceId = inv.Id,
customerNumber = inv.Customer.CustomerNumber,
Matchcode = inv.Customer.MatchCode,
customerName = //inv.Customer.Name,
inv.Customer.SmallCustomer != null &&
inv.Customer.SmallCustomer.Person != null ?
inv.Customer.SmallCustomer.Person.FirstName + " " +
inv.Customer.SmallCustomer.Person.Name : inv.Customer.Name,
createDate = inv.CreateDate,
isPrinted = inv.IsPrinted,
isPrintedMEssage = (inv.IsPrinted) ? "Gedruckt/Gebucht" : "Offen",
recipient = inv.InvoiceRecipient,
invoiceNumber = inv.InvoiceNumber != null ? inv.InvoiceNumber.Number.ToString() : String.Empty
};
e.Result = invoiceQuery;
}
}
/// <summary>
/// Loescht den aktuellen Standort
/// </summary>
/// <param name="dbContext">DB Kontext</param>
/// <param name="lc">Standtort Objekt</param>
public static void ChangeLocations(DataClasses1DataContext dbContext, Location lc)
{
var changeAddress = dbContext.Adress.FirstOrDefault(q => q.Id != lc.AdressId);
var tempId = lc.AdressId;
var tempIA = lc.InvoiceAdressId;
var tempIDA = lc.InvoiceDispatchAdressId;
if (changeAddress != null)
{
lc.AdressId = changeAddress.Id;
lc.InvoiceAdressId = null;
lc.InvoiceDispatchAdressId = null;
}
else
{
throw new Exception("Das löschen vom Standort " + lc.Name + " ist aus Refernzierungsgründen nicht möglich, bitte legen Sie Datensatz an bei dem mind. eine neue Adresse erstellt wird");
}
var changeCustomer = dbContext.LargeCustomer.FirstOrDefault(q => q.CustomerId == lc.CustomerId && q.MainLocationId == lc.Id);
// tempId = lc.CustomerId.Value;
if (changeCustomer != null )
{
changeCustomer.Customer._dbContext = dbContext;
lc._dbContext = dbContext;
changeCustomer.Location1= null;
}
lc.LogDBContext = dbContext;
//if (changeCustomer != null)
//{
//changeCustomer.LogDBContext = dbContext;
lc.Name = lc.Name + "_" + DateTime.Now.Ticks;
dbContext.SubmitChanges();
//lc.CustomerId = changeCustomer.CustomerId;
lc.CustomerId = null;
//}
//else
//{
// throw new Exception("Das löschen vom Standort " + lc.Name + " ist aus Refernzierungsgründen nicht möglich, bitte legen Sie Datensatz an bei dem mind. ein neuer Kunde erstellt wird");
//}
//Adress.DeleteAdress(tempId, dbContext);
if (tempIA != null)
Adress.DeleteAdress(tempIA.Value, dbContext);
if (tempIDA != null)
Adress.DeleteAdress(tempIDA.Value, dbContext);
dbContext.SubmitChanges();
}
public static void ValidateAndSaveDerigistration(Deregistration deregistrationObject, DataClasses1DataContext dbContext, out List<ResultMessages> messages)
{
ResultMessages result = new ResultMessages();
messages = new List<ResultMessages>();
foreach (DeregistrationAbmeldung deregistration in deregistrationObject.Abmeldung)
{
result = new ResultMessages();
if (getOpenedDeregistrationOrder(deregistration.Vehicle.VIN).Count == 0)
{
if (ValidateGuid(deregistration.Header))
{
string valGuid = ValidateGuid(deregistration.Header, dbContext);
if (valGuid == string.Empty)
{
try
{
CreateDeregOrder(deregistration, dbContext);
result.Sucessed = "Sucessed imported VIN: " + deregistration.Vehicle.VIN;
messages.Add(result);
}
catch (Exception ex)
{
result.Error = ex.Message;
result.Deregistration = deregistration;
messages.Add(result);
}
}
else
{
result.Error = valGuid;
result.Deregistration = deregistration;
messages.Add(result);
}
}
else
{
result.Error = "Eins oder mehrere Felder im Header sind keine gültigen Guids";
result.Deregistration = deregistration;
messages.Add(result);
}
}
else
{
result.Error = "Für dieses Fahrzeug gibt es noch offene Aufträge";
result.Deregistration = deregistration;
messages.Add(result);
}
}
}
protected void AuftragsDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var query = dbContext.Order.Where(q => q.RegistrationOrder != null && q.Status==300);
var query2 = from or in dbContext.Order
where or.Status == 300
select new
{
or.Status,
or.User
};
e.Result = query;
}
/// <summary>
/// Erstellt eine neue Produktkategorie mit uebergebenem Namen.
/// </summary>
/// <param name="name">Name der Kategorie.</param>
/// <param name="dbContext">Datenbankkontext, mit dem die Kategorie erstellt wird.</param>
/// <returns>Die neu erstellte Produktkategorie.</returns>
public static ProductCategory CreateProductCategory(string name, DataClasses1DataContext dbContext)
{
var item = new ProductCategory()
{
LogDBContext = dbContext,
Name = name
};
dbContext.ProductCategory.InsertOnSubmit(item);
dbContext.SubmitChanges();
dbContext.WriteLogItem("Produktkategorie " + item.Name + " angelegt.", LogTypes.INSERT, item.Id, "ProductCategory");
return item;
}
protected void getAllPermissionProfileDataSource_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
DataClasses1DataContext dbContext = new DataClasses1DataContext();
var query = from permission in dbContext.PermissionProfile
orderby permission.Name
select new
{
permission.Id,
permission.Name,
permission.Description
};
e.Result = query;
}
/// <summary>
/// Lösche ein bestehendes Erlöskonto
/// </summary>
/// <param name="CustomerId">Kundenid</param>
/// <param name="AccountNumber">Kontonummer</param>
/// <param name="dbContext">Datenbank Kontext</param>
public static void DeleteAccount(int CustomerId, string AccountNumber, DataClasses1DataContext dbContext)
{
var myAcount = dbContext.Accounts.FirstOrDefault(q => q.CustomerId == CustomerId && q.AccountNumber == AccountNumber);
if (myAcount == null)
{
throw new Exception("Dieses Buchungskonto wurde im System nicht gefunden.");
}
else
{
dbContext.Accounts.DeleteOnSubmit(myAcount);
dbContext.SubmitChanges();
}
}
/// <summary>
/// Loescht eine Auftrags/Rechnungsverknuepfung
/// </summary>
/// <param name="OrderNumber">AuftragsID</param>
/// <param name="invoiceId">RechnungsID</param>
/// <param name="dbContext">DB Kontext</param>
public static void DeleteOrderInvoice(int orderNumber, int invoiceId, DataClasses1DataContext dbContext)
{
var item = dbContext.OrderInvoice.SingleOrDefault(q => q.OrderNumber == orderNumber && q.InvoiceId == invoiceId);
if (item == null)
{
var invoiceNumber = dbContext.Invoice.Where(q => q.Id == invoiceId).Select(q => q.InvoiceNumber.Number).SingleOrDefault();
throw new Exception("Es existiert keine Verknüpfung zwischen dem Auftrag Nr. " + orderNumber + " und der Rechnung Nr. " + invoiceNumber);
}
dbContext.OrderInvoice.DeleteOnSubmit(item);
dbContext.WriteLogItem("Verknüpfung zwischen Auftrag Nr. " + item.Order.OrderNumber + " und Rechnung Nr. " +
item.Invoice.InvoiceNumber.Number + " wurde gelöscht.",
LogTypes.DELETE, orderNumber, "OrderInvoice", invoiceId);
}
