/// <summary> /// To Get LOCATION Classification /// </summary> /// <returns></returns> public LocationClassificationList GetLOCATIONClassification() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_LOCATIONCLS"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LocationClassificationBO BOobj = null; LocationClassificationList objlocation = new LocationClassificationList(); while (dr.Read()) { BOobj = new LocationClassificationBO(); BOobj.LOCTNCLASFCTNID = dr.GetInt32(dr.GetOrdinal("LOCTNCLASFCTNID")); BOobj.LOCTNCLASFCTNNAME = dr.GetString(dr.GetOrdinal("LOCTNCLASFCTNNAME")); BOobj.LOCTNCODE = dr.GetString(dr.GetOrdinal("LOCTNCODE")); BOobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted")); objlocation.Add(BOobj); } dr.Close(); return(objlocation); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = ""; LocationClassificationBLL BLLobj = null; try { BLLobj = new LocationClassificationBLL(); LocationClassificationBO BOobj = new LocationClassificationBO(); if (Convert.ToInt32(ViewState["LOCTNCLASFCTNID"]) > 0) { BOobj.LOCTNCLASFCTNID = Convert.ToInt32(ViewState["LOCTNCLASFCTNID"]); BOobj.LOCTNCLASFCTNNAME = txtLocation.Text.Trim(); BOobj.LOCTNCODE = txtcompland.Text.Trim(); BOobj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); message = BLLobj.UPDATElocation(BOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Updated Successfully"; } SetUpdateMode(false); } else { BOobj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); BOobj.LOCTNCLASFCTNNAME = txtLocation.Text.Trim(); BOobj.LOCTNCODE = txtcompland.Text.Trim(); message = BLLobj.INSERTlocation(BOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Saved Successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } clearfields(); BindGrid(true, true); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } }
/// <summary> /// To UPDATE location /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string UPDATElocation(LocationClassificationBO BOobj) { LocationClassificationDAL DALobj = new LocationClassificationDAL(); try { return(DALobj.UPDATElocation(BOobj)); } catch { throw; } finally { DALobj = null; } }
/// <summary> /// To INSERT location /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string INSERTlocation(LocationClassificationBO BOobj) { LocationClassificationDAL DALobj = new LocationClassificationDAL(); //Data pass -to Database Layer try { return(DALobj.INSERTlocation(BOobj)); } catch { throw; } finally { DALobj = null; } }
/// <summary> ///To fetch location details and assign to textbox /// </summary> private void Get_location_Details() { LocationClassificationBLL BLLobj = new LocationClassificationBLL(); int LOCTNCLASFCTNID = 0; if (ViewState["LOCTNCLASFCTNID"] != null) { LOCTNCLASFCTNID = Convert.ToInt32(ViewState["LOCTNCLASFCTNID"]); } LocationClassificationBO BOobj = new LocationClassificationBO(); BOobj = BLLobj.GetLOCTNCLASFCTNID(LOCTNCLASFCTNID); txtcompland.Text = BOobj.LOCTNCODE; txtLocation.Text = BOobj.LOCTNCLASFCTNNAME; }
/// <summary> /// To Get Location Classification ID /// </summary> /// <param name="LOCTNCLASFCTNID"></param> /// <returns></returns> public LocationClassificationBO GetLOCTNCLASFCTNID(int LOCTNCLASFCTNID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_LOCATION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("LOCTNCLASFCTNID_", LOCTNCLASFCTNID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LocationClassificationBO BOobj = null; LocationClassificationList listobj = new LocationClassificationList(); BOobj = new LocationClassificationBO(); while (dr.Read()) { if (ColumnExists(dr, "LOCTNCLASFCTNNAME") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCLASFCTNNAME"))) { BOobj.LOCTNCLASFCTNNAME = dr.GetString(dr.GetOrdinal("LOCTNCLASFCTNNAME")); } if (ColumnExists(dr, "LOCTNCODE") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCODE"))) { BOobj.LOCTNCODE = dr.GetString(dr.GetOrdinal("LOCTNCODE")); } if (ColumnExists(dr, "LOCTNCLASFCTNID") && !dr.IsDBNull(dr.GetOrdinal("LOCTNCLASFCTNID"))) { BOobj.LOCTNCLASFCTNID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LOCTNCLASFCTNID"))); } } dr.Close(); return(BOobj); }
/// <summary> /// To UPDATE location /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public string UPDATElocation(LocationClassificationBO BOobj) { string returnResult = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPD_LOCATION", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("LOCTNCLASFCTNID_", BOobj.LOCTNCLASFCTNID); dcmd.Parameters.Add("LOCTNCLASFCTNNAME_", BOobj.LOCTNCLASFCTNNAME); dcmd.Parameters.Add("LOCTNCODE_", BOobj.LOCTNCODE); dcmd.Parameters.Add("CREATEDBY_", BOobj.CREATEDBY); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } return(returnResult); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }