private void ShowMailFormatTypeDescription()
{
int mailFormatTypeId = Int32.Parse(ddlTypes.SelectedValue);
MailFormatType mailFormatType = MailFormatService.GetMailFormatType(mailFormatTypeId);
txtDescription.Text = mailFormatType.Comment;
}
private void ShowMailFormatTypeDescription()
{
int mailFormatTypeId = Int32.Parse(ddlTypes.SelectedValue);
MailFormatType mailFormatType = MailFormatService.GetMailFormatType(mailFormatTypeId);
txtDescription.Text = mailFormatType.Comment;
Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resource.Admin_MailFormat_Header);
}
public static void UpdateMailFormatType(MailFormatType mailFormatType)
{
SQLDataAccess.ExecuteNonQuery("UPDATE [Settings].[MailFormatType] SET TypeName = @TypeName, SortOrder = @SortOrder, Comment = @Comment WHERE (MailFormatTypeID = @MailFormatTypeID)",
CommandType.Text,
new SqlParameter("@MailFormatTypeID", mailFormatType.MailFormatTypeID),
new SqlParameter("@TypeName", mailFormatType.TypeName),
new SqlParameter("@SortOrder", mailFormatType.SortOrder),
new SqlParameter("@Comment", mailFormatType.Comment)
);
}
public static void InsertMailFormatType(MailFormatType mailFormatType)
{
SQLDataAccess.ExecuteNonQuery("INSERT INTO [Settings].[MailFormatType] (TypeName, SortOrder, Comment) VALUES (@TypeName, @SortOrder, @Comment); SELECT SCOPE_IDENTITY()",
CommandType.Text,
new SqlParameter("@TypeName", mailFormatType.TypeName),
new SqlParameter("@SortOrder", mailFormatType.SortOrder),
new SqlParameter("@Comment", mailFormatType.Comment));
}
