public EditDateTemplate(Template template)
{
InitializeComponent();
temp = template;
dateTime.Value = template.SentTime;
// List<Template> templates = Database.getDatabase().getTemplates();
}
public EditTextTemplate( Template template)
{
InitializeComponent();
;
//List<Template> templates = Database.getDatabase().getTemplates();
richTextBox1.Text = template.Text;
temp = template;
}
public void AddSentTimesToTemplate(Template template)
{
int count = (template.PeriodType == 4) ? 12 : (template.PeriodType == 3) ? 6 : (template.PeriodType == 2) ? 3 : (template.PeriodType == 1) ? 1 : 0;
if (count != 0)
{
for (int i = 0; i < (24 / count); i++)
{
string query = "Insert into template_sent_time(template_id, sent_time) VALUES(" + template.id + ", '" + template.SentTime.AddMonths(count * (i + 1)).ToString("yyyy-MM-dd") + "')";
con.Insert(query);
}
}
else
{
string query = "Insert into template_sent_time(template_id, sent_time) VALUES(" + template.id + ", '" + template.SentTime.ToString("yyyy-MM-dd") + "')";
con.Insert(query);
}
}
private void btnCreateTemp_Click(object sender, EventArgs e)
{
string title = txtTitle.Text;
string text = txtText.Text;
string receivers = "";
DateTime senttime = dtsenttime.Value;
bool periodic = false;
bool isAutomatic = false;
bool error = false;
int type = 0;
if(YesToPeriodic.Checked){
periodic = true;
} else if(NoToPeriodic.Checked) {
periodic = false;
} else {
error = true;
}
if(YesToAutomatic.Checked){
isAutomatic = true;
} else if(NoToAutomatic.Checked) {
isAutomatic = false;
} else {
error = true;
}
if (periodic)
{
if (month1.Checked)
{
type = 1;
}
else if (month3.Checked)
{
type = 2;
}
else if (month6.Checked)
{
type = 3;
}
else if (year.Checked)
{
type = 4;
}
else
{
error = true;
}
}
else
type = 0;
if (string.IsNullOrEmpty(title) ||
string.IsNullOrEmpty(text) ||
error)
{
MessageBox.Show("خطا: تمام قسمت ها را پر کنید.");
}
else
{
_template = new Template(1,title, text, periodic, senttime, isAutomatic, type);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
Database.getDatabase().AddTemplate(_template,selected_groups, selected_receivers);
MessageBox.Show("قالب با موفقیت اضافه شد");
this.Close();
}
}
// Template related Functions
public List<Template> getTemplates()
{
string query;
query = "Select * from templates";
List<List <string> > l = con.Select(query);
List<Template> temps = new List<Template>();
for (int i = 0; i < l.Count; i++) {
Template newTemplate = new Template(Convert.ToInt32(l[i][0]), l[i][3], l[i][4], l[i][6] == "True", Convert.ToDateTime(l[i][5]), l[i][8] == "True", Convert.ToInt32(l[i][7]));
temps.Add(newTemplate);
}
return temps;
}
public void AddTemplate(Template template,List<ReceiverGroup> groups, List<Receiver> receivers)
{
templates.Add(template);
string query;
query = "Insert into templates (user_id, create_date, title, content, base_sent_time, is_periodic, period_type, is_automatic) VALUES ('" + current_user + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "' ,'" + template.Title + "','" + template.Text + "','" + template.SentTime.ToString("yyyy-MM-dd") + "'," + template.Periodic + "," + template.PeriodType + "," + template.IsAutomatic + ")";
con.Insert(query);
query = "select MAX(template_id) from templates";
int template_id = con.Count(query);
for (int i = 0; i < groups.Count; i++)
{
query = "Insert into template_group(template_id,group_id) VALUES(" + template_id.ToString() + "," + groups[i].id.ToString() + ")";
con.Insert(query);
}
for (int i = 0; i < receivers.Count; i++)
{
query = "Insert into template_receiver(template_id,receiver_id) VALUES(" + template_id.ToString() + "," + receivers[i].ID.ToString() + ")";
con.Insert(query);
}
//if template.Periodic
int count = (template.PeriodType == 4)?12:(template.PeriodType == 3)?6:(template.PeriodType == 2)?3:(template.PeriodType == 1)?1:0;
if (count != 0)
{
for (int i = 0; i < (24 / count); i++)
{
query = "Insert into template_sent_time(template_id, sent_time) VALUES(" + template_id.ToString() + ", '" + template.SentTime.AddMonths(count * (i + 1)).ToString("yyyy-MM-dd") + "')";
con.Insert(query);
}
}
else {
query = "Insert into template_sent_time(template_id, sent_time) VALUES(" + template_id.ToString() + ", '" + template.SentTime.ToString("yyyy-MM-dd") + "')";
con.Insert(query);
}
}
