private void setModelToFilels(AutomaticOrderingModel modl)
{
VendorId_Name_combo.Text = modl.Vendor + "-----" + modl.VendorID;
EmailTextBox.Text = modl.Email;
PhoneTextboxTextBox.Text = modl.Phone;
MoncheckBox.Checked = modl.MON;
TuecheckBox.Checked = modl.TUE;
WedcheckBox.Checked = modl.WED;
ThucheckBox.Checked = modl.THU;
FRIcheckbox.Checked = modl.FRI;
SATcheckBox.Checked = modl.SAT;
SUNcheckBox.Checked = modl.SUN;
DOMcomboBox.Text = modl.DayOfMonth.ToString();
dateTimePicker1.Text = modl.OrderTime.ToString("HH:mm");
AutoOrderingcheckBox.Checked = modl.Auto_Ordering;
if (modl.Method.ToLower() == "dos")
{
DOSradioButton.Checked = true;
TargetradioButton.Checked = false;
}
else
{
DOSradioButton.Checked = false;
TargetradioButton.Checked = true;
}
}
private void DG2_TableControlCellDoubleClick(object sender, GridTableControlCellClickEventArgs e)
{
try
{
int row = e.Inner.RowIndex - 2;
AutomaticOrderingModel aom = new AutomaticOrderingModel()
{
Vendor = DG2.Table.Records[row].GetValue("Vendor").ToString(),
VendorID = DG2.Table.Records[row].GetValue("VendorID").ToString(),
Auto_Ordering = bool.Parse(DG2.Table.Records[row].GetValue("Auto_Ordering").ToString()),
Method = DG2.Table.Records[row].GetValue("Method").ToString(),
Phone = DG2.Table.Records[row].GetValue("Phone").ToString(),
MON = bool.Parse(DG2.Table.Records[row].GetValue("MON").ToString()),
TUE = bool.Parse(DG2.Table.Records[row].GetValue("TUE").ToString()),
WED = bool.Parse(DG2.Table.Records[row].GetValue("WED").ToString()),
THU = bool.Parse(DG2.Table.Records[row].GetValue("THU").ToString()),
FRI = bool.Parse(DG2.Table.Records[row].GetValue("FRI").ToString()),
SAT = bool.Parse(DG2.Table.Records[row].GetValue("SAT").ToString()),
SUN = bool.Parse(DG2.Table.Records[row].GetValue("SUN").ToString()),
Email = DG2.Table.Records[row].GetValue("Email").ToString(),
OrderTime = DateTime.Parse(DG2.Table.Records[row].GetValue("OrderTime").ToString()),
DayOfMonth = int.Parse(DG2.Table.Records[row].GetValue("DayOfMonth").ToString()),
};
using (Edit_Schedule_Info esi = new Edit_Schedule_Info(user, aom))
{
esi.ShowDialog();
Refresh();
}
} catch { }
}
public Edit_Schedule_Info(User _user, AutomaticOrderingModel modl)
{
InitializeComponent();
user = _user;
setModelToFilels(modl);
}
private void DisplayRecords()
{
try
{
if (con.con.State == ConnectionState.Open)
{
con.con.Close();
}
con.con.Open();
string qot = "'";
System.Data.SqlClient.SqlDataReader sdr;
string script = File.ReadAllText("SQL/AutomaticOrderSetting.sql");
script = script.Replace("\r\n", " ");
script = script.Replace("\t", " ");
SqlCommand cmd = new SqlCommand(script, con.con);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
AutomaticOrderingModel slv = new AutomaticOrderingModel()
{
VendorID = sdr["VendorID"].ToString(),
Email = ifNullReturnZero(sdr["OrderEmails"]),
Phone = ifNullReturnZero(sdr["OrderPhoneNo"]),
Vendor = sdr["Name"].ToString(),
MON = ifNullReturnFalse(sdr["MON"]),
TUE = ifNullReturnFalse(sdr["TUE"]),
WED = ifNullReturnFalse(sdr["WED"]),
THU = ifNullReturnFalse(sdr["THU"]),
FRI = ifNullReturnFalse(sdr["FRI"]),
SAT = ifNullReturnFalse(sdr["SAT"]),
SUN = ifNullReturnFalse(sdr["SUN"]),
DayOfMonth = int.Parse(ifNullReturnZero(sdr["DayOfMonth"])),
OrderTime = DateTime.Parse(sdr["OrderTime"].ToString()),
Method = ifNullReturnZero(sdr["OrderMethod"].ToString()),
Set_Dos = "Click Here",
Auto_Ordering = ifNullReturnFalse(sdr["AutoOrdering"]),
};
myList.Add(slv);
}
con.con.Close();
DG2.DataSource = ConvertToDatatable.ToDataTable(myList);
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
