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); }