private void loadCommercials()
{
DatabaseDataContext db = new DatabaseDataContext(); db.ObjectTrackingEnabled = false;
try
{
var query = (from com in db.PharmacyCommercials
where (com.chemicalName == chemicalName)
select new
{
name = com.name.Trim(),
company = com.company.Trim(),
morph = com.morph.Trim()
});
commercialMaxIndex = query.Count() / Util.resultSize;
grdCommercials.DataSource = query.Skip(commercialResultIndex * Util.resultSize).Take(Util.resultSize);
grdCommercials.DataBind();
int start = commercialResultIndex * Util.resultSize;
lblCommercialsIndex.Text = (start+1).ToString() + "-" + (start + grdCommercials.Rows.Count).ToString() + " of " + query.Count();
for (int i = 0; i < grdCommercials.Rows.Count; i++)
{
TableCell cell0 = grdCommercials.Rows[i].Cells[0];
TableCell cell1 = grdCommercials.Rows[i].Cells[1];
TableCell cell2 = grdCommercials.Rows[i].Cells[2];
HyperLink field0 = cell0.Controls[0] as HyperLink;
HyperLink field1 = cell1.Controls[0] as HyperLink;
HyperLink field2 = cell2.Controls[0] as HyperLink;
field0.NavigateUrl = Util.UrlRewriting.encodeUrl("viewCommercialPharmacy.aspx?name=" + field0.Text + "&company=" + field1.Text + "&morph=" + field2.Text);
field1.NavigateUrl = Util.UrlRewriting.encodeUrl("viewCommercialPharmacy.aspx?name=" + field0.Text + "&company=" + field1.Text + "&morph=" + field2.Text);
field2.NavigateUrl = Util.UrlRewriting.encodeUrl("viewCommercialPharmacy.aspx?name=" + field0.Text + "&company=" + field1.Text + "&morph=" + field2.Text);
}
if (commercialResultIndex + 1 > commercialMaxIndex)
{
btnCommercialsNext.Disabled = true;
// btnNext.Visible = false;
}
else
{
btnCommercialsNext.HRef = Util.UrlRewriting.encodeUrl("viewPharmacy.aspx?chemicalName=" + chemicalName + "&interactionsIndex=" + (interactionsResultIndex).ToString() + "&commercialsIndex=" + (commercialResultIndex + 1).ToString());
}
if (interactionsResultIndex - 1 < 0)
{
btnCommercialsPrev.Disabled = true;
// btnPrev.Visible = false;
}
else
{
btnCommercialsPrev.HRef = Util.UrlRewriting.encodeUrl("viewPharmacy.aspx?chemicalName=" + chemicalName + "&interactionsIndex=" + (interactionsResultIndex).ToString() + "&commercialsIndex=" + (commercialResultIndex - 1).ToString());
}
}
catch
{
//TODO : ektipioosi sostou lathous
Response.Write("Error");
}
}
public GTFS(Agency transitAgency)
: base(transitAgency)
{
db = new DatabaseDataContext();
agency = (from a in db.GTFS_Agencies where a.ID == transitAgency.AgencyID select a).Single();
}
public ActionResult EventDetails(string slug, int eventid)
{
var db = new DatabaseDataContext();
var currentevent =
db.Events.Single(_ => _.EventId == eventid);
ViewData["CurrentEvent"] = currentevent;
var mostrecentevent = db.Events.
Where(e => e.IncidentTime <= DateTime.Now && e.Lat != null).
Select(e => e.IncidentTime).
OrderByDescending(d => d).First().Value;
var earliestevent = db.Events.
Where(e => e.IncidentTime <= DateTime.Now && e.Lat != null).
Select(e => e.IncidentTime).
OrderBy(d => d).First().Value;
ViewData["Earliest"] = earliestevent.Year < 2008 ? new DateTime(2008, 1, 1) : earliestevent;
ViewData["MostRecent"] = mostrecentevent;
ViewData["Categories"] =
db.Categories.ToList().Concat(
new List<Category>() { new Category { DisplayName = "Andet", CategoryId = 42 } });
return View("../Home/Index");
}
protected void Button_Bereich_Speichern_Click(object sender, EventArgs e)
{
DatabaseDataContext d = new DatabaseDataContext();
if (bereich_neu)
{
Bereich b = new Bereich() { Id_Kran = kran_nr, Name = DropDownList_Bereich.SelectedItem.ToString() };
d.Bereich.InsertOnSubmit(b);
}
else
{
var kra = from k in d.Kran
where k.Id == kran_nr
select k;
//nochmal überdenken
var dat = from b in d.Bereich
where b.Name == DropDownList_Bereich.SelectedValue && b.Id_Kran == kra.First().Id
select b;
dat.First().Name = DropDownList_Bereich.SelectedItem.ToString();
}
d.SubmitChanges();
DropDownList_Bereich.Enabled = false;
Button_Bereich_Speichern.Enabled = false;
GridView_Kran_SelectedIndexChanged(sender, e);
//Button_Bereich_Bearbeiten.Enabled = true;
}
public override bool Load(int RowId)
{
CurrentConnection = new DatabaseDataContext();
var q = from x in CurrentConnection.tasks_calls where x.id.Equals(RowId) select x;
CurrentRow = q.FirstOrDefault();
return true;
}
/// <summary>
/// Find all statuses
/// </summary>
/// <returns>IQueryable rows</returns>
public static IQueryable FindAll()
{
using (DatabaseDataContext db = new DatabaseDataContext())
{
return from row in db.task_statuses
where row.deleted.Equals(0)
select new { id = row.id, name = row.name.Trim() };
}
}
private static int countCategoryPharmacies(DatabaseDataContext db, Category categ)
{
int cnt = 0;
var query = (from phar in db.PharmacyChemicals
where phar.SubCategory.categoryName == categ.categoryName
select phar);
cnt = query.Count();
return cnt;
}
public ActionResult Data(
string datemode, string startdate, string enddate,
string categories, string race,
string ne_lat, string ne_lng,
string sw_lat, string sw_lng)
{
IEnumerable<int?> cats = categories.Trim('-').
Split(new string[] { "-" }, StringSplitOptions.RemoveEmptyEntries).
Select(_ => (int?)int.Parse(_));
float nelat = float.Parse(ne_lat, CultureInfo.GetCultureInfo("en-US"));
float nelng = float.Parse(ne_lng, CultureInfo.GetCultureInfo("en-US"));
float swlat = float.Parse(sw_lat, CultureInfo.GetCultureInfo("en-US"));
float swlng = float.Parse(sw_lng, CultureInfo.GetCultureInfo("en-US"));
var enddt = DateTime.MaxValue;
var startdt = DateTime.MinValue;
var db = new DatabaseDataContext();
if (datemode == "day")
{
enddt = DateTime.Now.AddDays(1);
startdt = DateTime.Now.AddDays(-1);
}
else if (datemode == "week")
{
enddt = DateTime.Now.AddDays(1);
startdt = DateTime.Now.AddDays(-7);
}
else if (datemode == "month")
{
startdt =
DateTime.ParseExact(startdate, "MMM-yyyy", CultureInfo.GetCultureInfo("da-DK"));
enddt =
DateTime.ParseExact(enddate, "MMM-yyyy", CultureInfo.GetCultureInfo("da-DK"));
}
var repository = new EventRepository();
var events = from e in repository.GetGeocodedEvents(startdt, enddt)
where
e.Lat > swlat &&
e.Lat < nelat &&
e.Lng > swlng &&
e.Lng < nelng &&
((e.CategoryId.HasValue && cats.Contains(e.CategoryId.Value)) ||
(!e.CategoryId.HasValue && cats.Contains(42)))
select new object[] { e.Lat.Value, e.Lng.Value, e.EventId, e.CategoryId ?? 42 };
return this.Json(
new
{
count = events.Count(),
events = events,
});
}
public static void phanQuyenRibon(System.Windows.Forms.Form frm, NhanVien objnhanvien, DevExpress.XtraBars.Ribbon.RibbonControl ribbon)
{
using (DatabaseDataContext db = new DatabaseDataContext())
{
//lấy ra ID nhóm nhân viên
var objNhomNhanVien = db.pqNhomNhanViens.Where(p => p.MaNV == objnhanvien.ID).Select(p => p.GroupID);
var ModuleHasPermisson = db.pqAccessRights.Where(p => objNhomNhanVien.Contains(p.GroupID) & p.IsAccessRight == true).Select(p => p.pqModule);
var permissionOnModule = db.pqModule_FormControls.Where(p => p.pqModule == ModuleHasPermisson).Select(p => p.ControlName);
if (permissionOnModule.Count() <= 0 & frm.Name != "frm_Main")
{
frm.Close();
}
else
{
var lstModuleHasPermisson = ModuleHasPermisson.ToList();
var ControlHasPermisson = db.pqModule_FormControls.Where(p => lstModuleHasPermisson.Contains(p.pqModule)).Select(p => p.ControlName).ToList();
var nlstRibbobPage = getAllRibbonPage(ribbon).Where(p => ControlHasPermisson.Contains(p.Name)).ToList();
var nlstRibbobPageGroup = getAllRibbonPageGroup(ribbon).Where(p => ControlHasPermisson.Contains(p.Name)).ToList();
var nlstBarButtonItem = getAllBarButtonItem(ribbon).Where(p => ControlHasPermisson.Contains(p.Name)).ToList();
#region An control
getAllRibbonPage(ribbon).ForEach(item =>
{
item.Visible = false;
});
getAllRibbonPageGroup(ribbon).ForEach(item =>
{
item.Visible = false;
});
getAllBarButtonItem(ribbon).ForEach(item =>
{
item.Enabled = false;
});
#endregion
#region Hien control
foreach (DevExpress.XtraBars.BarButtonItem item in nlstBarButtonItem)
{
item.Enabled = true;
}
foreach (DevExpress.XtraBars.Ribbon.RibbonPage item in nlstRibbobPage)
{
item.Visible = true;
}
foreach (DevExpress.XtraBars.Ribbon.RibbonPageGroup item in nlstRibbobPageGroup)
{
item.Visible = true;
}
#endregion
}
}
}
protected void btnAgree_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
DatabaseDataContext db = new DatabaseDataContext();
Product xxx = db.Products.Single(x => x.ProductId == id);
MailMessage msgMail = new MailMessage();
//MailAddress _mailAdd = new MailAddress("*****@*****.**");
//msgMail.From = _mailAdd;
msgMail.Subject = "Globex Agreement";
msgMail.IsBodyHtml = true;
StringBuilder mailbody = new StringBuilder();
mailbody.Append(xxx.ProductName + "</br>");
mailbody.Append(xxx.Contract + "</br>");
mailbody.Append("---------</br> Last Name:" + txtLastName.Text + "</br>" + "First Name: " + txtFirstName.Text + "</br>");
mailbody.Append("Initial: " + txtInitials.Text + "</br>");
mailbody.Append("Street Address: " + txtAddress.Text + "</br>");
mailbody.Append("City : " + txtCity.Text + "</br>State" + txtState.Text + "</br>" + "ZipCode: " + txtZip.Text + "</br>");
mailbody.Append("Country : " + txtCountry.Text + "</br>");
mailbody.Append("Phone Number: " + txtPhone.Text + "</br>");
mailbody.Append("E-Mail Address: " + txtEmail.Text + "</br>");
mailbody.Append("Date:" + txtDate.Text + "</br>");
mailbody.Append("</br>" + xxx.Writeup + "</br>");
mailbody.Append("SignName: " + txtSingName.Text + "</br>");
mailbody.Append("SignDate: " + txtSingDate.Text + "</br>");
msgMail.Body = mailbody.ToString();
SmtpClient sq = new SmtpClient();
foreach (string email in ConfigurationManager.AppSettings["Email"].Split(';'))
{
msgMail.To.Clear();
msgMail.To.Add(email);
sq.Send(msgMail);
}
Response.Redirect("ThankYou.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (DatabaseDataContext con = new DatabaseDataContext()) {
#region checks
hideAllPlaceholders();
if (SessionManager.UserID == 0)
{
showError("You must be logged in to use this feature!");
Utilities.clearAllTextBoxes(viewMain);
return;
}
string EncodedResponse = Request.Form["g-Recaptcha-Response"];
bool IsCaptchaValid = (ReCaptcha.Validate(EncodedResponse) == "true" ? true : false);
if (!IsCaptchaValid)
{
showError("Prove that you are not a robot!");
return;
}
if (string.IsNullOrEmpty(txtEmergTitle.Text))
{
showError("Emergency title is empty!");
return;
}
#endregion
tblSession session = con.tblSessions.Where(x => x.SessionID == SessionManager.SessionID).FirstOrDefault();
try {
tblEmergency emergency = new tblEmergency {
EmergencyTitle = txtEmergTitle.Text,
EmergencyLatitude = session.SessionLatitude,
EmergencyLongitude = session.SessionLongitude,
EmergencyStatus = "Pending",
IsSeen = false,
EmergencyDate = DateTime.UtcNow,
UserID = SessionManager.UserID
};
con.tblEmergencies.InsertOnSubmit(emergency);
con.SubmitChanges();
showSuccess("Emergency notification has been issued successfully!");
Utilities.clearAllTextBoxes(viewMain);
NotificationManager.emergencySent();
} catch (Exception ex) {
showError("Error: " + ex);
Utilities.clearAllTextBoxes(viewMain);
}
}
}
private void SalePet(object paremeter)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
using (DatabaseDataContext db =
new DatabaseDataContext(
@"Server=10.30.169.46;Database=PetShop;User Id=sunny;Password=~123qwerty;"))
{
var pets = from pe in db.Pets where pe.PetName == PetName select pe;
if (pets.Count() > 1)
{
MessageBox.Show("Too many pets in the list", "Confirm", MessageBoxButton.YesNo);
return;
}
var matchedPet = pets.FirstOrDefault();
if (matchedPet != null)
{
matchedPet.Amount -= PetAmount;
}
if (matchedPet != null && PetAmount > matchedPet.Amount)
{
MessageBox.Show("No much pets", "Confirm", MessageBoxButton.OK);
return;
}
if (matchedPet != null && PetAmount <= 0)
{
MessageBox.Show("Cannot sale pet amount less than 0", "Confirm", MessageBoxButton.OK);
return;
}
var dealRecord = new Deal
{
Amount = PetAmount,
CustomerId = SelectCustomer.Id,
PetId = SelectPet.Id,
DealData = DateTime.Now
};
db.Deals.InsertOnSubmit(dealRecord);
db.SubmitChanges();
}
ts.Complete();
}
CloseAction();
}
catch (TransactionAbortedException ex)
{
Console.WriteLine(@"TransactionAbortedException Message: {0}", ex.Message);
}
}
// On clicking the submit button of complaint.
protected void btnsubmit_Click(object sender, EventArgs e)
{
Utilities.clearAllPlaceHolders(viewComplaints);
using (DatabaseDataContext con = new DatabaseDataContext()) {
try {
#region checks
if (SessionManager.UserID == 0)
{
showError("You must be logged in to submit a complaint!");
clearAllViews();
return;
}
string EncodedResponse = Request.Form["g-Recaptcha-Response"];
bool IsCaptchaValid = (ReCaptcha.Validate(EncodedResponse) == "true" ? true : false);
if (!IsCaptchaValid)
{
showError("Prove that you are not a robot!", 0);
return;
}
if (string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrEmpty(txtdescription.Text))
{
showError("Fill in all text boxes!");
return;
}
#endregion
tblComplaint complaint = new tblComplaint()
{
ComplaintDate = DateTime.Now,
ComplaintTitle = txtTitle.Text,
ComplaintDescription = txtdescription.Text,
CategoryID = Convert.ToInt32(ddlcategory.SelectedValue),
UserID = SessionManager.UserID,
ComplaintStatus = "Unresolved",
IsSeen = false
};
con.tblComplaints.InsertOnSubmit(complaint);
con.SubmitChanges();
showSuccess("Complaint submitted! Your complaint ID is: <b>" + complaint.ComplaintID + "</b>");
clearAllViews();
NotificationManager.complaintSent();
} catch (Exception ex) {
showError("Error: " + ex);
clearAllViews();
}
}
}
GetProducts(object oid)
{
int id = (int)oid;
DatabaseDataContext db = new DatabaseDataContext();
System.Collections.Generic.IEnumerable <Product> retval = null;
retval = db.Products.Where(x => x.CategoryId == id);
return(retval);
}
public Mobile(DatabaseDataContext db, Int32 id)
{
try
{
var mob = from m in db.mobiles where m.id == id select m;
}
catch (Exception e)
{
}
}
static void DoArchiveHtml()
{
var db = new DatabaseDataContext();
var precincts = db.Precincts.ToList().Where(x => currentPrecincts.Contains(x.UrlName));
foreach (var precinct in precincts)
{
precinct.GetArchiveFromArchiveHtml();
}
}
protected string getwireup()
{
string wireup;
int id = Convert.ToInt32(Request.QueryString["id"]);
DatabaseDataContext db = new DatabaseDataContext();
wireup = db.Products.Single(x => x.ProductId == id).Writeup.ToString();
return(wireup);
}
protected override void Render(HtmlTextWriter writer)
{
if (PageId > 0)
{
DatabaseDataContext db = new DatabaseDataContext();
this.Text = db.ContentPages.Single(x => x.PageId == PageId).Body;
}
base.Render(writer);
}
public NhanVien GetUserByMaNVNonHash(string sMaNV, string sPassword)
{
NhanVien objnhanvien = new NhanVien();
using (DatabaseDataContext db = new DatabaseDataContext())
{
objnhanvien = db.NhanViens.SingleOrDefault(p => p.MaNV == sMaNV & p.Password == sPassword & p.IsLock == false);
return(objnhanvien);
}
}
static void DoRecentEmptyReports()
{
var db = new DatabaseDataContext();
var precincts = db.Precincts.ToList().Where(x => currentPrecincts.Contains(x.UrlName));
foreach (var precinct in precincts)
{
precinct.GetArchiveFromRecentDBReports();
}
}
protected void btnStudentRemove_Click(object sender, EventArgs e)
{
int hash = sender.GetHashCode();
for (int i = 0; i < studentListRepeater.Items.Count; i++)
{
LinkButton button = (LinkButton)studentListRepeater.Items[i].FindControl("btnStudentRemove");
if (button.GetHashCode() == hash)
{
TableCell tc = (TableCell)studentListRepeater.Items[i].FindControl("tcUserEmail");
string userEmail = tc.Text;
using (DatabaseDataContext db = new DatabaseDataContext())
{
int userID = db.tblUsers.Where(x => x.userEmail.Equals(userEmail)).FirstOrDefault().userID;
int studentID = db.tblUsers.Join(
db.tblStudents,
x => x.userID,
y => y.userID,
(x, y) => new { tblUser = x, tblStudent = y }).Where(
x => x.tblUser.userID == userID).FirstOrDefault().tblStudent.studentID;
tblStudentSubject studentSubject = db.tblStudentSubjects.Where(x => x.studentID == studentID && x.teacherID == SessionManager.TeacherID).FirstOrDefault();
studentSubject.teacherID = null;
studentSubject.isVisible = false;
db.SubmitChanges();
var list = db.tblUsers.Join(
db.tblStudents,
x => x.userID,
y => y.userID,
(x, y) => new { tblUser = x, tblStudent = y }).Join(
db.tblStudentSubjects,
y => y.tblStudent.studentID,
z => z.studentID,
(y, z) => new { tblStudent = y, tblStudentSubject = z }).Where(
x => x.tblStudentSubject.teacherID == SessionManager.TeacherID &&
x.tblStudentSubject.isVisible && x.tblStudentSubject.teacherID != null).Select(s => new
{
s.tblStudent.tblStudent.studentFullName,
s.tblStudent.tblUser.userEmail,
s.tblStudentSubject.joiningDate
});
ControlManager.populateControl(list, studentListRepeater);
NotificationManager.removeStudentNotification(userID);
}
break;
}
}
}
public string InsertInvoice(string invoice_status, long customer_id, string address, long forwarder_to_id, long salesman_id, string po_no, long term_id, string ref_no, string ref_no_serial, DateTime created_date, DateTime delivery_date, string prepared_by, string checked_by, string delivered_by, string way_bill_no, string container_no, string bill_of_landing, decimal commission_rate, decimal commission_amt, long remarks_id, string notes, decimal sub_total_amt, decimal tax_amt, decimal total_amount, decimal shipping_amt, decimal payment_amt, decimal memo_amt, decimal adjustment_amt, string balance, long bank_name, string check_number, DateTime checkDate, string checkt, decimal checkAmount, long checkID)
{
try
{
long?id = 0;
if (sub_total_amt != 0)
{
Database = new DatabaseDataContext();
//Database._InvoiceInsert(ref id, invoice_status, customer_id, address, forwarder_to_id, salesman_id, po_no, term_id, ref_no, ref_no_serial, created_date, delivery_date, prepared_by, checked_by, delivered_by, way_bill_no, container_no, bill_of_landing, commission_rate, commission_amt, remarks_id, notes, sub_total_amt, tax_amt, "OpeningBalance", total_amount);
var data = Database._SalesSettings.SingleOrDefault(x => x.ID == long.Parse(ref_no));
if (data.Automatic.Value)
{
Database._SalesSettingRefUpdate(data.ID, data.LatestNo.Value + 1);
}
if (balance != string.Empty && balance != "" && balance != " ")
{
decimal totalPaid = sub_total_amt - decimal.Parse(balance);
long?refID = 0;
long?refID2 = 0;
Database = new DatabaseDataContext();
Database._InvoicePaymentReferenceInsert(ref refID, id, 3, "0", totalPaid, false);
//Database._InvoicePaymentInsert(ref refID2, id, refID, totalPaid);
var data2 = Database._Settings.SingleOrDefault(x => x.ID == 3);
if (data2.Automatic.Value)
{
Database._SettingRefUpdate(data.ID, data.LatestNo.Value + 1);
}
}
}
#region Save Payment
if (checkID == 0)
{
if (checkAmount != 0)
{
long?checkrefID = 0;
Database._OpeningBalanceCustomerCheckInsert(ref checkrefID, customer_id, bank_name, check_number, checkDate, checkt, checkAmount);
}
}
else
{
Database._OpeningBalanceCustomerCheckUpdate(checkID, bank_name, check_number, checkDate, checkt, checkAmount);
}
#endregion
return(id.ToString());
}
catch (Exception)
{
return("0");
}
}
public NhanVien GetUserByMaNV(string sMaNV, string sPassword)
{
NhanVien objnhanvien = new NhanVien();
using (DatabaseDataContext db = new DatabaseDataContext())
{
var query = db.NhanViens.ToList();
objnhanvien = db.NhanViens.SingleOrDefault(p => p.MaNV == sMaNV & p.Password == HashPassword(sPassword));
return(objnhanvien);
}
}
public static List <User> GetByTeam(DatabaseDataContext context, int teamid)
{
try
{
return(context.Users.Where(x => x.TeamID == teamid).ToList());
}
catch (Exception)
{
return(new List <User>());
}
}
private void DeleteData(long userID)
{
var ans = MessageBox.Show("Are you sure you want to delete this record", Helper.MessageBoxHeader, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (ans == System.Windows.Forms.DialogResult.Yes)
{
Database = new DatabaseDataContext();
Database.UsersDelete(userID);
LoadData();
}
}
public static List <User> GetAll(DatabaseDataContext context)
{
try
{
return(context.Users.ToList());
}
catch (Exception)
{
return(new List <User>());
}
}
public static void GetArchiveFromRecentDBReports(this Precinct precinct)
{
var db = new DatabaseDataContext();
var relevantreports = db.Reports.Where(r => r.PrecinctId == precinct.PrecinctId &&
r.ReportDate.Value > precinct.Cutoff.Value.Date &&
r.ReportDate.Value <= DateTime.Now.Date && !r.Events.Any()
&& r.ReportDate.Value > DateTime.Now.AddMonths(-1))
.AsParallel();
// parse events from reports in parallel
ExtractAndInsert(relevantreports, db);
}
// Gets the number of unread notifications by a user
public static string unseenNotificationCountAdmin()
{
using (DatabaseDataContext db = new DatabaseDataContext())
{
//int count = db.tblNotifications.Where(x => x.UserID == SessionManager.UserID && x.IsSeen == false).ToList().Count;
int count = db.tblNotifications.Where(x => !x.UserID.HasValue && x.IsSeen == false).ToList().Count;
return(count.ToString());
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
Category tmpitem = new Category();
tmpitem.categoryName = txtInputName.Text;
db.Categories.InsertOnSubmit(tmpitem);
db.SubmitChanges();
Response.Redirect(Util.UrlRewriting.encodeUrl("createCategory.aspx"));
}
public bool UpdateSalesReturn(long id, long customer_id, string address, long delivery_to_id, long salesman_id, string po_no, long term_id, string ref_no, string ref_no_serial, DateTime created_date, string notes, decimal total_amount, decimal apply_to_invoice_amount, decimal balance, string productList, string salesInvoice)
{
try
{
Database = new DatabaseDataContext();
Database._SalesReturnUpdate(id, customer_id, address, delivery_to_id, salesman_id, po_no, term_id, ref_no, ref_no_serial, created_date, notes, total_amount, "Posted");
Database._SalesReturnDetailsDeletebyReturn(id);
string[] lines = productList.Split('^');
foreach (var l in lines)
{
if (!string.IsNullOrEmpty(l))
{
string[] p = l.Split(',');
string productCode = p[0];
string locationCode = p[1];
var product = Database._Products.SingleOrDefault(x => x.ProductName == productCode);
var location = Database._Locations.SingleOrDefault(x => x.LocationName == locationCode);
decimal qty = decimal.Parse(p[2]);
decimal price = decimal.Parse(p[4]);
string discount = p[5];
decimal amount = decimal.Parse(p[6]);
long?refID = 0;
Database._SalesReturnDetailsInsert(ref refID, id, product.ID, location.ID, qty, product.UnitID, price, discount, amount);
}
}
#region Apply to Invoice
string[] lines2 = salesInvoice.Split('^');
foreach (var l in lines2)
{
if (!string.IsNullOrEmpty(l))
{
string[] p = l.Split(',');
Database._InvoiceReturnUpdate(long.Parse(p[1]), decimal.Parse(p[0]));
}
}
#endregion
return(true);
}
catch (Exception)
{
}
return(false);
}
public bool InsertSalesOrder(long customer_id, string address, long delivery_to_id, long salesman_id, string po_no, long term_id, string ref_no, string ref_no_serial, DateTime created_date, string cancel_date, string notes, decimal total_amount, decimal total_served, decimal balance, string productList, string orderStatus)
{
try
{
long?id = 0;
Database = new DatabaseDataContext();
DateTime?_cancel_date = null;
if (cancel_date.Trim() != string.Empty)
{
_cancel_date = DateTime.Parse(cancel_date);
}
Database._SalesOrderInsert(ref id, customer_id, address, delivery_to_id, salesman_id, po_no, term_id, ref_no, ref_no_serial, created_date, _cancel_date, notes, total_amount, total_served, balance, orderStatus);
//var data = Database._Settings.SingleOrDefault(x => x.ID == 2);
//if (data.Automatic.Value)
//{
// Database._SettingRefNoUpdate(data.ID, data.LatestNo.Value + 1);
//}
string[] lines = productList.Split('^');
foreach (var l in lines)
{
if (!string.IsNullOrEmpty(l))
{
string[] p = l.Split(',');
string productID = p[2];
string locationID = p[4];
var product = Database._Products.SingleOrDefault(x => x.ID == long.Parse(productID));
var location = Database._Locations.SingleOrDefault(x => x.ID == long.Parse(locationID));
decimal qty = decimal.Parse(p[5]);
decimal served = decimal.Parse(p[6]);
decimal price = decimal.Parse(p[8]);
string discount = p[9];
decimal amount = decimal.Parse(p[10]);
long?refID = 0;
Database._SalesOrderDetailsInsert(ref refID, id, product.ID, location.ID, qty, served, product.UnitID, price, discount, amount);
}
}
return(true);
}
catch (Exception)
{
}
return(false);
}
//public static User GetByID(DatabaseDataContext context, object id)
//{
// try
// {
// var context = new DatabaseDataContext();
// return context.Users.Single(x => x.UserName.Equals(id.ToString()));
// }
// catch (Exception)
// {
// return null;
// }
//}
public static User GetByID(DatabaseDataContext context, object id)
{
try
{
return(context.Users.Single(x => x.UserName.Equals(id.ToString())));
}
catch (Exception)
{
return(null);
}
}
public static void LogEvent(string category, string message)
{
DatabaseDataContext db = new DatabaseDataContext();
Information e = new Information();
e.Message = "[" + category + "] " + message;
e.CreatedDate = DateTime.UtcNow;
db.Informations.InsertOnSubmit(e);
db.SubmitChanges();
}
private void btnAddSupplier_Click(object sender, EventArgs e)
{
frmSupplierManage manage = new frmSupplierManage(0);
manage.StartPosition = FormStartPosition.CenterParent;
manage.ShowDialog();
Database = new DatabaseDataContext();
cmbSupplier.DataSource = Database.Suppliers.ToList <Supplier>();
cmbSupplier.ValueMember = "ID";
cmbSupplier.DisplayMember = "Name";
}
public ViewModeSaleDialogView(Pet pet)
{
CancelCommand = new DelegateCommand(CloseWindow);
SaleCommand = new DelegateCommand(SalePet);
PetName = pet.PetName;
SelectPet = pet;
using (DatabaseDataContext db =
new DatabaseDataContext(@"Server=10.30.169.46;Database=PetShop;User Id=sunny;Password=~123qwerty;"))
{
CustomerList = new ObservableCollection <Customer>((from cus in db.Customers where cus.CusStatus == StatusType.None select cus).ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
mvSubjects.ActiveViewIndex = 0;
}
using (DatabaseDataContext db = new DatabaseDataContext())
{
var list = db.tblSubjects.Where(x => x.isVisible).SortBy("subjectTitle").ToList();
ControlManager.populateControl(list, subjectsCatalogRepeater);
tblUser user = (tblUser)Session["User"];
var studentSubjects = db.tblStudentSubjects.Where(x => x.studentID == SessionManager.StudentID).ToList();
for (int i = 0; i < subjectsCatalogRepeater.Items.Count; i++)
{
Label label = (Label)subjectsCatalogRepeater.Items[i].FindControl("lblSubjectCode");
if (studentSubjects.Where(x => x.subjectCode == Convert.ToInt32(label.Text) && x.isVisible).FirstOrDefault() == null)
{
MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter");
mv.ActiveViewIndex = 1;
}
else
{
MultiView mv = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelFooter");
Button button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnChangeTeacher");
if (studentSubjects.Where(x => x.subjectCode == Convert.ToInt32(label.Text) && x.isVisible && x.studentID == SessionManager.StudentID && x.teacherID != null).FirstOrDefault() == null)
{
button = (Button)subjectsCatalogRepeater.Items[i].FindControl("btnChangeTeacher");
button.Text = "Choose teacher";
button.CssClass += "btn btn-info";
}
else
{
button.CssClass += "btn btn-orange";
}
mv.ActiveViewIndex = 0;
}
MultiView mvBody = (MultiView)subjectsCatalogRepeater.Items[i].FindControl("mvPanelBody");
mvBody.ActiveViewIndex = 0;
}
}
}
protected void btnPharmacyCommercialAdd_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
PharmacyCommercial newItem = new PharmacyCommercial();
newItem.chemicalName = chemicalName;
newItem.company = txtPharmacyCompany.Text;
newItem.morph = txtPharmacyMorph.Text;
newItem.name = txtPharmacyName.Text;
db.PharmacyCommercials.InsertOnSubmit(newItem);
db.SubmitChanges();
Response.Redirect(Util.UrlRewriting.encodeUrl("updatePharmacy.aspx?chemicalName=" + chemicalName ));
}
public static List <JobTitle> GetAll()
{
try
{
var context = new DatabaseDataContext();
return(context.JobTitles.ToList());
}
catch (Exception)
{
return(new List <JobTitle>());
}
}
private void BindData()
{
// connect to database
DatabaseDataContext db = new DatabaseDataContext();
// bind schedules to display
this.grdResults.DataSource = db.Informations.Where(z => z.ScheduleID == new Guid(Request.QueryString["id"])).OrderByDescending(z => z.CreatedDate);
this.grdResults.DataBind();
// close connection
db.Dispose();
}
public static List <Major> GetAll()
{
try
{
var context = new DatabaseDataContext();
return(context.Majors.OrderByDescending(x => x.ID).ToList());
}
catch (Exception)
{
return(new List <Major>());
}
}
private void BindData()
{
// connect to database
DatabaseDataContext db = new DatabaseDataContext();
// bind schedules to display
this.grdResults.DataSource = db.Schedules.Where(z => z.AccountID == (Session["CurrentAccount"] as Common.Account).ID).OrderBy(z => z.Name);
this.grdResults.DataBind();
// close connection
db.Dispose();
}
private void btnVoid_Click(object sender, EventArgs e)
{
if (grv.SelectedRows.Count != 0)
{
frmVoidQty manage = new frmVoidQty(decimal.Parse(grv.CurrentRow.Cells[2].Value.ToString()));
manage.StartPosition = FormStartPosition.CenterParent;
manage.ShowDialog();
if (manage.Confirm)
{
Database = new DatabaseDataContext();
long detail_id = long.Parse(grv.CurrentRow.Cells[0].Value.ToString());
var pro = Database.Products.SingleOrDefault(x => x.Code == grv.CurrentRow.Cells[1].Value.ToString());
decimal return_void_qty = decimal.Parse(manage.txtQty.Text);
decimal current_qty = decimal.Parse(grv.CurrentRow.Cells[2].Value.ToString());
//ibabalik sa stock yung qty and product ID
Database.ProductStockInVOID(pro.ID, return_void_qty, Helper.FULLNAME, txtCustomer.Text);
if (return_void_qty == current_qty)//delete
{
Database.SaleDetails.DeleteOnSubmit(Database.SaleDetails.SingleOrDefault(x => x.ID == detail_id));
Database.SubmitChanges();
}
else//update
{
var detail_update = Database.SaleDetails.SingleOrDefault(x => x.ID == detail_id);
detail_update.Qty = detail_update.Qty - return_void_qty;
Database.SubmitChanges();
}
//remove or update on the sale detail
foreach (DataGridViewRow item in this.grv.SelectedRows)
{
DataGridViewRow row = this.grv.SelectedRows[0];
TotalNet -= decimal.Parse(row.Cells[5].Value.ToString());
txtTotalNet.Text = TotalNet.ToString("N");
TotalGross -= decimal.Parse(row.Cells[6].Value.ToString());
txtTotalGross.Text = TotalGross.ToString("N");
//
grv.Rows.RemoveAt(item.Index);
}
//-----update grid
Database = new DatabaseDataContext();
var grid_update = Database.SaleDetails.SingleOrDefault(x => x.ID == detail_id);
var net = (grid_update.Qty.Value * grid_update.Price.Value);
var gross = net - (grid_update.Qty.Value * pro.Cost.Value);
grv.Rows.Add(detail_id, pro.Code, (grid_update.Qty.Value).ToString("N"), grid_update.Price.Value.ToString("N"), pro.Cost.Value.ToString("N"), net.ToString("N"), gross.ToString("N"));
}
}
}
public string SaveInvoicePaymentVoucher(long invoiceid, string refNo, decimal amount, string checkTable, decimal totalAmount, string salesInvoice)
{
try
{
long?refID = 0;
long?refID2 = 0;
Database = new DatabaseDataContext();
Database._PurchasedPaymentReferenceInsert(ref refID, invoiceid, refNo, totalAmount, true);
#region Apply to Invoice
//string[] lines2 = salesInvoice.Split('^');
//foreach (var l in lines2)
//{
// if (!string.IsNullOrEmpty(l))
// {
// string[] p = l.Split(',');
// Database._PurchasedPaymentInsert(ref refID2, long.Parse(p[1]), refID, long.Parse(p[0]));
// }
//}
#endregion
#region Cash Payment
if (amount != 0 && amount != null)
{
long?idcash = 0;
Database = new DatabaseDataContext();
//Database._PurchasedPaymentCashInsert(ref idcash, refID, amount);
}
#endregion
#region Check Payment
//string[] lines = checkTable.Split('^');
//foreach (var l in lines)
//{
// if (!string.IsNullOrEmpty(l))
// {
// string[] p = l.Split(',');
// long? idcheck = 0;
// Database = new DatabaseDataContext();
// Database._PurchasedPaymentCheckInsert(ref idcheck, p[0], p[1], DateTime.Parse(p[2]), p[3], decimal.Parse(p[4]), refID);
// }
//}
#endregion
return("");
}
catch (Exception)
{
}
return("");
}
public string SaveInvoicePayment(long invoiceid, string refNo, decimal amount, string checkTable, long cardID, string cardNumber, string nameCard, string expMonth, string expYear, string AppCode, decimal amountCard, decimal totalAmount)
{
try
{
long?refID = 0;
long?refID2 = 0;
Database = new DatabaseDataContext();
Database._InvoicePaymentReferenceInsert(ref refID, invoiceid, 3, refNo, totalAmount, true);
//Database._InvoicePaymentInsert(ref refID2, invoiceid, refID, totalAmount);
var data = Database._Settings.SingleOrDefault(x => x.ID == 3);
if (data.Automatic.Value)
{
Database._SettingRefUpdate(data.ID, data.LatestNo.Value + 1);
}
#region Cash Payment
if (amount != 0 && amount != null)
{
long?idcash = 0;
Database = new DatabaseDataContext();
Database._InvoicePaymentCashInsert(ref idcash, refID, amount, DateTime.Now);
}
#endregion
#region Check Payment
string[] lines = checkTable.Split('^');
foreach (var l in lines)
{
if (!string.IsNullOrEmpty(l))
{
string[] p = l.Split(',');
long?idcheck = 0;
Database = new DatabaseDataContext();
//Database._InvoicePaymentCheckInsert(ref idcheck, refID, p[0], p[1], DateTime.Parse(p[2]), p[3], decimal.Parse(p[4]));
}
}
#endregion
#region Card Payment
if (cardID != 0 && cardID != null)
{
long?idcard = 0;
Database = new DatabaseDataContext();
//Database._InvoicePaymentCardInsert(ref idcard, refID, cardID, cardNumber, nameCard, expMonth, expYear, AppCode, amountCard, DateTime.Now);
}
#endregion
return("");
}
catch (Exception)
{
}
return("");
}
public Report GetReport(string url, DateTime reportDate, string titlestring)
{
var db = new DatabaseDataContext();
var report = db.Reports.SingleOrDefault(_ =>
_.Uri == url);
if (report == null)
{
report = new Report();
report.CreatedAt = DateTime.Now;
report.Uri = url;
report.PrecinctId = _precinct.PrecinctId;
// evil
report.Html = "";
db.Reports.InsertOnSubmit(report);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine("Something wrong {0}", report.Uri);
return null;
}
}
if (string.IsNullOrEmpty(report.Html))
{
Console.WriteLine("retrieving {0}", url);
report.Html = Doc.GetHtml("http://politi.dk" + url);
}
if (report.ReportDate == null)
{
var parser = ParserFactory.GetParser(report);
report.ReportDate = parser.GetReportDate(titlestring, reportDate);
}
try
{
db.SubmitChanges();
}
catch (Exception e)
{
return report; // due to retarded date
}
return report;
}
public void ExamineEmptyReports()
{
var db = new DatabaseDataContext();
var reports = (from r in db.Reports
where
r.PrecinctId == _precinct.PrecinctId &&
!r.Events.Any() &&
r.ReportDate.Value.Date > _precinct.Cutoff.Value.Date &&
r.ReportDate.Value.Date <= DateTime.Now.Date
select r).ToList();
var events = reports.SelectMany(_ => ParserFactory.GetParser(_).GetEvents());
db.Events.InsertAllOnSubmit(events);
db.SubmitChanges();
}
public JsonResult EventData(int eventid)
{
var db = new DatabaseDataContext();
var e = db.Events.Single(_ => _.EventId == eventid);
return this.Json(new
{
text = e.BodyText,
city = e.PlaceString,
date = e.IncidentTime.Value.ToString("d. MMMM kl. HH:mm", CultureInfo.GetCultureInfo("da-DK")),
street = e.Street ?? "",
title = e.Title,
displayid = ViewUtil.ToBase26(e.EventId),
url = string.Format("/haendelse/{0}/{1}", e.Title.ToUrlFriendly(), e.EventId)
});
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
PharmacyChemical tmpitem = new PharmacyChemical();
tmpitem.chemicalName = txtInputChemicalName.Text;
tmpitem.subCategoryName = (from sub in db.SubCategories
where sub.subCategoryName == txtInputSubCategory.SelectedItem.Text
select sub.subCategoryName).First();
db.PharmacyChemicals.InsertOnSubmit(tmpitem);
db.SubmitChanges();
Response.Redirect(Util.UrlRewriting.encodeUrl("updatePharmacy.aspx?chemicalName=" + tmpitem.chemicalName));
}
private static void ExtractAndInsert(IEnumerable<Report> reports, DatabaseDataContext db)
{
var eventsBatches = from r in reports
let parser = ParserFactory.GetParser(r)
where parser != null
select parser.GetEvents();
foreach (var batch in eventsBatches)
{
foreach (var @event in batch)
{
@event.CreatedAt = DateTime.Now;
}
db.Events.InsertAllOnSubmit(batch);
db.SubmitChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
parsePharmacyArguments();
if (!IsPostBack)
{
parseGeneralArguments();
menu.InnerHtml += Util.Menu.createAdminMenu(Request.Url.LocalPath);
footerMenu.InnerHtml += Util.Menu.createFooterMenu();
Util.Style.setGrindviewStyle(ref grdPharmacyChemical);
DatabaseDataContext db = new DatabaseDataContext();
loadCategories(db);
}
loadChemicalPharmacies();
}
protected void Button_Bereich_Löschen_Click(object sender, EventArgs e)
{
DatabaseDataContext d = new DatabaseDataContext();
var ber = from b in d.Bereich
where b.Name == ListBox_B.SelectedValue && b.Id == bereich_nr
select b;
var tei = from t in d.Teil
where t.Id_Bereich == ber.First().Id
select t;
d.Teil.DeleteAllOnSubmit(tei);
d.Bereich.DeleteAllOnSubmit(ber);
d.SubmitChanges();
GridView_Kran_SelectedIndexChanged(sender, e);
}
protected void deleteInteractionPharmacyPharmacy(String name1, String name2)
{
DatabaseDataContext db = new DatabaseDataContext();
var query = (from inter in db.InteractionPharmacyPharmacies
where (inter.pharmacyname1 == name1 && inter.pharmacyname2 == name2)
select inter);
if (query.Count() < 1)
{
query = (from inter in db.InteractionPharmacyPharmacies
where (inter.pharmacyname1 == name2 && inter.pharmacyname2 == name1)
select inter);
}
if (query.Count() > 0)
{
InteractionPharmacyPharmacy tmpItem = query.First();
db.InteractionPharmacyPharmacies.DeleteOnSubmit(tmpItem);
db.SubmitChanges();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
PharmacyChemical tmpItem;
PharmacyChemical OriginalItem;
tmpItem = (from phar in db.PharmacyChemicals
where phar.chemicalName == chemicalName
select phar).FirstOrDefault();
OriginalItem = (from phar in db.PharmacyChemicals
where phar.chemicalName == chemicalName
select phar).FirstOrDefault();
tmpItem.indication = txtInputIndicia.Text;
tmpItem.contraIndication = txtInputNonIndicia.Text;
tmpItem.dose = txtInputDoce.Text;
tmpItem.greekName = txtGreekname.Text;
tmpItem.interactionGeneral = txtInteractions.Text;
tmpItem.undesirableReactions = txtUndesirableReactions.Text;
// db.PharmacyChemicals.Attach(tmpItem, OriginalItem);
db.SubmitChanges();
}
public ActionResult Index()
{
var db = new DatabaseDataContext();
var mostrecentevent = db.Events.
Where(e => e.IncidentTime <= DateTime.Now && e.Lat != null).
Select(e => e.IncidentTime).
OrderByDescending(d => d).First().Value;
var earliestevent = db.Events.
Where(e => e.IncidentTime <= DateTime.Now && e.Lat != null).
Select(e => e.IncidentTime).
OrderBy(d => d).First().Value;
ViewData["Earliest"] = earliestevent.Year < 2008 ? new DateTime(2008,1,1) : earliestevent;
ViewData["MostRecent"] = mostrecentevent;
ViewData["Categories"] = (new CategoryRepository()).GetCategories();
return View();
}
static void Main(string[] args)
{
while (true)
{
try
{
var db = new DatabaseDataContext();
if(db.Events.Any(x => x.CreatedAt > DateTime.Now.AddDays(-1)))
{
Thread.Sleep(1000 * 60 * 60 * 24);
continue;
}
DoArchiveHtml();
var categorizer = new Categorizer();
categorizer.Categorize();
var geocoder = new EventGeocoder();
try
{
geocoder.GeoCodeEvents();
}
catch (GoogleIsSulkingException)
{
}
}
catch (Exception exception)
{
using (var smtpClient = new SmtpClient())
{
var emailAddress = ConfigurationManager.AppSettings.Get("logemailaddress");
smtpClient.Send(new MailMessage(
emailAddress, emailAddress, "Problem scraping", exception.ToString()));
}
}
Thread.Sleep(1000 * 60 * 60 * 24);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
if (InterChemicalName2 != "")
{
InteractionPharmacyPharmacy tmpItem = new InteractionPharmacyPharmacy();
tmpItem.pharmacyname1 = InterChemicalName;
tmpItem.pharmacyname2 = InterChemicalName2;
tmpItem.comment = txtInterComment.Text;
db.InteractionPharmacyPharmacies.InsertOnSubmit(tmpItem);
}
else if (InterSubCategoryName != null)
{
InteractionPharmacySubCategory tmpItem = new InteractionPharmacySubCategory();
tmpItem.chemicalName = InterChemicalName;
tmpItem.subCategoryName = InterSubCategoryName;
tmpItem.comment = txtInterComment.Text;
db.InteractionPharmacySubCategories.InsertOnSubmit(tmpItem);
}
db.SubmitChanges();
Response.Redirect(Util.UrlRewriting.encodeUrl("updateInteraction.aspx?chemicalName="+InterChemicalName));
}
public List<Agency> GetAgencies(string key)
{
this.ValidateKey(key);
DatabaseDataContext db = new DatabaseDataContext();
List<Agency> result = new List<Agency>();
foreach (var r in db.GTFS_Agencies.OrderBy(a => a.Name))
{
Agency a = new Agency();
a.AgencyID = r.ID;
a.Name = r.Name;
a.State = r.State;
a.TimeZone = r.TimeZone;
result.Add(a);
}
WebOperationContext.Current.OutgoingResponse.Headers.Add("Access-Control-Allow-Origin", "*");
return result;
}
public ActionResult GetPOIs(string lat, string lon,
string requestedPoiId, string pageKey)
{
var db = new DatabaseDataContext();
int? page = null;
if (!string.IsNullOrEmpty(pageKey))
{
page = int.Parse(pageKey);
}
var eventssp = db.FindNearestEvents(
float.Parse(lat, NumberStyles.Float, CultureInfo.InvariantCulture),
float.Parse(lon, NumberStyles.Float, CultureInfo.InvariantCulture),
20, page ?? 0);
var events = eventssp.Select(e => new POI()
{
lat = e.Lat.Value.ToLayarCoord(),
lon = e.Lng.Value.ToLayarCoord(),
distance = e.Distance.Value,
id = e.EventId,
title =
e.Title + " (" + e.IncidentTime.Value.ToString("d. MMMM yyyy kl. HH:mm") + ")",
line2 = e.BodyText,
attribution = "Ekstra Bladet Krimikort"
}).ToList();
return this.Json(
new Response
{
radius = (int)(events.Max(e => e.distance) * 1000),
nextPageKey = page != null ? page + 1 : 1,
morePages = events.Count() == 20,
hotspots = events,
}, JsonRequestBehavior.AllowGet
);
}
protected void Page_Load(object sender, EventArgs e)
{
DatabaseDataContext db = new DatabaseDataContext();
StringBuilder output = new StringBuilder();
foreach (Information i in db.Informations.OrderByDescending(z => z.CreatedDate).Take(1000))
{
if (i.Message.ToLower().Contains("exception"))
output.AppendLine("<br /><span style='color: red;'>");
else if (i.Message.ToLower().Contains("complete"))
output.AppendLine("<br /><span style='color: green;'>");
output.AppendLine(i.Message.Replace("[BackgroundWorker]", "[" + i.CreatedDate.ToString("MM/dd/yyyy H:mm:ss") + "]") + "<br />");
if (i.Message.ToLower().Contains("exception"))
output.AppendLine("</span><br />");
else if (i.Message.ToLower().Contains("complete"))
output.AppendLine("</span>");
}
this.txtInformation.Text = output.ToString();
}
protected void deleteCategory(String name)
{
//Delete SubCategories
DatabaseDataContext db = new DatabaseDataContext();
var query = (from cat in db.SubCategories
where (cat.categoryName== name)
select cat);
foreach (SubCategory tmpItem in query)
{
deleteSubCategory(tmpItem.subCategoryName);
db.SubmitChanges();
}
//Delete SubCategory
var query1 = (from cat in db.Categories
where cat.categoryName == name
select cat);
if (query1.Count() > 0)
{
Category tmpItem1 = query1.First();
db.Categories.DeleteOnSubmit(tmpItem1);
db.SubmitChanges();
}
}
