private void updateLocation()
{
try
{
string query = @"
UPDATE [dbo].[MST_Location]
SET [Location_Name] =@location_name
,[Lattitude] = @lattitude
,[Longitude] = @longitude
,[Radius] = @radius
,[Location_Desc] = @location_desc
,[is_active] = @is_acitve
WHERE location_id = @location_id";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@location_name", txtLocationName.Text);
cmd.Parameters.AddWithValue("@lattitude", txtLatitude.DoubleValue);
cmd.Parameters.AddWithValue("@longitude", txtLongitude.DoubleValue);
cmd.Parameters.AddWithValue("@Radius", txtRadius.IntegerValue);
cmd.Parameters.AddWithValue("@location_desc", txtLocationDesc.Text);
cmd.Parameters.AddWithValue("@is_acitve", chkBoxActive.Checked);
cmd.Parameters.AddWithValue("@location_id", loc_id);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void insertPEA()
{
DateTime now = ClsUtil.getCurrentDate();
var password = EncodeDecode.Encrypt(txtPassword.Text);
var unitId = cmbUnit.SelectedValue;
var positionId = cmbPosition.SelectedValue;
var gender = cmbGender.Text;
try
{
string query = @"
INSERT INTO [dbo].[Employees]
([Employee_Number]
,[Employee_Name]
,[Gender]
,[Hire_Date]
,[Birth_Date]
,[Unit_Id]
,[Position_id]
,[created_date]
,[created_by]
,[Password])
VALUES
(@Employee_Number
,@Employee_Name
,@Gender
,@Hire_Date
,@Birth_Date
,@Unit_Id
,@Position_id
,@created_date
,@created_by
,@Password)";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@Employee_Number", txtEmployeeNumber.IntegerValue);
cmd.Parameters.AddWithValue("@Employee_Name", txtEmployeeName.Text);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@Hire_Date", dtHireDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Birth_Date", dtBirthDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Unit_Id", unitId);
cmd.Parameters.AddWithValue("@Position_id", positionId);
cmd.Parameters.AddWithValue("@created_date", ClsUtil.currentDateTime);
cmd.Parameters.AddWithValue("@created_by", ClsUtil.userLogin);
cmd.Parameters.AddWithValue("@Password", password);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void updatePEA()
{
var password = EncodeDecode.Encrypt(txtPassword.Text);
var unitId = cmbUnit.SelectedValue;
var positionId = cmbPosition.SelectedValue;
var gender = cmbGender.Text;
var dateTimeNow = ClsUtil.getCurrentDate();
try
{
string query = @"
UPDATE [dbo].[Employees]
SET [Employee_Number] =@Employee_Number
,[Employee_Name] = @Employee_Name
,[Gender] = @Gender
,[Hire_Date] =@Hire_Date
,[Birth_Date] =@Birth_Date
,[Unit_Id] = @Unit_Id
,[Position_id] = @Position_id
,[Password] = @Password
,[updated_date] = @updated_date
,[updated_by] = @updated_by
WHERE Employee_id = @emp_id ";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@Employee_Number", txtEmployeeNumber.IntegerValue);
cmd.Parameters.AddWithValue("@Employee_Name", txtEmployeeName.Text);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@Hire_Date", dtHireDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Birth_Date", dtBirthDate.Value.ToShortDateString());
cmd.Parameters.AddWithValue("@Unit_Id", unitId);
cmd.Parameters.AddWithValue("@Position_id", positionId);
cmd.Parameters.AddWithValue("@Password", password);
cmd.Parameters.AddWithValue("@updated_date", ClsUtil.currentDateTime);
cmd.Parameters.AddWithValue("@updated_by", ClsUtil.userLogin);
cmd.Parameters.AddWithValue("@emp_id", empId);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
private void insertLocation()
{
try
{
string query = @"INSERT INTO [dbo].[MST_Location]
([Location_Name]
,[Lattitude]
,[Longitude]
,[Radius]
,[Location_Desc]
,[is_active])
VALUES
(@location_name
, @latitude
, @longitude
, @radius
, @location_desc
, @is_acitve)";
using (SqlCommand cmd = new SqlCommand(query, ConnUtil.connection))
{
cmd.Parameters.AddWithValue("@location_name", txtLocationName.Text);
cmd.Parameters.AddWithValue("@latitude", txtLatitude.DoubleValue);
cmd.Parameters.AddWithValue("@longitude", txtLongitude.DoubleValue);
cmd.Parameters.AddWithValue("@Radius", txtRadius.IntegerValue);
cmd.Parameters.AddWithValue("@Location_Desc", txtLocationDesc.Text);
cmd.Parameters.AddWithValue("@is_acitve", true);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
MsgBoxUtil.MsgSuccessSave();
}
}
catch (Exception ex)
{
MsgBoxUtil.MsgError(ex.Message);
}
}
