private static EcardType[] Fetch(int? id, int? categoryId, string name, eType? type, bool? active, eSortColumn sortColumn) { using (SqlConnection conn = Config.DB.Open()) { SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader("FetchEcardTypes", id, categoryId, name, (int?)type, active, sortColumn); var lEcardType = new List<EcardType>(); while (reader.Read()) { try { var ecardType = new EcardType { id = (int) reader["ID"], categoryId = (int) reader["CategoryID"], name = (string) reader["Name"], phrase = (string) reader["Phrase"], type = (eType) reader["Type"], active = (bool) reader["Active"] }; lEcardType.Add(ecardType); } catch { } } return lEcardType.ToArray(); } }
public static Ecard[] FetchSent(string username, EcardType.eType type) { return FetchSent(username) .Where(x => EcardType.Fetch(x.EcardTypeID).Type == type).ToArray(); }
public static Ecard[] FetchUnread(string username, EcardType.eType type) { return FetchReceived(username, type).Where(x=> x.IsOpened==false).ToArray(); }
public static Ecard[] FetchSentInLast24Hours(string username, EcardType.eType type) { return FetchSent(username) .Where(x => x.Date > DateTime.Now.AddHours(-24) && EcardType.Fetch(x.EcardTypeID).Type == type) .ToArray(); }
protected void btnSave_Click(object sender, EventArgs e) { if (!HasWriteAccess) return; if (txtName.Text.Length == 0) { Messagebox1.Show(Lang.TransA("Please enter name"), Misc.MessageType.Error); return; } byte[] content = new byte[fuContent.PostedFile.InputStream.Length]; while (true) { int bytesRead = fuContent.PostedFile.InputStream.Read(content, 0, content.Length); if (bytesRead == 0) break; } string mimeType = String.Empty; string extension = System.IO.Path.GetExtension(fuContent.PostedFile.FileName).ToLower(); if (fuContent.PostedFile.FileName.Length > 0) { switch (extension) { case ".gif": mimeType = "image/gif"; break; case ".jpg": mimeType = "image/jpeg"; break; case ".jpeg": mimeType = "image/jpeg"; break; case ".jpe": mimeType = "image/jpeg"; break; case ".png": mimeType = "image/png"; break; case ".swf": mimeType = "application/x-shockwave-flash"; break; default: Messagebox1.Show(Lang.TransA("Invalid file format!"), Misc.MessageType.Error); return; } } EcardType ecardType = null; ecardType = EcardType.Fetch(Convert.ToInt32(ddName.SelectedValue)); if (ecardType == null) { ecardType = new EcardType(); } ecardType.Name = txtName.Text.Trim(); ecardType.Active = cbActive.Checked; if (content.Length > 0) ecardType.Content = content; else if (!ShowExistedEcardType) { Messagebox1.Show(Lang.TransA("Invalid file format!"), Misc.MessageType.Error); return; } if (mimeType.Length > 0) ecardType.Type = mimeType.Split('/')[0] == "image" ? EcardType.eType.Image : EcardType.eType.Flash; ecardType.Save(); tdImage.Visible = ecardType.Type == EcardType.eType.Image; tdFlash.Visible = !tdImage.Visible; populateDDName(); PopulateEcardCategoriesDdl(); ddName.SelectedValue = ecardType.ID.ToString(); Messagebox1.Show(Lang.TransA("The e-card has been modified successfully!"), Misc.MessageType.Success); }