public List <ATTEmployee> GetEmployeeDetails(string EmployeeId)
{
List <ATTEmployee> lst = new List <ATTEmployee>();
DataSet ds = new DataSet();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@EmployeeId", EmployeeId);
ds = DAO.gettable("Usp_GetEmployeeDetails", param);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ATTEmployee objATT = new ATTEmployee();
objATT.EmployeeId = Convert.ToInt32(dr["EmployeeId"]);
objATT.Name = dr["Name"].ToString();
objATT.Gender = dr["Gender"].ToString();
objATT.DOB = dr["DOB"].ToString();
objATT.Salary = dr["Salary"].ToString();
lst.Add(objATT);
}
}
return(lst);
}
public static ATTEmployee GetEmployees(double empID, string symbolNo)
{
ATTEmployee emp = new ATTEmployee();
object obj;
try
{
obj = DLLEmployee.GetConnection();
emp.LstEmployeeVisits = BLLEmployeeVisits.GetEmployeeVisits(obj, empID);
emp.LstEmployeeExperience = BLLEmployeeExperience.GetEmployeeExperience(obj, empID);
emp.LstEmployeePosting = BLLEmployeePosting.GetEmployeeAllPosting(obj, empID);
//emp.LSTAttachments = BLLPersonAttachments.GetAttachments(obj, empID);
emp.LstEmployeePublication = BLLEmployeePublication.GetEmployeePublication(empID, obj);
emp.LstEmpRelativeBeneficiary = BLLVwEmpRelativeBeneficiary.GetEmpRelativeBeneficiary(empID, obj);
emp.LstInsurance = BLLInsurance.GetEmpInsurance(empID);
emp.LSTEmpDeputation = BLLEmployeeDeputation.GetEmpForDeputationInfo(null, "Y", empID);
emp.LstManonayan = BLLManonayan.GetManonayan(empID);
emp.ObjPerson = BLLPerson.GetPersonnelDetails(obj, empID);
return(emp);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DLLEmployee.CloseConnection();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string msg = "";
BLLEmployee objbllEmployee = new BLLEmployee();
ATTEmployee objEmployee = new ATTEmployee();
objEmployee.EmpID = int.Parse(txtEmpID.Text.ToString());
objEmployee.EmpName = TextBox0.Text;
objEmployee.EmpEmail = TextBox1.Text;
objEmployee.EmpAddress = TextBox2.Text;
objEmployee.EmpPhone = TextBox3.Text;
if (lblAction.Text == "E")
{
objEmployee.Action = "E";
}
else
{
objEmployee.Action = "A";
}
msg = objbllEmployee.SaveEmployee(objEmployee);
lblmsg.Text = msg;
txtEmpID.Text = "";
TextBox0.Text = "";
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
lblmsg.Text = "";
lblAction.Text = "";
lblStatusMessage.Text = "";
}
public List <ATTEmployee> GetEmployee()
{
List <ATTEmployee> lstEmp = new List <ATTEmployee>();
DataSet ds = new DataSet();
ds = DAO.gettable("Usp_GetEmployee", null);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ATTEmployee objATT = new ATTEmployee();
objATT.EmployeeId = Convert.ToInt32(dr["EmployeeId"]);
objATT.Name = dr["Name"].ToString();
objATT.Gender = dr["Gender"].ToString();
objATT.DOB = dr["DOB"].ToString();
objATT.Salary = dr["Salary"].ToString();
lstEmp.Add(objATT);
}
}
return(lstEmp);
}
public object SaveEmployee(string args)
{
JsonResponse response = new JsonResponse();
ATTEmployee objATT = JsonUtility.DeSerialize(args, typeof(ATTEmployee)) as ATTEmployee;
BLLEmployee bllObj = new BLLEmployee();
response = bllObj.SaveEmployee(objATT);
return(JsonUtility.Serialize(response));
}
public string SaveEmployee(ATTEmployee objEmp)
{
string msg = "";
SqlConnection conn = DAO.conn();
using (conn)
{
SqlTransaction tran;
tran = conn.BeginTransaction();
try
{
SqlCommand cmd;
if (objEmp.Action != null)
{
if (objEmp.Action == "E")
{
cmd = new SqlCommand("Usp_UpdateEmployee", conn, tran);
}
else
{
cmd = new SqlCommand("Usp_InsertEmployee", conn, tran);
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeeId", SqlDbType.Int).Value = objEmp.EmployeeId;
cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = objEmp.Name;
cmd.Parameters.Add("@DOB", SqlDbType.VarChar, 50).Value = objEmp.DOB;
cmd.Parameters.Add("@Gender", SqlDbType.VarChar, 50).Value = objEmp.Gender;
cmd.Parameters.Add("@Salary", SqlDbType.VarChar, 50).Value = objEmp.Salary;
cmd.ExecuteNonQuery();
//if (objEmp.Action == "A")
{
foreach (var item in objEmp.Qualification)
{
item.EmployeeId = objEmp.EmployeeId;
}
DLLQualification dllQualification = new DLLQualification();
dllQualification.SaveQualification(objEmp.Qualification, conn, tran);
}
tran.Commit();
}
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception("Error" + ex.Message);
}
return(msg);
}
}
public static bool SaveEmployeeDetails(ATTEmployee objEmployee)
{
try
{
return(DLLEmployee.SaveEmployeeDetails(objEmployee));
}
catch (Exception ex)
{
throw ex;
}
}
public string SaveEmployee(ATTEmployee objEmployee)
{
string msg = "";
try
{
DLLEmployee dlEmployee = new DLLEmployee();
msg = dlEmployee.SaveEmployee(objEmployee);
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
public static List <ATTEmployee> GetEmployeeList()
{
List <ATTEmployee> LSTEmp = new List <ATTEmployee>();
try
{
foreach (DataRow rw in DLLEmployee.GetEmployeeList().Rows)
{
ATTEmployee obj = new ATTEmployee();
obj.SymbolNo = rw["SYMBOL_NO"].ToString();
obj.OrgEmpNo = rw["ORG_EMP_NO"].ToString();
LSTEmp.Add(obj);
}
return(LSTEmp);
}
catch (Exception)
{
throw;
}
}
public JsonResponse SaveEmployee(ATTEmployee objATT)
{
JsonResponse response = new JsonResponse();
try
{
DLLEmployee objDLL = new DLLEmployee();
response.ResponseData = objDLL.SaveEmployee(objATT);
response.IsSuccess = true;
}
catch (Exception ex)
{
response.ResponseData = ex.Message;
response.IsSuccess = false;
}
return(response);
}
public static List <ATTEmployeePosting> GetEmpPosting(double empID)
{
ATTEmployee emp = new ATTEmployee();
object obj;
try
{
obj = DLLEmployee.GetConnection();
emp.LstEmployeePosting = BLLEmployeePosting.GetEmployeePosting(obj, empID);
return(emp.LstEmployeePosting);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DLLEmployee.CloseConnection();
}
}
public string SaveEmployee(ATTEmployee objEmployee)
{
string sp = "";
string msg = "No Data To Save!!!";
if (objEmployee.Action == "A")
{
sp = "dbo.ups_Employee_Save";
msg = "Successfully Saved.";
}
else if (objEmployee.Action == "E")
{
sp = "dbo.ups_Employee_Edit";
msg = "Successfully Edited.";
}
string connectionstring = ConfigurationManager.ConnectionStrings["MIS_VersionMConnectionString"].ConnectionString;
SqlConnection connect = new SqlConnection(connectionstring);
try
{
connect.Open();
SqlCommand cmd = new SqlCommand(sp, connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmpID", SqlDbType.Int, 50).Value = objEmployee.EmpID;
cmd.Parameters.Add("@EmpName", SqlDbType.VarChar, 50).Value = objEmployee.EmpName;
cmd.Parameters.Add("@EmpEmail", SqlDbType.VarChar, 50).Value = objEmployee.EmpEmail;
cmd.Parameters.Add("@EmpAddress", SqlDbType.VarChar, 50).Value = objEmployee.EmpAddress;
cmd.Parameters.Add("@EmpPhone", SqlDbType.VarChar, 50).Value = objEmployee.EmpPhone;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
{
connect.Close();
}
return(msg);
}
public List <ATTEmployee> GetEmployee(int?empID)
{
string connectionstring = ConfigurationManager.ConnectionStrings["MIS_VersionMConnectionString"].ConnectionString;
SqlConnection connect = new SqlConnection(connectionstring);
List <ATTEmployee> lst = new List <ATTEmployee>();
DataSet ds = new DataSet();
try
{
connect.Open();
SqlCommand cmd = new SqlCommand("dbo.usp_Employee_Select", connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmpID", SqlDbType.Int).Value = empID;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "Employee");
foreach (DataRow drow in ds.Tables[0].Rows)
{
ATTEmployee obj = new ATTEmployee();
obj.EmpID = Int32.Parse(drow["EmpID"].ToString());
obj.EmpName = drow["EmpName"].ToString();
obj.EmpEmail = drow["EmpEmail"].ToString();
obj.EmpAddress = drow["EmpAddress"].ToString();
obj.EmpPhone = drow["EmpPhone"].ToString();
obj.Action = "";
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
connect.Close();
}
}
public static bool SaveEmployeeDetails(ATTEmployee objEmployee)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction();
double employeeID;
//double relativeID = 0;
try
{
employeeID = DLLPerson.AddPersonnelDetails(objEmployee.ObjPerson, Tran);
OracleParameter[] paramArray = new OracleParameter[7];
paramArray[0] = Utilities.GetOraParam(":p_EMP_ID", employeeID, OracleDbType.Double, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":p_SYMBOL_NO", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_ORG_EMP_NO", objEmployee.OrgEmpNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":p_IDENTITY_MARK", objEmployee.IdentityMark, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_ENTRY_BY", objEmployee.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_PF_NO", objEmployee.PFNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_CIT_NO", objEmployee.CitznNo, OracleDbType.Varchar2, ParameterDirection.Input);
if (objEmployee.EmpID == 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_ADD_EMPLOYEES", paramArray[0], paramArray);
}
else if (objEmployee.EmpID > 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_EDIT_EMPLOYEES", paramArray[0], paramArray);
}
if (objEmployee.LstEmployeeVisits.Count > 0)
{
DLLEmployeeVisits.AddEmployeeVisits(objEmployee.LstEmployeeVisits, Tran, employeeID);
}
if (objEmployee.LstEmployeeExperience.Count > 0)
{
DLLEmployeeExperience.AddEmployeeExperiences(objEmployee.LstEmployeeExperience, Tran, employeeID);
}
if (objEmployee.LstEmployeePosting.Count > 0)
{
DLLEmployeePosting.SaveEmployeePosting(objEmployee.LstEmployeePosting, Tran, employeeID);
}
if (objEmployee.LstEmployeePublication.Count > 0)
{
DLLEmployeePublication.AddEmployeePublication(objEmployee.LstEmployeePublication, Tran, employeeID);
}
if (objEmployee.LstEmployeeBeneficiary.Count > 0)
{
DLLEmployeeBeneficiary.SaveBeneficiary(objEmployee.LstEmployeeBeneficiary, Tran, employeeID);
}
if (objEmployee.LstInsurance.Count > 0)
{
DLLInsurance.SaveEmpInsurance(objEmployee.LstInsurance, Tran, employeeID);
}
if (objEmployee.LSTAttachments.Count > 0)
{
DLLPersonAttachments.SaveAttachments(objEmployee.LSTAttachments, Tran, employeeID);
}
if (objEmployee.ObjUser.Username != "" && objEmployee.ObjUser.Password != "")
{
DLLUsers.SaveUsers(objEmployee.ObjUser, Tran, employeeID);
}
if (objEmployee.OrgUser.Username != "")
{
DLLOrganizationUSers.SaveOrganizationUsers(objEmployee.OrgUser, Tran, employeeID);
}
if (objEmployee.LSTEmpDeputation != null)
{
DLLEmployeeDeputation.SaveEmpployeeDeputation(objEmployee.LSTEmpDeputation, Tran, employeeID);
}
if (objEmployee.LstManonayan.Count > 0)
{
DLLManonayan.SaveManonayan(objEmployee.LstManonayan, Tran, employeeID);
}
objEmployee.EmpID = employeeID;
Tran.Commit();
return(true);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
