public static DataTable SearchEmployee(ATTOrgUnitHead objOrgUnitHead)
{
try
{
string strSelect = "";
strSelect = "SELECT * FROM VW_EMP_ORG_UNIT_HEAD WHERE 1=1 ";
List <OracleParameter> ParamList = new List <OracleParameter>();
if (objOrgUnitHead.OrgID > 0)
{
strSelect += "AND ORG_ID = :OrgID";
ParamList.Add(Utilities.GetOraParam(":OrgID", objOrgUnitHead.OrgID, OracleDbType.Int64, ParameterDirection.Input));
}
strSelect += " ORDER BY ORG_ID";
GetConnection conn = new GetConnection();
OracleConnection obj = conn.GetDbConn(Module.PMS);
DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.Text, strSelect, ParamList.ToArray());
return((DataTable)ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveOrgUnitHead(ATTOrgUnitHead att)
{
try
{
return(DLLOrgUnitHead.SaveOrgUnitHead(att));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTOrgUnitHead> SearchEmployee(ATTOrgUnitHead objOrgUnitHead)
{
List <ATTOrgUnitHead> lstOUH = new List <ATTOrgUnitHead>();
ATTOrgUnitHead attOUH;
foreach (DataRow row in DLLOrgUnitHead.SearchEmployee(objOrgUnitHead).Rows)
{
attOUH = new ATTOrgUnitHead();
attOUH.OrgID = int.Parse(row["ORG_ID"].ToString());
attOUH.UnitID = int.Parse(row["UNIT_ID"].ToString());
attOUH.UnitName = row["UNIT_NAME"].ToString();
attOUH.EmpID = int.Parse(row["EMP_ID"].ToString());
attOUH.EmpName = row["FIRST_NAME"].ToString() + " " + row["MID_NAME"].ToString() + "" + row["SUR_NAME"].ToString();
attOUH.FromDate = row["FROM_DATE"].ToString();
attOUH.ToDate = row["TO_DATE"].ToString();
attOUH.UnitHead = row["UNIT_HEAD"].ToString();
attOUH.OfficeHead = row["OFFICE_HEAD"].ToString();
lstOUH.Add(attOUH);
}
return(lstOUH);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (DDLUnit.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "कृप्या शाखा छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (grdEmployee.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "कृप्या कर्मचारी छान्नुहोस्";
this.programmaticModalPopup.Show();
return;
}
if (txtFromDate.Text == "")
{
this.lblStatusMessage.Text = "कृप्या ञवधि देखि राखनुहोस्";
this.programmaticModalPopup.Show();
return;
}
ATTOrgUnitHead att = new ATTOrgUnitHead();
att.OrgID = int.Parse(grdEmployee.SelectedRow.Cells[0].Text);
att.UnitID = int.Parse(DDLUnit.SelectedValue.ToString());
att.EmpID = double.Parse(grdEmployee.SelectedRow.Cells[1].Text);
att.FromDate = txtFromDate.Text;
att.UnitHead = chkUnitHead.Checked == true ? "Y" : "N";
att.OfficeHead = chkOfficeHead.Checked == true ? "Y" : "N";
att.EntryBY = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
att.Action = "A";
if (BLLOrgUnitHead.SaveOrgUnitHead(att))
{
ClearControls();
lblStatusMessage.Text = "Saved Successfully";
programmaticModalPopup.Show();
}
}
public static bool SaveOrgUnitHead(ATTOrgUnitHead objOrgUnitHead)
{
OracleTransaction Tran;
GetConnection conn = new GetConnection();
OracleConnection DBConn = conn.GetDbConn(Module.PMS);
Tran = DBConn.BeginTransaction();
try
{
string InsertUpdateDLSP = "";
if (objOrgUnitHead.Action == "A")
{
InsertUpdateDLSP = "SP_ADD_ORG_UNIT_HEAD";
}
//else if (objOrgUnitHead.Action == "E")
// InsertUpdateDLSP = "SP_EDIT_ORG_UNIT_HEAD";
OracleParameter[] paramArray = new OracleParameter[8];
paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objOrgUnitHead.OrgID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_UNIT_ID", objOrgUnitHead.UnitID, OracleDbType.Int32, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":P_EMP_ID", objOrgUnitHead.EmpID, OracleDbType.Double, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_FROM_DATE", objOrgUnitHead.FromDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_TO_DATE", objOrgUnitHead.ToDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":P_UNIT_HEAD", objOrgUnitHead.UnitHead, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":P_OFFICE_HEAD", objOrgUnitHead.OfficeHead, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":P_ENTRY_BY", objOrgUnitHead.EntryBY, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
Tran.Commit();
return(true);
}
