private void Limpiar()
{
txt_Nombre.Clear();
txt_Lote.Clear();
txt_Descripcion.Clear();
eliminarToolStripMenuItem.Enabled = false;
modificarToolStripMenuItem.Enabled = false;
errorProvider1.Clear();
groupBoxdatos.Visible = true;
try //Quita el panel de control en caso de que ya se haya utilizado
{
//Quito el panel de busqueda
Controls.Remove(panel_Busqueda);
}
catch (Exception)
{
//En caso de que no existe todavia el panel de busqueda
//omite la instrucción de quitar dicho control
}
try //Limpia el textbox de busqueda por si ya se utilizo
{
//Quito el panel de busqueda
txt_Busqueda.Clear();
}
catch (Exception)
{
//En caso de que no existe todavia el texbox
//omite la instrucción de quitar dicho control
}
}
private void GesTextBox_Layout(object sender, LayoutEventArgs e)
{
if (this.Text.Length > 0)
{
errorProvider2.Clear();
}
}
private void Limpiar()
{
groupBoxdatos.Visible = true;
txt_DineroActual.Clear();
txt_DineroCaja.Clear();
txt_Movimiento.Clear();
combo_Concepto.ResetText();
Ultimo_Fondo();
dateTime_Fecha.Enabled = false;
combo_Concepto.Enabled = false;
errorProvider1.Clear();
}
private void bttn_Guardar_Click(object sender, EventArgs e)
{
errorProvider1.Clear();
bool i = Verificar_CamposVacios();
if (i == true)
{
MessageBox.Show("Inserta todos los datos marcados", "Error de datos insertados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (maskedTextBox_Telefono.Text.Trim() == "")
{
MessageBox.Show("Inserta todos los datos marcados", "Error de datos insertados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
errorProvider1.SetError(maskedTextBox_Telefono, "No puedes dejar el campo vacio");
}
else if (i == false && maskedTextBox_Telefono.Text != "")
{
if (txt_Contraseña.Text == txt_Confirmacion.Text)
{
OleDbConnection conexion = null;
OleDbTransaction transaccion = null;
try
{
conexion = new OleDbConnection(ObtenerString());
conexion.Open();
transaccion = conexion.BeginTransaction(System.Data.IsolationLevel.Serializable);
OleDbCommand comando = new OleDbCommand("SP_Informacion_Modificar", conexion, transaccion);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.Clear();
comando.Parameters.AddWithValue("@Correo", txt_CorreoElectronico.Text);
comando.Parameters.AddWithValue("@Servidor", combo_Servidor.SelectedIndex + 1);
comando.Parameters.AddWithValue("@Contraseña", txt_Contraseña.Text);
comando.Parameters.AddWithValue("@Telefono", maskedTextBox_Telefono.Text);
comando.ExecuteNonQuery();
transaccion.Commit();
conexion.Close();
MessageBox.Show("Datos guardados con éxito", "Solicitud procesada", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error inesperado", "Error de datos insertados", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
errorProvider1.SetError(txt_Contraseña, "La contraseña no son iguales");
errorProvider1.SetError(txt_Confirmacion, "La contraseña no son iguales");
MessageBox.Show("Verifique la contraseña porfavor", "Contraseña no son iguales", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
Cargar_Datos();
}
// double
public static bool ValidDouble(TextBox tb, string name, System.Windows.Forms.ErrorProvider er)
{
er.Clear();
try
{
double i = Convert.ToDouble(tb.Text);
}
catch
{
er.Clear();
er.SetError(tb, name + " must be a numeric decimal value");
return(false);
}
return(true);
}
private void fac_key_Leave(object sender, EventArgs e)
{
String fc_if = fac_key.Text;
if (fc_if.Equals(""))
{
werror.SetError(this.fac_key, "This Field should not be empty");
fac_key.Focus();
}
else
{
werror.SetError(this.fac_key, "");
werror.Clear();
}
}
private void btt_Buscar_Click(object sender, EventArgs e)
{
errorProvider_Textbox.Clear();
if (txt_Producto.Text.Trim() == "")
{
errorProvider_Textbox.SetError(txt_Producto, "No puedes dejar el campo vacio");
MessageBox.Show("Inserta todos los datos marcados", "Error de datos insertados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
OleDbConnection con = new OleDbConnection();
OleDbCommand coman = new OleDbCommand();
OleDbDataReader dr;
con.ConnectionString = ObtenerString();
coman.Connection = con;
string busqueda = txt_Producto.Text;
txt_Producto.Text = busqueda.ToUpper();
coman.CommandText = "SELECT Tb_Produccion.Id_Produccion, Tb_Producto.Nombre, Tb_Producto.Codigo_Barra, Tb_Produccion.Activo FROM Tb_Producto INNER JOIN Tb_Produccion ON Tb_Producto.Id_Producto = Tb_Produccion.Id_Producto WHERE (Tb_Producto.Nombre ='" + busqueda.ToUpper() + "') OR (Tb_Producto.Codigo_Barra ='" + busqueda.ToUpper() + "') AND (Tb_Produccion.Activo = 'S')";
coman.CommandType = CommandType.Text;
con.Open();
dataGridView_Produccion.Rows.Clear();
dr = coman.ExecuteReader();
while (dr.Read())
{
int Renglon = dataGridView_Produccion.Rows.Add();
Idp = dr.GetInt32(dr.GetOrdinal("Id_Produccion"));
dataGridView_Produccion.Rows[Renglon].Cells["Id_ProduccionC"].Value = dr.GetInt32(dr.GetOrdinal("Id_Produccion"));
dataGridView_Produccion.Rows[Renglon].Cells["NombreC"].Value = dr.GetString(dr.GetOrdinal("Nombre"));
dataGridView_Produccion.Rows[Renglon].Cells["Codigo_BarraC"].Value = dr.GetString(dr.GetOrdinal("Codigo_Barra"));
}
con.Close();
}
}
private void btt_Buscar_Click(object sender, EventArgs e)
{
errorProvider_Textbox.Clear();
if (txt_Cliente.Text.Trim() == "")
{
errorProvider_Textbox.SetError(txt_Cliente, "No puedes dejar el campo vacio");
MessageBox.Show("Inserta todos los datos marcados", "Error de datos insertados", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
OleDbConnection con = new OleDbConnection();
OleDbCommand coman = new OleDbCommand();
OleDbDataReader dr;
con.ConnectionString = ObtenerString();
coman.Connection = con;
string busqueda = txt_Cliente.Text;
txt_Cliente.Text = busqueda.ToUpper();
coman.CommandText = "SELECT Id_Cliente, Nombre, Apellido_P, Apellido_M FROM Tb_Cliente WHERE (Tb_Cliente.Activo = 'S') and (Tb_Cliente.Nombre='" + busqueda.ToUpper() + "'OR Tb_Cliente.Apellido_P='" + busqueda.ToUpper() + "'OR Tb_Cliente.Apellido_M='" + busqueda.ToUpper() + "')";
coman.CommandType = CommandType.Text;
con.Open();
dataGridView_Cliente.Rows.Clear();
dr = coman.ExecuteReader();
while (dr.Read())
{
int Renglon = dataGridView_Cliente.Rows.Add();
Idp = dr.GetInt32(dr.GetOrdinal("Id_Cliente"));
dataGridView_Cliente.Rows[Renglon].Cells["Id_ClienteC"].Value = dr.GetInt32(dr.GetOrdinal("Id_Cliente"));
dataGridView_Cliente.Rows[Renglon].Cells["NombreC"].Value = dr.GetString(dr.GetOrdinal("Nombre"));
dataGridView_Cliente.Rows[Renglon].Cells["Apellido_PC"].Value = dr.GetString(dr.GetOrdinal("Apellido_P"));
dataGridView_Cliente.Rows[Renglon].Cells["Apellido_MC"].Value = dr.GetString(dr.GetOrdinal("Apellido_M"));
}
con.Close();
}
}
// integer
public static bool ValidInt(TextBox tb, string name, System.Windows.Forms.ErrorProvider er)
{
er.Clear();
try
{
int i = Convert.ToInt32(tb.Text);
}
catch
{
er.Clear();
er.SetError(tb, name + " must be an integer");
return(false);
}
return(true);
}
/// <summary>
/// ClearError
/// </summary>
public void ClearAllError()
{
if (m_firstInvalidControl != null)
{
ShowErrorIcon(m_firstInvalidControl, string.Empty);
m_firstInvalidControl = null;
}
m_errorProvider.Clear();
}
public static void RegexCheck(Control checkControl, ErrorProvider errorProvider, string regexStr, CancelEventArgs e)
{
if (!Regex.IsMatch(checkControl.Text, regexStr)) {
e.Cancel = true;
errorProvider.SetError(checkControl, "格式不正确!");
} else {
errorProvider.Clear();
}
}
public static void NotNullCheck(Control checkControl, ErrorProvider errorProvider, CancelEventArgs e)
{
if (string.IsNullOrEmpty(checkControl.Text)) {
e.Cancel = true;
errorProvider.SetError(checkControl, "不能为空!");
} else {
errorProvider.Clear();
}
}
public static void IntCheck(Control checkControl, ErrorProvider errorProvider, CancelEventArgs e)
{
int result;
if (!string.IsNullOrEmpty(checkControl.Text) && !int.TryParse(checkControl.Text, out result)) {
e.Cancel = true;
errorProvider.SetError(checkControl, "请输入数字!");
} else {
errorProvider.Clear();
}
}
public static bool ValidProvided(TextBox tb, string name, System.Windows.Forms.ErrorProvider er)
{
er.Clear();
if (tb.Text == string.Empty)
{
er.SetError(tb, name + " is missing");
return(false);
}
return(true);
}
public static bool RequiredCheck(ErrorProvider errorProvider, params Control[] controls)
{
errorProvider.Clear();
foreach (var control in controls) {
if (control.Text == String.Empty) {
errorProvider.SetError(control, "Input perlu diisi");
return false;
}
}
return true;
}
public static void isNumeric(ErrorProvider epMain, object sender, KeyPressEventArgs e)
{
if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) &&
(e.KeyChar != '.'))
{
epMain.SetError((Control)sender, Numeric);
e.Handled = true;
}
else
{
epMain.Clear();
}
}
// **************** Add & Edit client Code *****************************
private void btn_AddNewClient_Click(object sender, EventArgs e)
{
btn_CancelBook.Visible = true;
newClient = true;
clearForm();
//enable Form Entries
formEnable(true);
btn_Multibook.Text = "Save Client";
int noRows = dsNWRC_HairBeauty.Tables["Client"].Rows.Count;
if (noRows == 0)
{
lbl_ClientNoTextBook.Text = "10000";
}
else
{
getNumber(noRows);
}
errP.Clear();
}
public static bool isReqired(DevExpress.XtraEditors.TextEdit textbox, string name, ErrorProvider Errorprovider)
{
if (string.IsNullOrEmpty(textbox.Text)) {
//MessageBox.Show(name & " is a requierd field", "Entry error", MessageBoxButtons.OK, MessageBoxIcon.Error)
Errorprovider.SetError(textbox, "This is a required");
MessageBox.Show(name + " is a requierd field", "Entry error", MessageBoxButtons.OK, MessageBoxIcon.Error);
textbox.Select();
return false;
} else {
Errorprovider.Clear();
return true;
}
}
internal static bool ValidarCliente(DevComponents.DotNetBar.Controls.TextBoxX tb_nombre, DevComponents.DotNetBar.Controls.TextBoxX tb_ci, System.Windows.Forms.ErrorProvider errorIcono, facturacion.Vistas.VCliente vCliente)
{
if (tb_nombre.Text == string.Empty)
{
errorIcono.SetError(tb_nombre, "El nombre del usuario es necesario");
ToastNotification.Show(vCliente, "El nombre del usuario es necesario", global::facturacion.Properties.Resources.Warning_sign, 3000, (eToastGlowColor.Red), (eToastPosition.TopRight));
return(false);
}
else
{
errorIcono.Clear();
}
if (tb_ci.Text == string.Empty)
{
errorIcono.SetError(tb_nombre, "El ci del usuario es necesario");
ToastNotification.Show(vCliente, "El ci del usuario es necesario", global::facturacion.Properties.Resources.Warning_sign, 3000, (eToastGlowColor.Red), (eToastPosition.TopRight));
return(false);
}
else
{
errorIcono.Clear();
}
return(true);
}
/// <summary>
/// Returns whether there is a valid string in the custom
/// name text box. The string must be a name that can be used to
/// create an xml element or attribute.
/// </summary>
bool ValidateCustomName()
{
string name = customNameTextBox.Text.Trim();
if (name.Length > 0)
{
try {
VerifyName(name);
errorProvider.Clear();
return(true);
} catch (XmlException ex) {
errorProvider.SetError(customNameTextBox, ex.Message);
}
}
return(false);
}
public void SetError(ErrorProvider provider , Control control, string message)
{
if (!string.IsNullOrEmpty(message))
{
if (provider.GetError(control) != "")
{
provider.Clear();
Counter--;
}
else
{
provider.SetError(control,message);
Counter ++;
}
}
}
private void btn_Login_Click(object sender, EventArgs e)
{
clicked = true;
bool userOk = false;
bool passOk = false;
lblInfo.Text = "";
errP.Clear();
foreach (DataRow dr in dsNWRC_HairBeauty.Tables["UserLogin"].Rows)
{
if (dr["Username"].ToString() == tb_Username.Text)
{
userOk = true;
if (dr["PassKey"].ToString() == tb_Password.Text)
{
passOk = true;
break;
}
}
}
if ((passOk) && (userOk))
{
lblInfo.ForeColor = Color.Green;
lblInfo.Text = "Login Complete";
this.Dispose(); // Clears resources instead of leaving them with close
}
else if ((userOk))
{
lblInfo.ForeColor = Color.OrangeRed;
lblInfo.Text = "Invalid Password Please Check and Try again";
}
else
{
lblInfo.ForeColor = Color.Red;
lblInfo.Text = "Invalid Username Please Check and Try again";
}
}
private void Buscarbutton_Click(object sender, EventArgs e)
{
Rutas ruta = new Rutas();
if (RutaIdtextBox.TextLength == 0)
{
ErrorProvider error = new ErrorProvider();
error.Clear();
error.SetError(RutaIdtextBox, "Debe especificar el id");
}
else
{
int id;
int.TryParse(RutaIdtextBox.Text, out id);
ruta.Buscar(id);
RutaIdtextBox.Text = ruta.RutaId.ToString();
NombreRutatextBox.Text = ruta.NombreRuta.ToString();
RutaDetalletextBox.Text = ruta.Detalle.ToString();
//CobradordataGridView.Text = CobradorIdcomboBox;
}
}
/// <summary>
/// Clears all errors associated with this component.
/// </summary>
/// <PermissionSet><IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" version="1" Unrestricted="true"/></PermissionSet>
public new void Clear()
{
base.Clear();
_errorProviderInfo.Clear();
_errorProviderWarn.Clear();
}
private void btn_AddUser_Click(object sender, EventArgs e)
{
MyUser myUser = new MyUser();
bool ok = true;
errP.Clear();
try
{
myUser.UserID = Convert.ToInt32(lbl_UserNoText.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lbl_UserNoText, MyEx.tostring());
}
try
{
myUser.Username = txt_Username.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Username, MyEx.tostring());
}
try
{
myUser.UserForename = txt_UserForename.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_UserForename, MyEx.tostring());
}
try
{
myUser.UserSurname = txt_UserSurname.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_UserSurname, MyEx.tostring());
}
try
{
myUser.UserLevel = txt_UserLevel.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_UserLevel, MyEx.tostring());
}
try
{
myUser.UserPassword = txt_UserPass.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_UserPass, MyEx.tostring());
}
try
{
myUser.UserEmail = txt_UserEmail.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_UserEmail, MyEx.tostring());
}
try
{
if (chk_Super.Checked)
{
myUser.Super = "Y";
}
else
{
myUser.Super = "N";
}
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(chk_Super, MyEx.tostring());
}
try
{
if (ok)
{
drUser = dsNWRC_HairBeauty.Tables["UserLogin"].NewRow();
drUser["UserID"] = myUser.UserID;
drUser["Username"] = myUser.Username;
drUser["UserSurname"] = myUser.UserSurname;
drUser["UserForename"] = myUser.UserForename;
drUser["UserEmail"] = myUser.UserEmail;
drUser["UserLevel"] = myUser.UserLevel;
drUser["Passkey"] = myUser.UserPassword;
drUser["Super"] = myUser.Super;
dsNWRC_HairBeauty.Tables["UserLogin"].Rows.Add(drUser);
daUser.Update(dsNWRC_HairBeauty, "UserLogin");
MessageBox.Show("New User " + lbl_UserNoText.Text + " added !!!");
if (MessageBox.Show("Do you wish to add another User?", "Add User", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
clearAddForm();
getNumber(dsNWRC_HairBeauty.Tables["UserLogin"].Rows.Count);
}
else
{
tab_User.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
}
private void saveBooking()
{
foreach (DataRow dr in dsNWRC_HairBeauty.Tables["Booking"].Rows)
{
if (bookingNumber == dr["BookingNo"].ToString())
{
dr.Delete();
daBook.Update(dsNWRC_HairBeauty, "Booking");
break;
}
}
if (frm_Booking.bookList.Count > 0)
{
cellClicked = false;
MyBooking mybooking = new MyBooking();
bool ok = true;
errP.Clear();
try // Booking Number
{ mybooking.BookNo = Convert.ToInt32(frm_Booking.bookList[0].ToString()); }
catch (MyException)
{ ok = false; }
try // Client Number
{ mybooking.ClientNo = frm_Booking.bookList[1].ToString(); }
catch (MyException)
{ ok = false; }
try // Title
{ mybooking.Forename = frm_Booking.bookList[2].ToString(); }
catch (MyException)
{ ok = false; }
try // Forename
{ mybooking.Surname = frm_Booking.bookList[3].ToString(); }
catch (MyException)
{ ok = false; }
try // Surname
{ mybooking.Surname = frm_Booking.bookList[4].ToString(); }
catch (MyException)
{ ok = false; }
try // Treatment
{ mybooking.Treatment = frm_Booking.bookList[5].ToString(); }
catch (MyException)
{ ok = false; }
try // CheckBox 1
{ mybooking.Check1 = Boolean.Parse(frm_Booking.bookList[6]); }
catch (MyException)
{ ok = false; }
try // CheckBox 2
{ mybooking.Check2 = Boolean.Parse(frm_Booking.bookList[7]); }
catch (MyException)
{ ok = false; }
try // CheckBox 3
{ mybooking.Check3 = Boolean.Parse(frm_Booking.bookList[8]); }
catch (MyException)
{ ok = false; }
try // CheckBox 4
{ mybooking.Check4 = Boolean.Parse(frm_Booking.bookList[9]); }
catch (MyException)
{ ok = false; }
try // CheckBox 5
{ mybooking.Check5 = Boolean.Parse(frm_Booking.bookList[10]); }
catch (MyException)
{ ok = false; }
try// CheckBox 6
{ mybooking.Check6 = Boolean.Parse(frm_Booking.bookList[11]); }
catch (MyException)
{ ok = false; }
try// CheckBox 7
{ mybooking.Check7 = Boolean.Parse(frm_Booking.bookList[12]); }
catch (MyException)
{ ok = false; }
try// CheckBox 8
{ mybooking.Check8 = Boolean.Parse(frm_Booking.bookList[13]); }
catch (MyException)
{ ok = false; }
try// CheckBox 9
{ mybooking.Check9 = Boolean.Parse(frm_Booking.bookList[14]); }
catch (MyException)
{ ok = false; }
try// CheckBox 10
{ mybooking.Check10 = Boolean.Parse(frm_Booking.bookList[15]); }
catch (MyException)
{ ok = false; }
try// CheckBox 11
{ mybooking.Check11 = Boolean.Parse(frm_Booking.bookList[16]); }
catch (MyException)
{ ok = false; }
try// CheckBox 12
{ mybooking.Check12 = Boolean.Parse(frm_Booking.bookList[17]); }
catch (MyException)
{ ok = false; }
try// CheckBox 13
{ mybooking.Check13 = Boolean.Parse(frm_Booking.bookList[18]); }
catch (MyException)
{ ok = false; }
try// CheckBox 14
{ mybooking.Check14 = Boolean.Parse(frm_Booking.bookList[19]); }
catch (MyException)
{ ok = false; }
try// CheckBox 15
{ mybooking.Check15 = Boolean.Parse(frm_Booking.bookList[20]); }
catch (MyException)
{ ok = false; }
try// CheckBox 16
{ mybooking.Check16 = Boolean.Parse(frm_Booking.bookList[21]); }
catch (MyException)
{ ok = false; }
try// CheckBox 17
{ mybooking.Check17 = Boolean.Parse(frm_Booking.bookList[22]); }
catch (MyException)
{ ok = false; }
try// CheckBox 18
{ mybooking.Check18 = Boolean.Parse(frm_Booking.bookList[23]); }
catch (MyException)
{ ok = false; }
try// CheckBox 19
{ mybooking.Check19 = Boolean.Parse(frm_Booking.bookList[24]); }
catch (MyException)
{ ok = false; }
try// CheckBox 20
{ mybooking.Check20 = Boolean.Parse(frm_Booking.bookList[25]); }
catch (MyException)
{ ok = false; }
try
{
if (ok)
{
drBook = dsNWRC_HairBeauty.Tables["Booking"].NewRow();
drBook["BookingNo"] = mybooking.BookNo;
drBook["ClientNo"] = mybooking.ClientNo;
drBook["UserID"] = 1001;
drBook["DateofApp"] = frm_Home.selDate;
drBook["TreatmentNo"] = mybooking.Treatment;
drBook["BookingTotal"] = 0.0;
drBook["Salon"] = frm_Home.salon;
drBook["SalonNo"] = frm_Home.salonNo;
drBook["Check1"] = mybooking.Check1;
drBook["Check2"] = mybooking.Check2;
drBook["Check3"] = mybooking.Check3;
drBook["Check4"] = mybooking.Check4;
drBook["Check5"] = mybooking.Check5;
drBook["Check6"] = mybooking.Check6;
drBook["Check7"] = mybooking.Check7;
drBook["Check8"] = mybooking.Check8;
drBook["Check9"] = mybooking.Check9;
drBook["Check10"] = mybooking.Check10;
drBook["Check11"] = mybooking.Check11;
drBook["Check12"] = mybooking.Check12;
drBook["Check13"] = mybooking.Check13;
drBook["Check14"] = mybooking.Check14;
drBook["Check15"] = mybooking.Check15;
drBook["Check16"] = mybooking.Check16;
drBook["Check17"] = mybooking.Check17;
drBook["Check18"] = mybooking.Check18;
drBook["Check19"] = mybooking.Check19;
drBook["Check20"] = mybooking.Check20;
drBook["LocY"] = rowindex;
drBook["LocX"] = columnindex;
dsNWRC_HairBeauty.Tables["Booking"].Rows.Add(drBook);
daBook.Update(dsNWRC_HairBeauty, "Booking");
rowindex = 0;
columnindex = 0;
MessageBox.Show("New Booking " + mybooking.BookNo + " added !!!");
timer2.Start();
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
}
}
private void btn_AddTreat_Click(object sender, EventArgs e)
{
MyTreatment myTreat = new MyTreatment();
bool ok = true;
errP.Clear();
try
{
myTreat.TreatmentNo = Convert.ToInt32(lbl_TreatNoText.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lbl_TreatNoText, MyEx.tostring());
}
try
{
myTreat.TreatGroup = cb_TreatGroup.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(cb_TreatGroup, MyEx.tostring());
}
try
{
myTreat.TreatName = txt_TreatName.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_TreatName, MyEx.tostring());
}
try
{
myTreat.TreatType = cb_TreatType.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(cb_TreatType, MyEx.tostring());
}
try
{
myTreat.TreatPrice = Convert.ToDecimal(txt_TreatPrice.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_TreatPrice, MyEx.tostring());
}
try
{
if (ok)
{
drTreat = dsNWRC_HairBeauty.Tables["Treatments"].NewRow();
drTreat["TreatmentNo"] = myTreat.TreatmentNo;
drTreat["TreatGroup"] = myTreat.TreatGroup;
drTreat["TreatName"] = myTreat.TreatName;
drTreat["TreatType"] = myTreat.TreatType;
drTreat["Price"] = myTreat.TreatPrice;
dsNWRC_HairBeauty.Tables["Treatments"].Rows.Add(drTreat);
daTreat.Update(dsNWRC_HairBeauty, "Treatments");
MessageBox.Show("New User " + lbl_TreatNoText.Text + " added !!!");
if (MessageBox.Show("Do you wish to add another Treatment?", "Add Treatment", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
clearAddForm();
getNumber(dsNWRC_HairBeauty.Tables["Treatments"].Rows.Count);
}
else
{
tab_Treatments.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
}
private void btn_AddClient_Click(object sender, EventArgs e)
{
MyClient myClient = new MyClient();
bool ok = true;
errP.Clear();
try
{
myClient.ClientNo = Convert.ToInt32(lbl_ClientNoText.Text.Trim());
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(lbl_ClientNoText, MyEx.tostring());
}
try
{
myClient.Title = cmb_Title.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(cmb_Title, MyEx.tostring());
}
try
{
myClient.Surname = txt_Surname.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Surname, MyEx.tostring());
}
try
{
myClient.Forename = txt_Forename.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Forename, MyEx.tostring());
}
try
{
myClient.Street = richTxt_Street.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(richTxt_Street, MyEx.tostring());
}
try
{
myClient.Town = txt_Town.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Town, MyEx.tostring());
}
try
{
myClient.County = txt_County.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_County, MyEx.tostring());
}
try
{
myClient.Postcode = txt_Postcode.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Postcode, MyEx.tostring());
}
try
{
myClient.Country = txt_Country.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Country, MyEx.tostring());
}
try
{
myClient.TelNo = txt_Telephone.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Telephone, MyEx.tostring());
}
try
{
myClient.Email = txt_Email.Text.Trim();
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(txt_Email, MyEx.tostring());
}
try
{
if (chk_Skin.Checked)
{
myClient.SkinTest = "Yes";
}
else
{
myClient.SkinTest = "No";
}
}
catch (MyException MyEx)
{
ok = false;
errP.SetError(chk_Skin, MyEx.tostring());
}
try
{
if (ok)
{
drclient = dsNWRC_HairBeauty.Tables["Client"].NewRow();
drclient["ClientNo"] = myClient.ClientNo;
drclient["Title"] = myClient.Title;
drclient["Surname"] = myClient.Surname;
drclient["Forename"] = myClient.Forename;
drclient["Street"] = myClient.Street;
drclient["Town"] = myClient.Town;
drclient["County"] = myClient.County;
drclient["PostCode"] = myClient.Postcode;
drclient["Country"] = myClient.Country;
drclient["TelNo"] = myClient.TelNo;
drclient["Email"] = myClient.Email;
drclient["SkinTest"] = myClient.SkinTest;
dsNWRC_HairBeauty.Tables["Client"].Rows.Add(drclient);
daClient.Update(dsNWRC_HairBeauty, "Client");
MessageBox.Show("New Customer " + lbl_ClientNoText.Text + " added !!!");
if (MessageBox.Show("Do you wish to add another Client?", "Add Client", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
clearAddForm();
getNumber(dsNWRC_HairBeauty.Tables["Client"].Rows.Count);
}
else
{
tab_Client.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error);
}
}
public void ClearNotifyError()
{
myErrNotifier.Clear();
}
public static void VerificarNoVacios(object sender, CancelEventArgs e, ErrorProvider error)
{
if (sender is TextBox)
{
if (string.IsNullOrEmpty(((TextBox)sender).Text))
{
error.SetError(((TextBox)sender), !string.IsNullOrEmpty(((TextBox)sender).Text) ? string.Empty : "Campo Obligatorio");
e.Cancel = true;
}
else
{
error.SetError(((TextBox)sender), "");
}
return;
}
if (sender is NumericUpDown)
{
if (string.IsNullOrEmpty(((NumericUpDown)sender).Text))
{
error.SetError(((NumericUpDown)sender), !string.IsNullOrEmpty(((NumericUpDown)sender).Text) ? string.Empty : "Campo Obligatorio");
e.Cancel = true;
}
else
{
error.Clear();
}
return;
}
if (sender is ComboBox)
{
if (((ComboBox)sender).Items.Count <= 0)
{
error.SetError(((ComboBox)sender), (((ComboBox)sender).Items.Count > 0) ? string.Empty : "Campo Obligatorio");
e.Cancel = true;
}
else
{
error.Clear();
}
return;
}
}
private void ClearErrorProvider(ErrorProvider activeErrorProvider, ToolTip activeToolTip)
{
activeErrorProvider.Clear();
activeToolTip.RemoveAll();
}
/// <summary>
/// ocurre cuando el control deja de ser el control activo del formulario
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Validarting(object sender, EventArgs e)
{
errorProvider1.Clear();
errorProvider2.Clear();
//vuelvo a setear el color
//cambio el color de fondo al txt para que el usuario distinga cual se esta editando
//this.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.BackColor = System.Drawing.Color.White;
//vuelvo a setear el color
bool error = false;
gesTextBox sd = (gesTextBox)sender;
Regex regStr;
switch (tipos)
{
case enumTipos.Fecha:
regStr = new Regex(@"\d{2}/\d{2}/\d{4}");
if (!regStr.IsMatch(sd.Text))
{
errorProvider1.SetError(this, "La fecha no es válida; dd/mm/yyyy");
error = true;
}
break;
case enumTipos.TelefonoConArea:
regStr = new Regex(@"\d{3}-\d{3}-\d{4}");
if (!regStr.IsMatch(sd.Text))
{
errorProvider1.SetError(this, "El telefono no es válido; xxx-xxx-xxxx");
error = true;
}
break;
case enumTipos.Email:
{
regStr = new Regex(@"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");
if (!regStr.IsMatch(sd.Text))
{
errorProvider1.SetError(this, "El Email no es válido; xxxxxx@xxxx");
error = true;
}
}
break;
case enumTipos.Decimal:
{
regStr = new Regex(@"[0-9]{1,9}(\.[0-9]{0,2})?$");
if (!regStr.IsMatch(sd.Text))
{
errorProvider1.SetError(this, "El valor debe ser numerico");
error = true;
}
}
break;
case enumTipos.Numero:
{
regStr = new Regex(@"[0-9]{1,9}(\.[0-9]{0,2})?$");
if (!regStr.IsMatch(sd.Text))
{
errorProvider1.SetError(this, "El valor debe ser numerico");
error = true;
}
}
break;
}
if (error)
{
this.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.BackColor = System.Drawing.Color.Red;
sd.SelectNextControl(sd, true, true, true, true);
}
}
private void VAL_checkRange(TextBox box, double min, double max, ErrorProvider err, out double y)
{
if (VAL_isRangeNum(box.Text, min, max, out y))
{
// clear error
err.Clear();
}
else
{
// raise error
err.SetError(box,
String.Format("Must be a number between {0:f2} and {1:f2}.",
min, max));
}
}
public void MethodClear ()
{
Form myForm = new Form ();
myForm.ShowInTaskbar = false;
Label label1 = new Label ();
Label label2 = new Label ();
ErrorProvider myErrorProvider = new ErrorProvider ();
myErrorProvider.SetError (label1, "ErrorMsg1");
myErrorProvider.SetError (label2, "ErrorMsg2");
Assert.AreEqual ("ErrorMsg1", myErrorProvider.GetError (label1), "#1");
Assert.AreEqual ("ErrorMsg2", myErrorProvider.GetError (label2), "#2");
myErrorProvider.Clear ();
Assert.AreEqual (string.Empty, myErrorProvider.GetError (label1), "#3");
Assert.AreEqual (string.Empty, myErrorProvider.GetError (label2), "#4");
myForm.Dispose ();
}
private void VAL_checkLpscBox(TextBox box, ErrorProvider err, out int[] storage, int lpscNum)
{
char[] numSeparators = { ';' };
int min, max;
if (lpscNum == 0)
{
min = (int)Consts.LpscDomain.min0;
max = (int)Consts.LpscDomain.max0;
}
else if (lpscNum == 1)
{
min = (int)Consts.LpscDomain.min1;
max = (int)Consts.LpscDomain.max1;
}
else
{
// invalid
min = 2;
max = 1;
}
// clear error
err.Clear();
// break up text into ; separated strings
String[] domain = box.Text.Split(numSeparators, StringSplitOptions.RemoveEmptyEntries);
int domainCnt = domain.Length;
// create new array to store power domains
storage = new int[domainCnt];
// abort if no numbers
if (domainCnt < 1) return;
// validate substrings (numeric)
for (int i = 0; i < domainCnt; i++)
{
if (VAL_isRangeNum(domain[i], min, max, out storage[i]))
{
// VAL_isRangeNum saves domain number to array
}
else
{
// raise error
err.SetError(box, String.Format(
"Must list LPSC numbers between {0} and {1} separated by \';\'",
min, max));
break;
}
}
}
private void GesComboBox_Layout(object sender, LayoutEventArgs e)
{
//if (this.SelectedIndex >= 0)
errorProvider2.Clear();
}
/// <summary>
/// pnl : 整個課表的 container
/// schType : 課表類型
///
/// </summary>
/// <param name="pnl"></param>
/// <param name="schType"></param>
public DecCalendar(DevComponents.DotNetBar.PanelEx pnl)
{
pnl.Tag = this;
#region 註冊事件
CalendarEvents.ReplaceEvent += (sender, e) => UpdateContent();
CalendarEvents.ExchangeEvent += (sender, e) =>
{
this.SelectedCalendars = new List<CalendarRecord>();
UpdateContent();
};
CalendarEvents.WeekChangeEvent += (vsender, ve) =>
{
if (ve.Type.Equals(this.Type) &&
ve.AssocID.Equals(this.AssocID))
{
this.SelectedCalendars = new List<CalendarRecord>();
this.UpdateContent();
}
};
CalendarEvents.WeekdayPeriodChangeEvent += CalendarEvents_WeekdayPeriodChangeEvent;
#endregion
#region 建立元件
pnl.Controls.Clear();
PanelEx pnlCalendarControl = makePanel(string.Empty, string.Empty, new Point(), new Size(10,50));
pnlCalendarControl.Dock = DockStyle.Top;
btnPrevious = CreateButton(new Size(50, 25));
btnNext = CreateButton(new Size(50, 25));
btnPrevious.Text = "上週";
btnPrevious.Location = new Point(10, 10);
btnPrevious.Click += (sender, e) =>
{
SchoolYearSemesterOption.Instance.StartDate = SchoolYearSemesterOption.Instance.StartDate.AddDays(-7);
SchoolYearSemesterOption.Instance.EndDate = SchoolYearSemesterOption.Instance.EndDate.AddDays(-7);
CalendarEvents.RaiseWeekChangeEvent(this.Type,this.AssocID);
};
btnNext.Text = "下週";
btnNext.Location = new Point(70, 10);
btnNext.Click += (sender, e) =>
{
SchoolYearSemesterOption.Instance.StartDate = SchoolYearSemesterOption.Instance.StartDate.AddDays(7);
SchoolYearSemesterOption.Instance.EndDate = SchoolYearSemesterOption.Instance.EndDate.AddDays(7);
CalendarEvents.RaiseWeekChangeEvent(this.Type,this.AssocID);
};
btnCurrent = CreateButton(new Size(50, 25));
btnCurrent.Text = "本週";
btnCurrent.Location = new Point(130, 10);
btnCurrent.Click += (sender,e)=>
{
SchoolYearSemesterOption.Instance.StartDate = DateTime.Now.StartOfWeek(DayOfWeek.Monday).ToDayStart();
SchoolYearSemesterOption.Instance.EndDate = SchoolYearSemesterOption.Instance.StartDate.AddDays(6);
CalendarEvents.RaiseWeekChangeEvent(this.Type,this.AssocID);
};
ButtonX btnPrint = CreateButton(new Size(50, 25));
btnPrint.Location = new Point(190,10);
btnPrint.Text = "列印";
btnPrint.Click += (sender,e)=>
{
if (this.Type.Equals(CalendarType.Teacher))
{
List<CalendarRecord> QueryResult = new List<CalendarRecord>();
DateTime dteStart = SchoolYearSemesterOption.Instance.StartDate;
DateTime dteEnd = SchoolYearSemesterOption.Instance.EndDate;
List<string> SelectedClassNames = new List<string>();
List<string> SelectedTeacherNames = new List<string>(){AssocID};
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (vsender, ve) =>
{
#region 找出調課記錄
List<CalendarRecord> ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null,
null, null, null, null, null);
List<CalendarRecord> ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null);
Dictionary<string, CalendarRecord> Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出代課記錄
List<CalendarRecord> RepRecords = Calendar.Instance.FindReplaceRecords(
SelectedTeacherNames, null, SelectedClassNames, null, dteStart, dteEnd);
List<CalendarRecord> AbsRecords = Calendar.Instance.FindReplaceRecords(
null, SelectedTeacherNames, SelectedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
#endregion
QueryResult.AddRange(Records.Values);
List<CalendarRecord> RelatedQueryResult = new List<CalendarRecord>();
List<string> RelatedClassNames = new List<string>();
List<string> RelatedTeacherNames = new List<string>();
foreach (CalendarRecord record in Records.Values)
{
if (!string.IsNullOrWhiteSpace(record.ReplaceID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.AbsTeacherName);
}
if (!string.IsNullOrWhiteSpace(record.ExchangeID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
if (record.ExchangeCalendar!=null)
RelatedTeacherNames.Add(record.ExchangeCalendar.TeacherName);
}
}
RelatedTeacherNames = RelatedTeacherNames.Distinct().ToList();
RelatedClassNames = RelatedClassNames.Distinct().ToList();
QueryResult.Clear();
#region 找出相關調課記錄
ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, RelatedTeacherNames, RelatedClassNames, null,
null, null, null, null, null);
ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, RelatedTeacherNames, RelatedClassNames, null);
Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出相關代課記錄
RepRecords = Calendar.Instance.FindReplaceRecords(
RelatedTeacherNames, null, RelatedClassNames, null, dteStart, dteEnd);
AbsRecords = Calendar.Instance.FindReplaceRecords(
null, RelatedTeacherNames, RelatedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
QueryResult.AddRange(Records.Values);
#endregion
};
worker.RunWorkerCompleted += (vsender, ve) =>
{
ExchangeReplaceReport.Instance.Print(QueryResult, dteStart, dteEnd);
MotherForm.SetStatusBarMessage(string.Empty);
btnPrint.Enabled = true;
};
worker.RunWorkerAsync();
MotherForm.SetStatusBarMessage("取得報表資料中！");
btnPrint.Enabled = false;
}
else if (this.Type.Equals(CalendarType.Class))
{
List<CalendarRecord> QueryResult = new List<CalendarRecord>();
DateTime dteStart = SchoolYearSemesterOption.Instance.StartDate;
DateTime dteEnd = SchoolYearSemesterOption.Instance.EndDate;
List<string> SelectedClassNames = new List<string>() { AssocID };
List<string> SelectedTeacherNames = new List<string>();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (vsender, ve) =>
{
#region 找出調課記錄
List<CalendarRecord> ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null,
null, null, null, null, null);
List<CalendarRecord> ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null);
Dictionary<string, CalendarRecord> Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出代課記錄
List<CalendarRecord> RepRecords = Calendar.Instance.FindReplaceRecords(
SelectedTeacherNames, null, SelectedClassNames, null, dteStart, dteEnd);
List<CalendarRecord> AbsRecords = Calendar.Instance.FindReplaceRecords(
null, SelectedTeacherNames, SelectedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
#endregion
QueryResult.AddRange(Records.Values);
List<CalendarRecord> RelatedQueryResult = new List<CalendarRecord>();
List<string> RelatedClassNames = new List<string>();
List<string> RelatedTeacherNames = new List<string>();
foreach (CalendarRecord record in Records.Values)
{
if (!string.IsNullOrWhiteSpace(record.ReplaceID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.AbsTeacherName);
}
if (!string.IsNullOrWhiteSpace(record.ExchangeID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.ExchangeCalendar.TeacherName);
}
}
RelatedTeacherNames = RelatedTeacherNames.Distinct().ToList();
RelatedClassNames = RelatedClassNames.Distinct().ToList();
QueryResult.Clear();
#region 找出相關調課記錄
ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, RelatedTeacherNames, null, null,
null, null, null, null, null);
ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, RelatedTeacherNames, null, null);
Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出相關代課記錄
RepRecords = Calendar.Instance.FindReplaceRecords(
RelatedTeacherNames, null, null, null, dteStart, dteEnd);
AbsRecords = Calendar.Instance.FindReplaceRecords(
null, RelatedTeacherNames, null, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
QueryResult.AddRange(Records.Values);
#endregion
};
worker.RunWorkerCompleted += (vsender, ve) =>
{
ExchangeReplaceReport.Instance.Print(QueryResult, dteStart, dteEnd);
MotherForm.SetStatusBarMessage(string.Empty);
btnPrint.Enabled = true;
};
worker.RunWorkerAsync();
MotherForm.SetStatusBarMessage("取得報表資料中！");
btnPrint.Enabled = false;
}
};
ButtonItem btnPrintAll = new ButtonItem("列印所有", "列印所有");
btnPrintAll.Click += (sender, e) =>
{
if (this.Type.Equals(CalendarType.Teacher))
{
List<CalendarRecord> QueryResult = new List<CalendarRecord>();
DateTime dteStart = SchoolYearSemesterOption.Instance.StartDate;
DateTime dteEnd = SchoolYearSemesterOption.Instance.EndDate;
List<string> SelectedClassNames = new List<string>();
List<string> SelectedTeacherNames = new List<string>();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (vsender, ve) =>
{
#region 找出調課記錄
List<CalendarRecord> ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null,
null, null, null, null, null);
List<CalendarRecord> ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null);
Dictionary<string, CalendarRecord> Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出代課記錄
List<CalendarRecord> RepRecords = Calendar.Instance.FindReplaceRecords(
SelectedTeacherNames, null, SelectedClassNames, null, dteStart, dteEnd);
List<CalendarRecord> AbsRecords = Calendar.Instance.FindReplaceRecords(
null, SelectedTeacherNames, SelectedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
#endregion
QueryResult.AddRange(Records.Values);
List<CalendarRecord> RelatedQueryResult = new List<CalendarRecord>();
List<string> RelatedClassNames = new List<string>();
List<string> RelatedTeacherNames = new List<string>();
foreach (CalendarRecord record in Records.Values)
{
if (!string.IsNullOrWhiteSpace(record.ReplaceID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.AbsTeacherName);
}
if (!string.IsNullOrWhiteSpace(record.ExchangeID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.ExchangeCalendar.TeacherName);
}
}
RelatedTeacherNames = RelatedTeacherNames.Distinct().ToList();
RelatedClassNames = RelatedClassNames.Distinct().ToList();
QueryResult.Clear();
#region 找出相關調課記錄
ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, RelatedTeacherNames, RelatedClassNames, null,
null, null, null, null, null);
ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, RelatedTeacherNames, RelatedClassNames, null);
Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出相關代課記錄
RepRecords = Calendar.Instance.FindReplaceRecords(
RelatedTeacherNames, null, RelatedClassNames, null, dteStart, dteEnd);
AbsRecords = Calendar.Instance.FindReplaceRecords(
null, RelatedTeacherNames, RelatedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
QueryResult.AddRange(Records.Values);
#endregion
};
worker.RunWorkerCompleted += (vsender, ve) =>
{
ExchangeReplaceReport.Instance.Print(QueryResult, dteStart, dteEnd);
MotherForm.SetStatusBarMessage(string.Empty);
btnPrint.Enabled = true;
};
worker.RunWorkerAsync();
MotherForm.SetStatusBarMessage("取得報表資料中！");
btnPrint.Enabled = false;
}
else if (this.Type.Equals(CalendarType.Class))
{
List<CalendarRecord> QueryResult = new List<CalendarRecord>();
DateTime dteStart = SchoolYearSemesterOption.Instance.StartDate;
DateTime dteEnd = SchoolYearSemesterOption.Instance.EndDate;
List<string> SelectedClassNames = new List<string>();
List<string> SelectedTeacherNames = new List<string>();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += (vsender, ve) =>
{
#region 找出調課記錄
List<CalendarRecord> ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null,
null, null, null, null, null);
List<CalendarRecord> ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, SelectedTeacherNames, SelectedClassNames, null);
Dictionary<string, CalendarRecord> Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出代課記錄
List<CalendarRecord> RepRecords = Calendar.Instance.FindReplaceRecords(
SelectedTeacherNames, null, SelectedClassNames, null, dteStart, dteEnd);
List<CalendarRecord> AbsRecords = Calendar.Instance.FindReplaceRecords(
null, SelectedTeacherNames, SelectedClassNames, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
#endregion
QueryResult.AddRange(Records.Values);
List<CalendarRecord> RelatedQueryResult = new List<CalendarRecord>();
List<string> RelatedClassNames = new List<string>();
List<string> RelatedTeacherNames = new List<string>();
foreach (CalendarRecord record in Records.Values)
{
if (!string.IsNullOrWhiteSpace(record.ReplaceID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.AbsTeacherName);
}
if (!string.IsNullOrWhiteSpace(record.ExchangeID))
{
RelatedClassNames.Add(record.ClassName);
RelatedTeacherNames.Add(record.TeacherName);
RelatedTeacherNames.Add(record.ExchangeCalendar.TeacherName);
}
}
RelatedTeacherNames = RelatedTeacherNames.Distinct().ToList();
RelatedClassNames = RelatedClassNames.Distinct().ToList();
QueryResult.Clear();
#region 找出相關調課記錄
ExchangeARecords = Calendar.Instance.FindExchangeRecords(
dteStart, dteEnd, RelatedTeacherNames, null, null,
null, null, null, null, null);
ExchangeBRecords = Calendar.Instance.FindExchangeRecords(
null, null, null, null, null,
dteStart, dteEnd, RelatedTeacherNames, null, null);
Records = new Dictionary<string, CalendarRecord>();
foreach (CalendarRecord ExchangeRecord in ExchangeARecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
foreach (CalendarRecord ExchangeRecord in ExchangeBRecords)
if (!Records.ContainsKey(ExchangeRecord.UID))
Records.Add(ExchangeRecord.UID, ExchangeRecord);
QueryResult.AddRange(Records.Values);
#endregion
#region 找出相關代課記錄
RepRecords = Calendar.Instance.FindReplaceRecords(
RelatedTeacherNames, null, null, null, dteStart, dteEnd);
AbsRecords = Calendar.Instance.FindReplaceRecords(
null, RelatedTeacherNames, null, null, dteStart, dteEnd);
foreach (CalendarRecord RepRecord in RepRecords)
if (!Records.ContainsKey(RepRecord.UID))
Records.Add(RepRecord.UID, RepRecord);
foreach (CalendarRecord AbsRecord in AbsRecords)
if (!Records.ContainsKey(AbsRecord.UID))
Records.Add(AbsRecord.UID, AbsRecord);
QueryResult.AddRange(Records.Values);
#endregion
};
worker.RunWorkerCompleted += (vsender, ve) =>
{
ExchangeReplaceReport.Instance.Print(QueryResult, dteStart, dteEnd);
MotherForm.SetStatusBarMessage(string.Empty);
btnPrint.Enabled = true;
};
worker.RunWorkerAsync();
MotherForm.SetStatusBarMessage("取得報表資料中！");
btnPrint.Enabled = false;
}
};
btnPrint.SubItems.Add(btnPrintAll);
ButtonItem btnSetting = new ButtonItem("設定", "設定");
btnSetting.Click += (sender, e) =>
{
#region 讀取 Preference
ConfigData configExchagne = K12.Data.School.Configuration["調代課通知單"];
if (configExchagne != null)
{
int _useTemplateNumber = 0;
int.TryParse(configExchagne["TemplateNumber"], out _useTemplateNumber);
string customize = configExchagne["CustomizeTemplate"];
byte[] _buffer = Resources.調代課通知單;
if (!string.IsNullOrEmpty(customize))
_buffer = Convert.FromBase64String(customize);
frmExchangeReplaceTemplateConfig frmConfig = new frmExchangeReplaceTemplateConfig(
_buffer,
_useTemplateNumber);
frmConfig.ShowDialog();
}
#endregion
//switch (mCalendarType)
//{
// case CalendarType.Teacher:
// new frmCalendarOption(CalendarOption.GetTeacherOption()).ShowDialog();
// break;
// case CalendarType.Class:
// new frmCalendarOption(CalendarOption.GetClassOption()).ShowDialog();
// break;
// case CalendarType.Classroom:
// new frmCalendarOption(CalendarOption.GetClassroomOption()).ShowDialog();
// break;
//}
};
btnPrint.SubItems.Add(btnSetting);
if (CalendarOption.PrintExtraButtons.Count > 0)
{
foreach (ButtonItem vButton in CalendarOption.PrintExtraButtons)
btnPrint.SubItems.Add(vButton);
}
ErrorProvider errProvier = new ErrorProvider();
DateTime dt = new DateTime();
lblName.Name = "lblTitle";
lblName.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
lblName.Font = new System.Drawing.Font("新細明體", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(136)));
lblName.Location = new Point(240, 13);
lblName.AutoSize = true;
txtStartDate.Font = new System.Drawing.Font("新細明體", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(136)));
txtStartDate.Location = new Point(380, 13);
txtStartDate.Width = 40;
txtStartDate.TextChanged += (sender, e) =>
{
string value = txtStartDate.Text;
if (string.IsNullOrEmpty(value)) //沒有資料就不作任何檢查。
return;
if (!DateTime.TryParse(value, out dt))
{
errProvier.SetError(txtStartDate, "日期格式錯誤。");
}
else
{
errProvier.Clear();
}
};
txtStartDate.KeyPress += (sender, e) =>
{
if (e.KeyChar.Equals((char)Keys.Return))
{
SchoolYearSemesterOption.Instance.StartDate = dt.StartOfWeek(DayOfWeek.Monday);
SchoolYearSemesterOption.Instance.EndDate = SchoolYearSemesterOption.Instance.StartDate.AddDays(6);
txtStartDate.Text = SchoolYearSemesterOption.Instance.StartDate.Month + "/" + SchoolYearSemesterOption.Instance.StartDate.Day;
CalendarEvents.RaiseWeekChangeEvent(this.Type,this.AssocID);
}
};
lblEndDate.BackgroundStyle.CornerType = DevComponents.DotNetBar.eCornerType.Square;
lblEndDate.Font = new System.Drawing.Font("新細明體", 13F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(136)));
lblEndDate.Location = new Point(420, 13);
lblEndDate.AutoSize = true;
pnlCalendarControl.Controls.Add(btnPrint);
pnlCalendarControl.Controls.Add(txtStartDate);
pnlCalendarControl.Controls.Add(lblName);
pnlCalendarControl.Controls.Add(lblEndDate);
pnlCalendarControl.Controls.Add(btnPrevious);
pnlCalendarControl.Controls.Add(btnCurrent);
pnlCalendarControl.Controls.Add(btnNext);
PanelEx pnlCalendarContent = new PanelEx();
pnlCalendarContent.Dock = DockStyle.Fill;
pnl.Controls.Add(pnlCalendarContent);
pnl.Controls.Add(pnlCalendarControl);
this.pnlContainer = pnlCalendarContent;
this.pnlContainer.Resize += (sender, e) => Resize();
this.cells = new Dictionary<string, DevComponents.DotNetBar.PanelEx>();
this.decPeriods = new Dictionary<string, DecPeriod>();
this.headerCells = new Dictionary<string, DevComponents.DotNetBar.PanelEx>();
ContextMenu Menu = new ContextMenu();
this.pnlContainer.ContextMenu = Menu;
Menu.Popup += Menu_Popup;
#endregion
#region 星期節次
Campus.Configuration.ConfigData config = Campus.Configuration.Config.User["CalendarOption"];
string vWeekday = config["Weekday"];
string vPeriods = config["PeriodList"];
if (!string.IsNullOrWhiteSpace(vWeekday))
this.weekday = K12.Data.Int.Parse(vWeekday);
else
this.weekday = 5;
this.periods = Utility.GetPeriodList(vPeriods);
this.RedrawGrid();
#endregion
}
public void validateReset(ErrorProvider err)
{
err.Clear();
}
