internal void UpdateCustomText(CustomText customText)
{
string sql = @"UPDATE dbo.OfferCustomTexts
SET typ_prof=@typ_prof, text_order=@text_order, lang_ID=@lang_ID, report_key=@report_key, custom_text=@custom_text, is_header=@is_header, keep_together=@keep_together, pg_break=@pg_break, last_footer=@last_footer, once_key=@once_key, [optional]=@optional, opt_desc=@opt_desc
WHERE ID=@id";
using (SqlCommand cmd = GetCmd(sql))
{
AddCommonParameters(customText, cmd);
cmd.ExecuteNonQuery();
}
}
internal void DeleteCustomText(CustomText customText)
{
if (customText.ID == 0)
{
return;
}
using (SqlCommand cmd = GetCmd("DELETE FROM dbo.OfferCustomTexts WHERE ID=@id"))
{
cmd.AddParameterWithValue("@id", customText.ID);
cmd.ExecuteNonQuery();
}
}
private static void AddCommonParameters(CustomText customText, SqlCommand cmd)
{
cmd.AddParameterWithValue("@id", customText.ID);
cmd.AddParameterWithValue("@typ_prof", customText.typ_prof);
cmd.AddParameterWithValue("@text_order", customText.text_order);
cmd.AddParameterWithValue("@lang_ID", customText.lang_ID);
cmd.AddParameterWithValue("@report_key", customText.report_key);
cmd.AddParameterWithValue("@custom_text", customText.custom_text);
cmd.AddParameterWithValue("@is_header", customText.is_header);
cmd.AddParameterWithValue("@keep_together", customText.keep_together);
cmd.AddParameterWithValue("@pg_break", customText.pg_break);
cmd.AddParameterWithValue("@last_footer", customText.last_footer);
cmd.AddParameterWithValue("@once_key", customText.once_key);
cmd.AddParameterWithValue("@optional", customText.optional);
cmd.AddParameterWithValue("@opt_desc", customText.opt_desc);
}
internal void CreateCustomText(CustomText customText)
{
if (customText.ID == 0)
{
using (SqlCommand cmd = GetCmd("SELECT ISNULL(MAX(ID),0)+1 FROM dbo.OfferCustomTexts"))
{
customText.ID = (int)cmd.ExecuteScalar();
}
}
string sql = @"INSERT INTO dbo.OfferCustomTexts (id, typ_prof, text_order, lang_ID, report_key, custom_text, is_header, keep_together, pg_break, last_footer, once_key, [optional], opt_desc)
VALUES (@id, @typ_prof, @text_order, @lang_ID, @report_key, @custom_text, @is_header, @keep_together, @pg_break, @last_footer, @once_key, @optional, @opt_desc);";
using (SqlCommand cmd = GetCmd(sql))
{
AddCommonParameters(customText, cmd);
cmd.ExecuteNonQuery();
}
}
public CustomTextViewModel(CustomText model)
{
_model = model;
}