private void BTN_Limpiar_Click(object sender, RoutedEventArgs e)
{
Limpiar();
CBX_Costo.Text = "";
CBX_Estado.Text = "";
TXT_ID.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
if (TXT_ID.Text == String.Empty || TXT_PASS.Text == String.Empty || TXT_FULLNAME.Text == String.Empty || TXT_CONFORM_PASS.Text == String.Empty)
{
MessageBox.Show("يجب ادخال جميع البيانات صحيحه", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (TXT_PASS.Text != TXT_CONFORM_PASS.Text)
{
MessageBox.Show("كلمه السر غير متطابقه", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (BTM_SAVE.Text == "حفظ المستخدم")
{
LOG.ADD_USER(TXT_ID.Text, TXT_PASS.Text, TXT_USER_TYPE.Text, TXT_FULLNAME.Text);
MessageBox.Show("تمت الاضافه بنجاح", "اضافه مستخدم جديد", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (BTM_SAVE.Text == "تعديل المستخدم ")
{
LOG.EDIT_USER(TXT_ID.Text, TXT_PASS.Text, TXT_USER_TYPE.Text, TXT_FULLNAME.Text);
MessageBox.Show("تمت التعديل بنجاح", " تعديل بيانات مستخدم", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
TXT_ID.Clear();
TXT_CONFORM_PASS.Clear();
TXT_FULLNAME.Clear();
TXT_PASS.Clear();
TXT_ID.Focus();
}
private void BTN_Editar_Click(object sender, RoutedEventArgs e)
{
string RPT = "";
try
{
if (TXT_ID.Text == "" || TXT_numero.Text == "" || CBX_Estado.SelectedItem.ToString() == "" || TXT_ID_Cliente.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
RPT = N_Habitaciones.Editar(Convert.ToInt32(TXT_ID.Text), 0, Convert.ToInt32(CBX_Costo.Text), Convert.ToInt32(TXT_numero.Text), CBX_Estado.Text);
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se edito la habitacion", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
Limpiar();
TXT_numero.Focus();
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message, err.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void BTN_Eliminar_Click(object sender, RoutedEventArgs e)
{
if (TXT_ID.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
try
{
DialogResult resul = System.Windows.Forms.MessageBox.Show("Dese eliminar este empleado?\nLos cambios no se podran deshacer", "Hotel Royal S.V", (MessageBoxButtons)MessageBoxButton.YesNo, (MessageBoxIcon)MessageBoxImage.Warning);
if (resul == DialogResult.Yes)
{
string RPT = N_Empleado.Eliminar(Convert.ToInt32(TXT_ID.Text));
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se elimino el empleado", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
Limpiar();
ActualizarTabla = true;
}
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message);
}
}
}
private void BTN_Editar_Click(object sender, RoutedEventArgs e)
{
if (TXT_ID.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
try
{
string RPT = N_Empleado.Editar(Convert.ToInt32(TXT_ID.Text), TXT_Nombre.Text, TXT_Apellido.Text, Convert.ToInt32(TXT_Edad.Text), TXT_Correo.Text, TXT_Telefono.Text,
TXT_Celular.Text, TXT_Dui.Text, TXT_Nit.Text, TXT_Isss.Text, TXT_Usuario.Text, TXT_Contraseña.Text, TXT_Puesto.Text,
TXT_Departamento.Text);
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se actualiz el registro.", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
Limpiar();
ActualizarTabla = true;
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message);
}
}
}
public void RESET_CONTROLS()
{
TXT_NOMBRE.ResetText();
TXT_RFC.ResetText();
TXT_TELEFONO.ResetText();
TXT_CORREO.ResetText();
TXT_ID.ResetText();
}
public void RESET_CONTROLS()
{
TXT_GIRO.ResetText();
TXT_NOMBRE.ResetText();
TXT_RFC.ResetText();
TXT_TELEFONO.ResetText();
TXT_WEB_SITE.ResetText();
TXT_ID.ResetText();
}
public void LimpiarCampos()
{
TXT_ID.ResetText();
TXT_NAME.ResetText();
TXT_PASSWORD.ResetText();
TXT_USERNAME.ResetText();
C_ACTIVE_INACTIVE.CheckState = CheckState.Unchecked;
LlenarTabla();
}
private void BTN_Insertar_Click(object sender, RoutedEventArgs e)
{
Random random = new Random();
try
{
string RPT = "";
if (TXT_numero.Text == "" || CBX_Estado.SelectedItem.ToString() == "")
{
System.Windows.MessageBox.Show("Por favor, llene la informacion solicitada", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
TXT_ID.Focus();
}
else
{
A:
int id = random.Next(1, 100000);
DataTable exist = N_Random.Random_Exist("HABITACIONES", id);
if (exist.Rows.Count >= 1)
{
goto A;
}
else
{
if (TXT_numero.Text == "" || CBX_Estado.SelectedItem.ToString() == "" || CBX_Costo.SelectedItem.ToString() == "")
{
System.Windows.MessageBox.Show("Por favor, llenar los datos solicitados", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
RPT = N_Habitaciones.Insertar(id, 0, Convert.ToInt32(CBX_Costo.Text), Convert.ToInt32(TXT_numero.Text), Convert.ToString(CBX_Estado.Text));
}
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se inserto la habitacion", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
Limpiar();
TXT_numero.Focus();
}
}
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message, err.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void BTN_Anular_Click(object sender, RoutedEventArgs e)
{
if (TXT_ID.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
try
{
if (TXT_Puesto.Text == "")
{
BTN_Buscar_Click(null, e);
}
else
{
if (TXT_Puesto.Text == "Anulado")
{
TXT_Puesto.Focus();
TXT_Puesto.Select(0, 7);
}
else
{
string RPT = N_Empleado.Anular(Convert.ToInt32(TXT_ID.Text), "Anulado");
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se anulo el empleado", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
Limpiar();
ActualizarTabla = true;
}
}
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message);
}
}
}
private void BTN_Buscar_Click(object sender, RoutedEventArgs e)
{
try
{
if (TXT_ID.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
DataTable DAT = N_Habitaciones.Buscar_ID(Convert.ToInt32(TXT_ID.Text));
TXT_numero.Text = DAT.Rows[0][3].ToString();
CBX_Estado.Text = DAT.Rows[0][4].ToString();
CBX_Costo.Text = DAT.Rows[0][2].ToString();
TXT_ID_Cliente.Text = DAT.Rows[0][1].ToString();
}
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message, err.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void BTN_Eliminar_Click(object sender, RoutedEventArgs e)
{
DialogResult resul = System.Windows.Forms.MessageBox.Show("Desea anular esta habitacion?\nEsta accion se puede editar luego"
, "Hotel Royal S.V", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resul == DialogResult.Yes)
{
string RPT = "";
try
{
if (TXT_ID.Text == "")
{
Point relativePoint = IMG_Info.PointToScreen(new Point(0d, 0d));
TXT_ID.Focus();
System.Windows.Forms.Cursor.Position = new System.Drawing.Point(Convert.ToInt32(relativePoint.X), Convert.ToInt32(relativePoint.Y));
}
else
{
RPT = N_Habitaciones.Anular(Convert.ToInt32(TXT_ID.Text), "Inactivo");
if (RPT.Equals("OK"))
{
System.Windows.MessageBox.Show("Se deshabilito la habitacion", "Hotel Royal S.V", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
System.Windows.MessageBox.Show(RPT);
}
}
}
catch (Exception err)
{
System.Windows.MessageBox.Show(err.Message, err.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private void BTN_LOGIN_Click(object sender, EventArgs e)
{
try {
//단말기 초기 Load 시 창 호출하는 경우에는 전문처리
setWaitCursor(true);
if (m_bStart && !CHK_OFFLINE.Checked)
{
if (TXT_ID.Text == null || string.Empty.Equals(TXT_ID.Text.Trim())) // PASSWORD 아무것도 입력 안한 경우에는 return
{
setWaitCursor(false);
MetroMessageBox.Show(this, Constants.getMessage("EMPTY_ID"), "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TXT_ID.Focus();
return;
}
if (TXT_PASSWORD.Text == null || string.Empty.Equals(TXT_PASSWORD.Text.Trim())) // PASSWORD 아무것도 입력 안한 경우에는 return
{
setWaitCursor(false);
MetroMessageBox.Show(this, Constants.getMessage("EMPTY_PASSWORD"), "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TXT_PASSWORD.Focus();
return;
}
//창닫기
//m_strID = string.Empty.Equals(TEXT_ID.Text.Trim()) ? "User Name" : TEXT_ID.Text.Trim();
//m_strPassword = TEXT_PASSWORD.Text;
//this.Close();
//return;
UpdateProgressBar(10, Constants.getMessage("LOGIN_ID"));
Transaction login_tran = new Transaction();
JObject jsonRsult = login_tran.Login(TXT_ID.Text, TXT_PASSWORD.Text);
//로그인성공시
//사용자 정보 가져옴
if (jsonRsult != null && "S".Equals(jsonRsult["login"].ToString()))
{
UpdateProgressBar(20, Constants.getMessage("LOGIN_SHOP") /*"가맹점 정보 로딩 중"*/);
m_strID = string.Empty.Equals(TXT_ID.Text.Trim()) ? "User Name" : TXT_ID.Text.Trim();
m_strPassword = TXT_PASSWORD.Text;
Constants.USER_ID = m_strID;
Constants.CLOSING_YN = "Y".Equals(jsonRsult["closeYn"] == null ? "" : jsonRsult["closeYn"].ToString());//마감여부 추가
//위탁형
if (((JObject)jsonRsult["userInfo"])["deskId"] != null && !string.Empty.Equals(((JObject)jsonRsult["userInfo"])["deskId"].ToString()))
{
Constants.USER_AUTH = "01";
Constants.DESK_ID = ((JObject)jsonRsult["userInfo"])["deskId"].ToString();
}
//일반형
else
{
Constants.USER_AUTH = "02";
if (((JObject)jsonRsult["userInfo"])["merchantNo"] != null)
{
Constants.MERCHANT_NO = ((JObject)jsonRsult["userInfo"])["merchantNo"].ToString();
}
//if (((JObject)jsonRsult["userInfo"])["deskId"] != null)
// Constants.DESK_ID = "";
}
Constants.LOGGER_MAIN.Info(":start");
Boolean taxtypeColumn = Constants.SQLITE_MANAGER.ExitsTableColumn("MERCHANT", "TAX_TYPE");
if (!taxtypeColumn)
{
Constants.SQLITE_MANAGER.alterTable("MERCHANT", "TAX_TYPE");
}
Boolean CustomSendColumn = Constants.SQLITE_MANAGER.ExitsTableColumn("MERCHANT", "SEND_CUSTOM_FLAG");
if (!CustomSendColumn)
{
Constants.SQLITE_MANAGER.alterTable("MERCHANT", "SEND_CUSTOM_FLAG");
}
Boolean PermitNoColumn = Constants.SQLITE_MANAGER.ExitsTableColumn("REFUNDSLIP", "PERMIT_NO");
if (!PermitNoColumn)
{
Constants.SQLITE_MANAGER.alterTable("REFUNDSLIP", "PERMIT_NO");
}
Boolean NoteColumn = Constants.SQLITE_MANAGER.ExitsTableColumn("REFUNDSLIP", "REFUND_NOTE");
if (!NoteColumn)
{
Constants.SQLITE_MANAGER.alterTable("REFUNDSLIP", "REFUND_NOTE");
}
//가맹점정보
login_tran.SearchUserInfo(((JObject)jsonRsult["userInfo"])["userId"].ToString(), Constants.MERCHANT_NO
, Constants.DESK_ID, "merchant");
Constants.LOGGER_MAIN.Info(":merchant");
//최초 로그인 시에는 CODE 테이블 있는지 확인하고 있으면 여기서 업데이트. 있으면 한행씩 업데이트
if (!Constants.SQLITE_MANAGER.ExitsTable("CODE"))
{
UpdateProgressBar(40, Constants.getMessage("LOGIN_CODE"));
login_tran.SearchUserInfo(Constants.USER_ID, Constants.MERCHANT_NO, Constants.DESK_ID, "code");
Constants.CODE_DOWNLOAD = true;
}
Constants.LOGIN_YN = true;
//item
UpdateProgressBar(60, Constants.getMessage("LOGIN_ITEM"));
login_tran.SearchUserInfo(((JObject)jsonRsult["userInfo"])["userId"].ToString(), Constants.MERCHANT_NO
, Constants.DESK_ID, "item");
DateTime.Now.ToString("[yyyy/MM/dd HH:mm:ss.mmm]");
Constants.LOGGER_MAIN.Info(":item");
//세무서리스트
UpdateProgressBar(80, Constants.getMessage("LOGIN_CUSTOMS"));
login_tran.SearchUserInfo(((JObject)jsonRsult["userInfo"])["userId"].ToString(), Constants.MERCHANT_NO
, Constants.DESK_ID, "taxoffice");
DateTime.Now.ToString("[yyyy/MM/dd HH:mm:ss.mmm]");
Constants.LOGGER_MAIN.Info(":taxoffice");
//ads
UpdateProgressBar(90, Constants.getMessage("LOGIN_ADS"));
login_tran.SearchUserInfo(((JObject)jsonRsult["userInfo"])["userId"].ToString(), Constants.MERCHANT_NO
, Constants.DESK_ID, "ads");
DateTime.Now.ToString("[yyyy/MM/dd HH:mm:ss.mmm]");
Constants.LOGGER_MAIN.Info(":ads");
UpdateProgressBar(100, Constants.getMessage("LOGIN_END"));
/*
*/
setWaitCursor(false);
this.Close();
}
else
{
Control tempCon = this.ActiveControl;//직전 포커스 가지고 있는 컨트롤 저장
setWaitCursor(false);
string strErrMsg = "";
if (jsonRsult != null && "F".Equals(jsonRsult["login"].ToString()) && jsonRsult["login_msg"] != null)
{
strErrMsg = jsonRsult["login_msg"].ToString();
}
else
{
strErrMsg = Constants.getMessage("ERROR_LOGIN");
}
//실패 시
MetroMessageBox.Show(this, strErrMsg, "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
UpdateProgressBar(0, Constants.getMessage("LOGIN_BEFORE"));
if (tempCon != null)//포커스 복귀
{
tempCon.Focus();
}
return;
}
}
else //사용중 로그인창 뜬 경우에는 password 검증 처리
{
string strPassword = TXT_PASSWORD.Text;
if (strPassword == null || string.Empty.Equals(strPassword.Trim())) // PASSWORD 아무것도 입력 안한 경우에는 return
{
setWaitCursor(false);
MetroMessageBox.Show(this, Constants.getMessage("EMPTY_PASSWORD"), "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
TXT_PASSWORD.Focus();
return;
}
if (strPassword.Equals(m_strPassword))
{
//로그인성공
}
else
{
Control tempCon = this.ActiveControl; //직전 포커스 가지고 있는 컨트롤 저장
//로그인실패
MetroMessageBox.Show(this, Constants.getMessage("ERROR_LOGIN"), "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (tempCon != null) //포커스 복귀
{
tempCon.Focus();
}
}
}
}catch (Exception ex)
{
Constants.LOGGER_MAIN.Info(ex.Message);
MetroMessageBox.Show(this, Constants.getMessage("ERROR_LOGIN_CRITICAL"), "Loigin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Visible = false;
Application.ExitThread();
Environment.Exit(0);
}
finally
{
setWaitCursor(false);
}
}
private void BTN_Limpiar_Click(object sender, RoutedEventArgs e)
{
Limpiar();
TXT_ID.Focus();
}
