private static EcardType[] Fetch(int? id, string name, eType? type, bool? active, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchEcardTypes",
id,
name,
type,
active,
sortColumn);
List<EcardType> lEcardType = new List<EcardType>();
while (reader.Read())
{
EcardType ecardType = new EcardType();
ecardType.id = (int)reader["ID"];
ecardType.name = (string) reader["Name"];
ecardType.type = (eType) reader["Type"];
ecardType.active = (bool) reader["Active"];
ecardType.CreditsRequired = reader["CreditsRequired"] as int?;
lEcardType.Add(ecardType);
}
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);
}