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); } }