private void dataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
RuntimeData rData = ((RuntimeData)e.Row.Item);
double weight;
if (double.TryParse((e.EditingElement as TextBox).Text, out weight))
{
if (e.Column.Header.ToString() == "Billed Weight")
{
rData.BilledWeight = weight;
}
else if (e.Column.Header.ToString() == "Billed Amount")
{
rData.FrAmount = (decimal)weight;
}
}
else
{
MessageBox.Show("Unable to edit record!! Please check if input does not contain any invalid characters.", "Error");
return;
}
if (rData == null)
{
MessageBox.Show("Unable to edit record....");
return;
}
RuntimeData sData = dataGridHelper.getCurrentDataStack.SingleOrDefault(x => x.ConsignmentNo == rData.ConsignmentNo);
if (sData == null)
{
MessageBox.Show("Unable to edit transaction. Please reload the data and try again..", "Error");
return;
}
BillingDataDataContext db = new BillingDataDataContext();
RuntimeData dData = db.RuntimeDatas.SingleOrDefault(x => x.ConsignmentNo == rData.ConsignmentNo && x.UserId == SecurityModule.currentUserName && dataGridHelper.currentSheetNumber == x.SheetNo);
if (dData == null)
{
MessageBox.Show("Unable to edit transaction. Please check if data exists and try again..", "Error");
return;
}
if (e.Column.Header.ToString() == "Billed Weight")
{
dData.BilledWeight = rData.BilledWeight;
dData.FrAmount = (decimal)UtilityClass.getCost(rData.CustCode, weight, rData.Destination, rData.Type.Trim(), rData.DOX ?? 'N');
db.SubmitChanges();
rData.FrAmount = dData.FrAmount;
sData.BilledWeight = dData.BilledWeight;
sData.FrAmount = dData.FrAmount;
}
if (e.Column.Header.ToString() == "Billed Amount")
{
dData.FrAmount = rData.FrAmount;
db.SubmitChanges();
sData.FrAmount = rData.FrAmount;
}
}
}
private void AddstockLabel_Click(object sender, RoutedEventArgs e)
{
bool flag = false;
if (getdetails())
{
BillingDataDataContext db = new BillingDataDataContext();
if (!isUpdate)
{
db.Stocks.InsertOnSubmit(this.s);
try
{
try
{
db.SubmitChanges();
flag = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); flag = false; return; }
}
catch (Exception d) { flag = false; MessageBox.Show(d.Message); return; }
if (flag)
{
MessageBox.Show("Stock added", "Info");
this.Close();
}
}
else
{
Stock stockEntry = db.Stocks.SingleOrDefault(x => x.ID == s.ID);
if (stockEntry == null)
{
MessageBox.Show("This stock entry doesn't exists", "Error");
return;
}
else
{
stockEntry.BookNo = s.BookNo;
stockEntry.cost = s.cost;
stockEntry.Date = s.Date;
stockEntry.desc = s.desc;
stockEntry.StockEnd = s.StockEnd;
stockEntry.StockStart = s.StockStart;
stockEntry.UserId = s.UserId;
try
{
db.SubmitChanges();
MessageBox.Show("Stock successfully updated");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("Cannot update stock entry. Error: " + ex.Message);
}
}
}
}
}
private void Save_Click(object sender, RoutedEventArgs e)
{
try
{
db.SubmitChanges();
MessageBox.Show("Data saved..", "Information");
TitleTextBox.Text = " Manage Expense";
}
catch (Exception exe)
{
MessageBox.Show("Unable to add data... Error: " + exe.Message, "Error");
}
}
private void DeleteRule_Click(object sender, RoutedEventArgs e)
{
BillingDataDataContext db = new BillingDataDataContext();
if (CostingRuleGrid.Visibility == Visibility.Visible && CostingRuleGrid.SelectedItems != null)
{
if (MessageBox.Show("Do you want delete " + CostingRuleGrid.SelectedItems.Count.ToString() + " Rule", "Confirm", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
List <CostingRule> dcr = CostingRuleGrid.SelectedItems.Cast <CostingRule>().ToList();
CostingRuleGrid.SelectedItem = null;
List <int> Ids = dcr.Select(x => x.Id).ToList();
List <Rule> dr = db.Rules.Where(x => Ids.Contains(x.ID)).ToList();
db.Rules.DeleteAllOnSubmit(dr);
}
}
if (ServiceRuleGrid.Visibility == Visibility.Visible && ServiceRuleGrid.SelectedItems != null)
{
if (MessageBox.Show("Do you want delete " + ServiceRuleGrid.SelectedItems.Count.ToString() + " Rule", "Confirm", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
List <ServiceRule> dcr = ServiceRuleGrid.SelectedItems.Cast <ServiceRule>().ToList();
ServiceRuleGrid.SelectedItem = null;
List <int> Ids = dcr.Select(x => x.Id).ToList();
List <Rule> dr = db.Rules.Where(x => Ids.Contains(x.ID)).ToList();
db.Rules.DeleteAllOnSubmit(dr);
}
}
db.SubmitChanges();
LoadClientRules();
this.CostingRuleGrid.Items.Refresh();
this.ServiceRuleGrid.Items.Refresh();
}
private void EditRule_Click(object sender, RoutedEventArgs e)
{
BillingDataDataContext db = new BillingDataDataContext();
if (CostingRuleGrid.Visibility == Visibility.Visible && CostingRuleGrid.SelectedItem != null)
{
if (MessageBox.Show("Do you Want edit this Rule", "", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
CostingRule dcr = (CostingRule)CostingRuleGrid.SelectedItem;
AddRule win = new AddRule(dcr.Id);
win.Closed += win_Closed;
win.Show();
CostingRuleGrid.SelectedItem = null;
}
}
if (ServiceRuleGrid.Visibility == Visibility.Visible && ServiceRuleGrid.SelectedItem != null)
{
if (MessageBox.Show("Do you Want edit this Rule", "", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
ServiceRule dcr = (ServiceRule)ServiceRuleGrid.SelectedItem;
AddServiceRule win = new AddServiceRule(dcr.Id);
win.Closed += win_Closed;
win.Show();
ServiceRuleGrid.SelectedItem = null;
}
}
db.SubmitChanges();
}
private void DeleteEmployeeGrid_Click(object sender, RoutedEventArgs e)
{
BillingDataDataContext db = new BillingDataDataContext();
if (mangaEmployeegrid.SelectedItem != null)
{
if (((Employee)mangaEmployeegrid.SelectedItem).UserName != Configs.Default.SuperUser)
{
var emp = db.Employees.Where(x => x.Id == ((Employee)mangaEmployeegrid.SelectedItem).Id).FirstOrDefault();
emp.Status = 'D';
try
{
db.SubmitChanges();
reloadgrid(null, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
else
{
MessageBox.Show("Super User cannot be deleted");
}
}
}
private void DeleteCityButton_Click(object sender, RoutedEventArgs e)
{
if (CityDataGrid.SelectedItems.Count != 1)
{
MessageBox.Show("Select 1 city to delete");
return;
}
MessageBoxResult result = MessageBox.Show("Are you sure you want to delete this city?", "Confirm", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
if (db == null)
{
db = new BillingDataDataContext();
}
City city = db.Cities.SingleOrDefault(x => x.CITY_CODE == ((City)CityDataGrid.SelectedItem).CITY_CODE);
if (city == null)
{
MessageBox.Show("No such city exists.");
return;
}
db.Cities.DeleteOnSubmit(city);
db.SubmitChanges();
}
ReloadCityButton_Click(null, null);
}
private void DeleteClientGridButton_Click(object sender, RoutedEventArgs e)
{
if (mangaclientgrid.SelectedItems.Count != 1)
{
MessageBox.Show("Please select 1 client to delete", "Error");
return;
}
if (MessageBox.Show("Are you sure you want to delete this client?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
Client client = (Client)mangaclientgrid.SelectedItem;
client = db.Clients.SingleOrDefault(x => x.CLCODE == client.CLCODE);
if (client == null)
{
MessageBox.Show("This client does not exists.", "Error");
return;
}
if (client.CLCODE == "<NONE>" || client.CLCODE == "<DTDC>")
{
MessageBox.Show("This client cannot be deleted");
return;
}
db.Clients.DeleteOnSubmit(client);
try
{
db.SubmitChanges();
MessageBox.Show("Client deleted.", "Success");
}
catch (Exception ex)
{
MessageBox.Show("Deletion failed with error : " + ex.Message, "Failure");
}
DataSources.refreshClientList();
ReloadClientGridButton_Click(null, null);
}
}
private void updateEmployee()
{
if (Password.Password == ConfirmPass.Password && Password.Password != "" && Password.Password != null)
{
setEmpFromFields();
BillingDataDataContext db = new BillingDataDataContext();
Employee data = db.Employees.Single(x => x.Id == emp.Id);
removeduplicatePermission();
db.User_permissions.InsertAllOnSubmit(returnUserPermissionList((List <Permission>)(viewsourceUserPermission.Source)));
setDataFromEmp(data);
try
{
db.SubmitChanges();
isaddinsert = true;
SecurityModule.Reload();
}
catch (Exception ex) { MessageBox.Show(ex.Message); isaddinsert = false; return; }
this.Close();
}
else
{
MessageBox.Show("Password Invalid");
}
if (isaddinsert)
{
MessageBox.Show("Employee Updated");
this.Close();
}
}
public void add()
{
string errorMsg = validate();
if (errorMsg == "")
{
client = new Client();
client.CLNAME = ClientName.Text;
client.Status = 'A';
client.ADDRESS = ClientAddress.Text;
client.CONTACTNO = ClientPhoneNo.Text;
client.EMAILID = CLientEmailAddress.Text;
client.CLCODE = ClientCode.Text;
client.FUEL = float.Parse(ClientFuel.Text);
client.INTRODATE = DateTime.Now;
client.STAX = float.Parse(ServiceTax.Text);
client.AMTDISC = float.Parse(DiscountBox.Text);
db.Clients.InsertOnSubmit(client);
try
{
db.SubmitChanges();
DataSources.refreshClientList();
}
catch (Exception ex) { MessageBox.Show(ex.Message); return; }
this.Close();
}
else
{
MessageBox.Show("Please correct following errors: " + errorMsg);
}
}
void worker_DoWork(object sender, DoWorkEventArgs e)
{
Func <Transaction, bool> whereQuery = (Func <Transaction, bool>)e.Argument;
worker.ReportProgress(1);
BillingDataDataContext db = new BillingDataDataContext();
List <Transaction> transactions = db.Transactions.Where(whereQuery).ToList();
double transCount = transactions.Count;
double i = 0;
foreach (Transaction trans in transactions)
{
if (trans.ConnsignmentNo == "X10477603")
{
Debug.WriteLine("ABC");
}
trans.AmountCharged = (decimal)UtilityClass.getCost(trans.CustCode, trans.BilledWeight ?? 0, trans.Destination, trans.Type.Trim(), trans.DOX);
if (trans.Insurance != null)
{
trans.AmountCharged = trans.AmountCharged + (decimal)trans.Insurance;
}
worker.ReportProgress((int)((i / transCount) * 94 + 1));
i++;
}
ChangeSet changeSet = db.GetChangeSet();
db.SubmitChanges();
worker.ReportProgress(100);
e.Result = "Completed for " + ((int)transCount).ToString() + " transactions";
}
public void update()
{
string errorMsg = validate();
if (errorMsg == "")
{
var db = new BillingDataDataContext();
var data = db.Clients.Single(x => x.CLCODE == client.CLCODE);
data.CLNAME = ClientName.Text ?? "";
data.ADDRESS = ClientAddress.Text ?? "";
data.EMAILID = CLientEmailAddress.Text ?? "";
data.CONTACTNO = ClientPhoneNo.Text ?? "";
data.FUEL = double.Parse(ClientFuel.Text ?? "");
data.STAX = double.Parse(ServiceTax.Text);
data.AMTDISC = double.Parse(DiscountBox.Text);
try
{
db.SubmitChanges();
}
catch (Exception ex) { MessageBox.Show(ex.Message); return; }
this.Close();
}
else
{
MessageBox.Show("Please correct following errors: " + errorMsg);
}
}
private void AddNewEmployee()
{
if (Password.Password == ConfirmPass.Password && Password.Password != "" && Password.Password != null)
{
setEmpFromFields();
emp.Status = 'A';
BillingDataDataContext db = new BillingDataDataContext();
db.Employees.InsertOnSubmit(emp);
Debug.WriteLine("Type is" + UserPermisstionToset.ItemsSource.GetType().ToString());
db.User_permissions.InsertAllOnSubmit(returnUserPermissionList((List <Permission>)(viewsourceUserPermission.Source)));
try
{
db.SubmitChanges();
isaddinsert = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); isaddinsert = false; return; }
this.Close();
}
else
{
MessageBox.Show("Password Invalid");
}
if (isaddinsert)
{
MessageBox.Show("Employee Add");
this.Close();
}
}
private void DeleteInvoiceButton_Click(object sender, RoutedEventArgs e)
{
if (InvoiceDatagrid.SelectedItems.Count != 1)
{
MessageBox.Show("Please select 1 invoice to delete", "Message");
return;
}
if (MessageBox.Show("Are you sure you want to delete this invoice?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
BillingDataDataContext db = new BillingDataDataContext();
Invoice invoice = db.Invoices.SingleOrDefault(x => x.BillId == ((Invoice)InvoiceDatagrid.SelectedItem).BillId);
if (invoice == null)
{
MessageBox.Show("This invoice doesn't exists or has already been deleted..", "Error");
return;
}
db.Invoices.DeleteOnSubmit(invoice);
try
{
db.SubmitChanges();
MessageBox.Show("Invoice successfully deleted. Click on fetch button to view the changes.", "Success");
}
catch (Exception ex)
{
MessageBox.Show("Error in deleting invoice. Error Message: " + ex.Message, "Error");
}
}
}
private void ImportRulesButton_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("You have selected " + CostingRuleGrid.SelectedItems.Count + " Costing Rules and " + ServiceRuleGrid.SelectedItems.Count + " Service Rules. Are you sure you want to import them? ", "Confirm", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
List <CostingRule> costingRules = CostingRuleGrid.SelectedItems.Cast <CostingRule>().ToList();
List <ServiceRule> serviceRules = ServiceRuleGrid.SelectedItems.Cast <ServiceRule>().ToList();
BillingDataDataContext db = new BillingDataDataContext();
Quotation quotation = db.Quotations.Single(x => x.CLCODE == clientO.CLCODE);
foreach (CostingRule CRule in costingRules)
{
int id;
id = Convert.ToInt32(db.ExecuteQuery <decimal>("SELECT IDENT_CURRENT('Rule') +1;").FirstOrDefault());
CRule.Id = id;
JavaScriptSerializer js = new JavaScriptSerializer();
string serialized = js.Serialize(CRule);
Rule r = new Rule();
r.Type = 1;
r.Properties = serialized;
r.QID = quotation.Id;
r.Remark = "Imported rule from " + client.CLNAME;
db.Rules.InsertOnSubmit(r);
db.SubmitChanges();
}
foreach (ServiceRule SRule in serviceRules)
{
int id;
id = Convert.ToInt32(db.ExecuteQuery <decimal>("SELECT IDENT_CURRENT('Rule') +1;").FirstOrDefault());
SRule.Id = id;
JavaScriptSerializer js = new JavaScriptSerializer();
string serialized = js.Serialize(SRule);
Rule r = new Rule();
r.Type = 2;
r.Properties = serialized;
r.QID = quotation.Id;
r.Remark = "Imported rule from " + client.CLNAME;
db.Rules.InsertOnSubmit(r);
db.SubmitChanges();
}
MessageBox.Show("Rules imported.");
this.Close();
}
}
private void SaveInvoiceButton_Click(object sender, RoutedEventArgs e)
{
if (source == null)
{
MessageBox.Show("Please print the invoice first...", "Error");
return;
}
MessageBoxResult result = MessageBox.Show("Do you want to save this invoice? ", "Confirm", MessageBoxButton.YesNo);
int count = source.Where(x => x.TransactionId == null || x.TransactionId == Guid.Empty).Count();
if (count > 0)
{
MessageBox.Show("Selected transactions set contains records that are not yet saved in the database. This bill cannot be saved.");
return;
}
if (result == MessageBoxResult.Yes)
{
BillingDataDataContext db = new BillingDataDataContext();
if (db.Invoices.Where(x => x.BillId == invoice.BillId).Count() > 0)
{
MessageBox.Show("This invoice is already saved", "Error..");
return;
}
try
{
db.Invoices.InsertOnSubmit(invoice);
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
return;
}
foreach (var item in source)
{
InvoiceAssignment assign = new InvoiceAssignment();
assign.BillId = invoice.BillId;
assign.Id = Guid.NewGuid();
assign.TransactionId = (Guid)item.TransactionId;
assign.BilledAmount = (double)(item.FrAmount ?? 0);
assign.BilledWeight = (double)(item.BilledWeight ?? item.Weight);
assign.Destination = item.Destination;
assign.DestinationDesc = item.CITY_DESC;
db.InvoiceAssignments.InsertOnSubmit(assign);
}
try
{
db.SubmitChanges();
MessageBox.Show("Invoice Saved... ", "Information");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void insertRuntimeData(List <RuntimeData> data, int sheetNo, bool isLoadedFromFile, DateTime?toDate = null, DateTime?fromDate = null)
{
BillingDataDataContext db = new BillingDataDataContext();
if (isLoadedFromFile == false)
{
return;
}
foreach (var runData in data)
{
runData.UserId = SecurityModule.currentUserName;
runData.SheetNo = sheetNo;
db.RuntimeDatas.InsertOnSubmit(runData);
db.SubmitChanges();
}
db.SubmitChanges();
data.Clear();
}
public bool SaveData()
{
BillingDataDataContext db = new BillingDataDataContext();
RuntimeData data = null;
data = fillData(data);
if (data == null)
{
return(false);
}
data.SheetNo = sheetNo;
data.UserId = SecurityModule.currentUserName;
if (!SubClientList.ContainsKey(data.CustCode))
{
SubClientList.Add(data.CustCode, new List <string>()
{
data.SubClient
});
}
else
{
if (!SubClientList[data.CustCode].Contains(data.SubClient))
{
SubClientList[data.CustCode].Add(data.SubClient);
}
}
if (!ConsignerList.Contains(data.ConsignerName))
{
ConsignerList.Add(data.ConsignerName);
}
if (!ConsigneeList.Contains(data.ConsigneeName))
{
ConsigneeList.Add(data.ConsigneeName);
}
if (dataContext.Where(x => x.ConsignmentNo == data.ConsignmentNo).Count() > 0)
{
RuntimeData origData = db.RuntimeDatas.SingleOrDefault(x => x.Id == data.Id);
dupliData(data, origData);
}
else
{
db.RuntimeDatas.InsertOnSubmit(data);
dataContext.Add(data);
helper.addRecordToCurrentSheet(data);
dataListContext.AddNewItem(data);
}
try
{
db.SubmitChanges();
}
catch (Exception ex) { MessageBox.Show(ex.Message); return(false); }
return(true);
}
private void removeduplicatePermission()
{
var db = new BillingDataDataContext();
List <User_permission> temp = (from a in db.User_permissions select a).Where(x => x.emp_id == emp.Id).ToList();
db.User_permissions.DeleteAllOnSubmit(temp);
try
{
db.SubmitChanges();
}
catch (Exception ex) { MessageBox.Show(ex.Message); return; }
}
void bg_DoWork(object sender, DoWorkEventArgs e)
{
string fileName = (string)e.Argument;
CSVDataLoader csvDL = new CSVDataLoader();
List <RuntimeData> data = csvDL.getRuntimeDataFromPodCSV(fileName, '"', '\'');
double progress = 5;
bg.ReportProgress((int)progress);
double i = 0;
double count = data.Count;
BillingDataDataContext db = new BillingDataDataContext();
string errorMessage = "";
foreach (RuntimeData rData in data)
{
try
{
Transaction trans = db.Transactions.SingleOrDefault(x => x.ConnsignmentNo == rData.ConsignmentNo);
if (trans != null)
{
trans.DeliveryDate = rData.DeliveryDate;
if (rData.DeliveryDate != null)
{
trans.DeliveryStatus = "Delivered";
}
trans.DeliveryTime = rData.DeliveryTime;
trans.ReceivedBy = rData.ReceivedBy;
trans.Remarks = trans.Remarks;
db.Transactions.InsertOnSubmit(trans);
db.SubmitChanges();
}
else
{
notFound.Add(rData);
}
}
catch
{
errorMessage += rData.ConsignmentNo + " ";
}
i++;
int prog = (int)(progress + (i / count * 85));
bg.ReportProgress(prog);
}
e.Result = errorMessage;
bg.ReportProgress(100);
}
private void CostingRuleGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
double rate;
if (double.TryParse((e.EditingElement as TextBox).Text, out rate))
{
try
{
BillingDataDataContext db = new BillingDataDataContext();
CostingRule origRule = e.Row.Item as CostingRule;
Rule newRule = db.Rules.SingleOrDefault(x => x.ID == origRule.Id);
if (newRule == null)
{
MessageBox.Show("Unable to find this rule in database....", "Error");
e.Cancel = true;
return;
}
JavaScriptSerializer jss = new JavaScriptSerializer();
CostingRule crr = jss.Deserialize <CostingRule>(newRule.Properties);
if (e.Column.Header.ToString() == "Non-Dox (Rs)")
{
crr.ndoxAmount = rate;
}
if (e.Column.Header.ToString() == "Dox (Rs)")
{
crr.doxAmount = rate;
}
newRule.Properties = jss.Serialize(crr);
db.SubmitChanges();
}
catch (Exception)
{
MessageBox.Show("Unable to save data....", "Error");
e.Cancel = true;
return;
}
}
else
{
MessageBox.Show("Invalid Input.. ", "Error");
e.Cancel = true;
}
}
}
private void AddUpdate_Click(object sender, RoutedEventArgs e)
{
bool isdone = false;
getfield();
BillingDataDataContext db = new BillingDataDataContext();
City lcity = db.Cities.SingleOrDefault(x => x.CITY_CODE == this.city.CITY_CODE);
if (isupdate)
{
if (city == null)
{
isupdate = false;
}
else
{
lcity.CITY_DESC = this.city.CITY_DESC;
lcity.CITY_STATE = this.city.CITY_STATE;
lcity.ZONE = this.city.ZONE;
}
}
if (!isupdate)
{
if (lcity != null)
{
MessageBox.Show("A city with this code is already present....", "Error");
return;
}
city.Status = 'A';
db.Cities.InsertOnSubmit(this.city);
}
try
{
db.SubmitChanges();
isdone = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); isdone = false; return; }
if (isdone)
{
MessageBox.Show("City Added");
this.Close();
}
}
void bg_DoWork(object sender, DoWorkEventArgs e)
{
string fileName = (string)e.Argument;
CSVDataLoader csvDL = new CSVDataLoader();
List <RuntimeData> data = csvDL.getRuntimeDataFromCSV(fileName, '"', '\'');
double progress = 5;
bg.ReportProgress((int)progress);
double i = 0;
double count = data.Count;
BillingDataDataContext db = new BillingDataDataContext();
int sheetNo;
string errorMessage = "";
try
{
sheetNo = db.RuntimeDatas.Max(x => x.SheetNo) + 1;
}
catch (Exception)
{
sheetNo = 0;
}
foreach (RuntimeData rData in data)
{
try
{
rData.SheetNo = sheetNo;
rData.UserId = "System";
db.RuntimeDatas.InsertOnSubmit(rData);
db.SubmitChanges();
}
catch
{
errorMessage += rData.ConsignmentNo + " ";
}
i++;
int prog = (int)(progress + (i / count * 85));
bg.ReportProgress(prog);
}
db.ImportFileData(sheetNo, "System", SecurityModule.currentUserName);
e.Result = errorMessage;
bg.ReportProgress(100);
}
private void AddZoneButton_Click(object sender, RoutedEventArgs e)
{
string errorMsg = "";
BillingDataDataContext db = new BillingDataDataContext();
if (Zonecodebox.Text == "")
{
errorMsg = errorMsg + "Please enter a proper zone code. \n";
}
else
{
List <ZONE> zones = db.ZONEs.Where(x => x.zcode == Zonecodebox.Text).ToList();
if (zones.Count > 0)
{
errorMsg = errorMsg + "A zone with this code already exists. \n";
}
}
if (ZoneNameTextBox.Text == "")
{
errorMsg = errorMsg + "Please enter a proper zone name. \n";
}
if (errorMsg != "")
{
MessageBox.Show("Please correct the following errors: \n" + errorMsg);
return;
}
ZONE z = new ZONE();
z.Id = Guid.NewGuid();
z.Mode = 'A';
z.Zone_name = this.ZoneNameTextBox.Text;
z.zcode = this.Zonecodebox.Text;
db.ZONEs.InsertOnSubmit(z);
try
{
db.SubmitChanges();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
this.Close();
}
private void DeleteStockButton_Click(object sender, RoutedEventArgs e)
{
if (StockAssignmentDatagrid.SelectedItems.Count != 1)
{
MessageBox.Show("Please select delete Entry to edit.", "Info");
return;
}
if (MessageBox.Show("Are you sure want to delete this entry. This cant be undone!!", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
StockAssignmentView AssignmentEntry = (StockAssignmentView)StockAssignmentDatagrid.SelectedItem;
BillingDataDataContext db = new BillingDataDataContext();
Stock selectedStock = db.Stocks.SingleOrDefault(x => x.ID == AssignmentEntry.SrlNo);
if (selectedStock == null)
{
MessageBox.Show("Selected stock doesn't exists..", "Error");
return;
}
db.Stocks.DeleteOnSubmit(selectedStock);
db.SubmitChanges();
}
}
private void DeleteRecieptButton_Click(object sender, RoutedEventArgs e)
{
if (PaymentGrid.SelectedItems.Count != 1)
{
MessageBox.Show("Please select one payment entry to delete", "Error");
return;
}
if (MessageBox.Show("Are you sure you want to delete this payment entry. This operation cannot be reversed.", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
PaymentEntry paymentEntry = (PaymentEntry)PaymentGrid.SelectedItem;
BillingDataDataContext db = new BillingDataDataContext();
paymentEntry = db.PaymentEntries.SingleOrDefault(x => x.Id == paymentEntry.Id);
if (paymentEntry == null)
{
MessageBox.Show("Cannot find this payment entry!!!", "Error");
return;
}
db.PaymentEntries.DeleteOnSubmit(paymentEntry);
db.SubmitChanges();
MessageBox.Show("Entry deleted!! Please fetch again to see changes.", "Info");
}
}
private void AddZoneButton_Click(object sender, RoutedEventArgs e)
{
BillingDataDataContext db = new BillingDataDataContext();
List <Transaction> trans = db.Transactions.Where(x => x.ConnsignmentNo == Zonecodebox.Text).ToList();
List <RuntimeData> runT = db.RuntimeDatas.Where(x => x.ConsignmentNo == Zonecodebox.Text).ToList();
int userCount = runT.Select(x => x.UserId).Distinct().Count();
int sheetCount = runT.Select(x => x.SheetNo.ToString() + x.UserId).Distinct().Count();
if (MessageBox.Show("Transaction is loaded in " + sheetCount.ToString() + " sheets for " + userCount.ToString() + " users. Vortext must be restarted for changes to take effect. Continue?", "Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
db.RuntimeDatas.DeleteAllOnSubmit(runT);
db.Transactions.DeleteAllOnSubmit(trans);
try
{
db.SubmitChanges();
MessageBox.Show("Deleted successfully.", "Information");
}
catch (Exception)
{
MessageBox.Show("Unable to delete transactions.", "Error");
}
}
}
private void Next_Click(object sender, RoutedEventArgs e)
{
if (currentCanvas == 2)
{ //Data Source=SYSTEM;Initial Catalog=BillingDatabase;User ID=sa;Password=Alver!22
constring.DataSource = this.ServerNameBox.Text;
constring.InitialCatalog = this.databaseBox.Text;
constring.UserID = this.UserNameBox.Text;
constring.Password = this.PasswordBox.Password;
string provider = "System.Data.SqlClient"; // for example
DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
using (DbConnection conn = factory.CreateConnection())
{
conn.ConnectionString = constring.ConnectionString;
try
{
conn.Open();
isconnected = true;
Configs.Default.BillingDatabaseConnectionString = constring.ConnectionString;
Configs.Default.Save();
}
catch (Exception)
{
MessageBox.Show("Unable to connect to server"); isconnected = false; return;
}
}
MessageBox.Show("Connected successfully");
}
if (currentCanvas == 3)
{
if (this.UserPasswordBox.Password == this.UserCPasswordBox.Password)
{
BillingDataDataContext db = new BillingDataDataContext(constring.ConnectionString);
this.emp.UserName = this.EUserNameBox.Text;
this.emp.Password = this.UserPasswordBox.Password;
this.emp.EMPCode = "Super";
this.emp.Id = Guid.NewGuid();
this.emp.Gender = 'M';
this.emp.Status = 'A';
this.emp.Name = "<none>";
Configs.Default.CompanyName = CompanyNameBox.Text;
Configs.Default.Save();
Employee emp = db.Employees.SingleOrDefault(x => x.UserName == this.emp.UserName);
if (emp != null)
{
if (!(MessageBox.Show("This employee already exists. Do you want to make this employee super on this system?", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes))
{
MessageBox.Show("Please enter different employee name", "Error");
return;
}
}
else
{
db.Employees.InsertOnSubmit(emp);
}
try {
Configs.Default.SuperUser = this.emp.UserName;
Configs.Default.Save();
db.SubmitChanges();
}
catch (Exception ex) { MessageBox.Show(ex.Message); return; }
}
else
{
MessageBox.Show("Password do not match", "Error"); return;
}
}
switch (currentCanvas)
{
case 1:
currentCanvas = 2;
Step1.Visibility = Visibility.Collapsed;
currentCanvasObj = Step2;
currentCanvasObj.Visibility = Visibility.Visible;
Previous.Visibility = Visibility.Visible;
break;
case 2:
currentCanvas = 3;
currentCanvasObj.Visibility = Visibility.Collapsed;
currentCanvasObj = Step3;
currentCanvasObj.Visibility = Visibility.Visible;
Previous.Visibility = Visibility.Visible;
break;
case 3:
currentCanvas = 4;
currentCanvasObj.Visibility = Visibility.Collapsed;
currentCanvasObj = Step4;
currentCanvasObj.Visibility = Visibility.Visible;
Previous.Visibility = Visibility.Collapsed;
break;
case 4:
currentCanvas = 5;
currentCanvasObj.Visibility = Visibility.Collapsed;
currentCanvasObj = Step5;
currentCanvasObj.Visibility = Visibility.Visible;
Previous.Visibility = Visibility.Collapsed;
break;
}
if (currentCanvas == 5)
{
Next.Visibility = Visibility.Collapsed;
Finish.Visibility = Visibility.Visible;
}
else
{
Next.Visibility = Visibility.Visible;
Finish.Visibility = Visibility.Collapsed;
}
}
private void SubmitButton_Click(object sender, RoutedEventArgs e)
{
bool isdone = false;
PaymentEntry paymentEntry = new PaymentEntry();
string errorMessage = "";
paymentEntry.Id = PaymentRefNoBox.Text;
double tempStorage;
if (!double.TryParse(AmountTextBox.Text, out tempStorage))
{
errorMessage += "Amount is not in correct format. \n";
}
else
{
paymentEntry.RecievedAmount = tempStorage;
}
if (InvoiceSelectRadio.IsChecked == true)
{
Invoice invoice = (Invoice)InvoiceComboBox.SelectedItem;
paymentEntry.InvoiceNumber = invoice.BillId;
paymentEntry.ClientCode = invoice.ClientCode;
}
else
{
Client client = (Client)ClientComboBox.SelectedItem;
paymentEntry.ClientCode = client.CLCODE;
}
if (PaymentDatePicker.SelectedDate != null)
{
paymentEntry.Date = (DateTime)PaymentDatePicker.SelectedDate;
}
else
{
errorMessage += "Payment Entry Date is not Selected. \n";
}
if ((bool)ChequeRadio.IsChecked)
{
paymentEntry.Type = "Cheque";
if (ChequeNumberBox.Text == "")
{
errorMessage += "Enter the cheque number. \n";
}
else
{
paymentEntry.ChequeNumber = ChequeNumberBox.Text;
}
if (ChequeBankName.Text == "")
{
errorMessage += "Enter bank name: \n";
}
else
{
paymentEntry.BankName = ChequeBankName.Text;
}
}
else
{
paymentEntry.Type = "Cash";
}
paymentEntry.Remarks = RemarkBox.Text;
if (double.TryParse(DebitNoteBox.Text, out tempStorage))
{
paymentEntry.DebitNote = tempStorage;
}
else
{
errorMessage += "Enter debit note properly \n";
}
if (double.TryParse(TDSBox.Text, out tempStorage))
{
paymentEntry.TDS = tempStorage;
}
else
{
errorMessage += "Enter TDS properly \n";
}
if (errorMessage == "")
{
BillingDataDataContext db = new BillingDataDataContext();
db.PaymentEntries.InsertOnSubmit(paymentEntry);
try
{
db.SubmitChanges();
isdone = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); isdone = false; return; }
}
else
{
MessageBox.Show("Please correct the following errors: \n" + errorMessage);
}
if (isdone)
{
MessageBox.Show("Payment Received\nReference no is " + paymentEntry.Id);
fillFields();
}
}
private void AddRuleButton_Click(object sender, RoutedEventArgs e)
{
Rule r;
BillingDataDataContext db = new BillingDataDataContext();
if (!isUpdate)
{
r = new Rule();
}
else
{
if (rule != null)
{
r = rule;
}
else
{
MessageBox.Show("Some Error Occured");
r = new Rule();
this.Close();
}
}
double startW = 0, endW = 0;
string errorMsg = "";
double temp;
if (double.TryParse(FromWeightBox.Text, out temp))
{
startW = temp;
}
else
{
errorMsg = errorMsg + "Enter From Weight Properly \n";
}
if (double.TryParse(ToWeightBox.Text, out temp))
{
endW = temp;
}
else
{
errorMsg = errorMsg + "Enter To Weight Properly \n";
}
if (startW > endW)
{
errorMsg += "Starting weight cannot be greater than ending weight. \n";
}
char type = 'U';
if (RangeTypeRadio.IsChecked == true)
{
type = 'R';
}
if (StepTypeRadio.IsChecked == true)
{
type = 'S';
}
if (MultiplierTypeRadio.IsChecked == true)
{
type = 'M';
}
double doxAmount = 0, ndoxAmount = 0;
if (!double.TryParse(DOXAmountBox.Text, out doxAmount))
{
errorMsg += "Enter dox amount properly \n";
}
if (!double.TryParse(NDoxAmountBox.Text, out ndoxAmount))
{
errorMsg += "Enter non dox amount properly \n";
}
double doxStartValue = 0, ndoxStartValue = 0;
double stepweight = 0;
if (!double.TryParse(StepBlockBox.Text, out stepweight) && StepTypeRadio.IsChecked == true)
{
errorMsg += "Enter Step Weight Properly \n";
}
if (errorMsg != "")
{
MessageBox.Show("Please correct following errors: " + errorMsg);
return;
}
List <string> selectedServiceList = ((ServiceTwinBox.SelectedListSource) ?? new List <Service>()).Cast <Service>().Select(x => x.SER_CODE).ToList();
List <string> selectedZoneList = ((ZoneTwinBox.SelectedListSource) ?? new List <ZONE>()).Cast <ZONE>().Select(x => x.zcode).ToList();
List <String> selectedCityList = ((CitiesTwinBox.SelectedListSource) ?? new List <City>()).Cast <City>().Select(x => x.CITY_CODE).ToList();
List <string> selectedStateList = ((StateTwinBox.SelectedListSource) ?? new List <State>()).Cast <State>().Select(x => x.STATE_CODE).ToList();
List <string> selectedServiceGroupList = ((ServiceGroupTwinBox.SelectedListSource) ?? new List <ServiceGroup>()).Cast <ServiceGroup>().Select(x => x.GroupName).ToList();
RuleCR.ServiceList = selectedServiceList;
RuleCR.ZoneList = selectedZoneList;
RuleCR.CityList = selectedCityList;
RuleCR.StateList = selectedStateList;
RuleCR.ServiceGroupList = selectedServiceGroupList;
RuleCR.startW = startW;
int id;
id = Convert.ToInt32(db.ExecuteQuery <decimal>("SELECT IDENT_CURRENT('Rule') +1;").FirstOrDefault());
if (!isUpdate)
{
RuleCR.Id = id;
r.QID = quoation.Id;
}
RuleCR.endW = endW;
RuleCR.type = type;
RuleCR.doxAmount = doxAmount;
RuleCR.ndoxAmount = ndoxAmount;
RuleCR.stepWeight = stepweight;
RuleCR.dStartValue = doxStartValue;
RuleCR.ndStartValue = ndoxStartValue;
JavaScriptSerializer js = new JavaScriptSerializer();
string serialized = js.Serialize(RuleCR);
r.Type = 1;
r.Properties = serialized;
r.Remark = this.RemarkBox.Text ?? " ";
if (!isUpdate)
{
db.Rules.InsertOnSubmit(r);
}
else
{
Rule ruledb = db.Rules.Where(x => x.ID == r.ID).FirstOrDefault();
if (ruledb == null)
{
MessageBox.Show("Some Error Occured");
return;
}
else
{
setvalue(ruledb, r);
}
}
bool isdone = false;
if (validate())
{
try
{
db.SubmitChanges();
isdone = true;
}
catch (Exception ex) { MessageBox.Show(ex.Message); return; }
if (!isUpdate)
{
if (isdone)
{
if (MessageBox.Show("Do you want to add a new rule for this configuration of service and destination", "Confirm", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
FromWeightBox.Text = (RuleCR.endW + 0.0001).ToString();
ToWeightBox.Text = "";
currentGrid = 6;
currentGridObj.Visibility = Visibility.Collapsed;
currentGridObj = Step6Grid;
currentGridObj.Visibility = Visibility.Visible;
StepBlock.Text = "Step " + currentGrid.ToString() + " of 7";
}
else
{
this.Close();
}
}
}
else
{
if (isdone)
{
MessageBox.Show("Rule updated successfully", "Information");
this.Close();
}
}
}
}