public Exploit(GetConnection getconn, string package, string appkeypath) { _vita = new Vita(getconn, INSTALL_NAME, package, appkeypath); }
public object Get(GetConnection request) { return new GetConnectionResponse { Host = Redis.Host, Port = Redis.Port, Db = (int)Redis.Db, }; }
public static bool UpdateAppointmentEvents(ATTAppointment objAppointment) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); string updateSQL = "SP_EDIT_APPOINTMENT"; int countAppointee = objAppointment.LstAppointee.Count; OracleParameter[] paramArray = new OracleParameter[11]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objAppointment.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_APPOINTMENT_ID", objAppointment.AppointmentID, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[2] = Utilities.GetOraParam(":P_APPOINTMENT_CALLED_BY", objAppointment.AppointmentCalledBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":P_APPOINTMENT_SUBJECT", objAppointment.AppointmentSubject, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_APPOINTMENT_DATE", objAppointment.AppointmentDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_START_TIME", objAppointment.StartTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_END_TIME", objAppointment.EndTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_VENUE", objAppointment.Venue, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_STATUS", objAppointment.Status, OracleDbType.Int64, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", null, OracleDbType.Date, ParameterDirection.Input); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, updateSQL, paramArray); if (countAppointee > 0) { DLLAppointee.UpdateAppointee(objAppointment, Tran); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
public static bool AddEditDeleteLitigantSubType(ATTLitigantSubType litigantSubType) { string InsertUpdateDeleteSQL = ""; GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.CMS); try { if (litigantSubType.Action == "A") { InsertUpdateDeleteSQL = "SP_ADD_LITIGANT_SUB_TYPE"; } else if (litigantSubType.Action == "E") { InsertUpdateDeleteSQL = "SP_EDIT_LITIGANT_SUB_TYPE"; } else if (litigantSubType.Action == "D") { InsertUpdateDeleteSQL = "SP_DEL_LITIGANT_SUB_TYPE"; } OracleParameter[] ParamArray; if (litigantSubType.Action == "A" || litigantSubType.Action == "E") { ParamArray = new OracleParameter[4]; ParamArray[0] = FRAMEWORK.Utilities.GetOraParam(":P_LITIGANT_SUB_TYPE_ID", litigantSubType.LitigantSubTypeID, OracleDbType.Int64, ParameterDirection.InputOutput); ParamArray[1] = FRAMEWORK.Utilities.GetOraParam(":P_LITIGANT_SUB_TYPE_NAME", litigantSubType.LitigantSubTypeName, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[2] = FRAMEWORK.Utilities.GetOraParam(":P_ACTIVE", litigantSubType.Active, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[3] = FRAMEWORK.Utilities.GetOraParam(":P_ENTRY_BY", litigantSubType.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertUpdateDeleteSQL, ParamArray); litigantSubType.LitigantSubTypeID = int.Parse(ParamArray[0].Value.ToString()); litigantSubType.Action = ""; } return(true); } catch (Exception ex) { throw ex; } finally { GetConn.CloseDbConn(); } }
public void Receive(string[] args) { var conn = new GetConnection(); conn.MqHandle((connection, channel) => { //声明一个名为logs的交换机 channel.ExchangeDeclare(exchange: "Topic_logs", type: "topic", durable: true, autoDelete: false, null); //创建一个随机队列 var queryName = channel.QueueDeclare(queue: string.Empty, durable: true, exclusive: false, autoDelete: true).QueueName; foreach (var arg in args) { //队列绑定到交换机logs channel.QueueBind(queue: queryName, exchange: "Topic_logs", routingKey: arg); } Console.WriteLine(" [*] Waiting for messages."); //channel.BasicQos(prefetchSize: 0, prefetchCount: 1, global: false); //接下来我们通知服务器可以将消息从队列里发送过来了。由于服务器会异步地将消息推送给我们,所以我们这里提供一个回调方法。这就是EventingBasicConsumer.Receivedevent所做的工作。 var consumer = new EventingBasicConsumer(channel); consumer.Received += (conn, ea) => { var body = ea.Body.Span; var message = Encoding.UTF8.GetString(body); var routingKey = ea.RoutingKey; Console.WriteLine(" [x] Received '{0}':'{1}'", routingKey, message); }; ///param1:消费哪个队列的消息 队列名称 ///param2:开始消息的自动确认机制 ///param3;消费时的回调接口 channel.BasicConsume(queue: queryName, autoAck: false, consumer: consumer); Console.WriteLine(" Press [enter] to exit."); Console.ReadLine(); }); }
public static bool SaveOrgItems(List <ATTInvOrgItems> lstItems) { GetConnection getConn = new GetConnection(); OracleConnection DBConn = getConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { foreach (ATTInvOrgItems obj in lstItems) { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_org_id", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_id", obj.ItemsID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_quantity", obj.Quantity, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_p_ji_kha_pa_no", obj.PanNo, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (obj.Action == "A") //New Add { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "sp_inv_add_org_items", paramArray.ToArray()); } else if (obj.Action == "E") //Update { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "sp_inv_edit_org_items", paramArray.ToArray()); } obj.ItemsID = int.Parse(paramArray[0].Value.ToString()); paramArray.Clear(); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { getConn.CloseDbConn(); } }
public static List <TareaMecanicosAyudanteList> ListTareaMecanicosAyudante(int IdTareaMecanicos, string CodMecanico = "") { List <TareaMecanicosAyudanteList> List = new List <TareaMecanicosAyudanteList>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_tb_tareamecanicos_ayudante_List", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pIdTareaMecanicos", SqlDbType.Int).Value = IdTareaMecanicos; cmd.Parameters.Add("@pcodmecanico", SqlDbType.VarChar).Value = CodMecanico; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new TareaMecanicosAyudanteList { IdAyudante = DataReader.GetIntValue(dr, "IdAyudante"), IdTareaMecanicos = DataReader.GetIntValue(dr, "IdTareaMecanicos"), CodMecanico = DataReader.GetStringValue(dr, "CodMecanico"), Observacion = DataReader.GetStringValue(dr, "Observacion") }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static bool SaveCaseAccountMaster(ATTCaseAccountMaster attCAM) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); string InsertUpdateSQL = "SP_ADD_CASE_ACCOUNT_MASTER"; try { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_CASE_ID", attCAM.CaseID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_TRAN_DATE", attCAM.TransactionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_TRAN_SEQ", attCAM.TransactionSequence, OracleDbType.Int64, ParameterDirection.InputOutput)); if (attCAM.LitigantID == 0) { paramArray.Add(Utilities.GetOraParam(":P_LITIGANT_ID", null, OracleDbType.Double, ParameterDirection.Input)); } else { paramArray.Add(Utilities.GetOraParam(":P_LITIGANT_ID", attCAM.LitigantID, OracleDbType.Double, ParameterDirection.Input)); } if (attCAM.AttorneyID == 0) { paramArray.Add(Utilities.GetOraParam(":P_ATTORNEY_ID", null, OracleDbType.Double, ParameterDirection.Input)); } else { paramArray.Add(Utilities.GetOraParam(":P_ATTORNEY_ID", attCAM.AttorneyID, OracleDbType.Double, ParameterDirection.Input)); } paramArray.Add(Utilities.GetOraParam(":P_REMARKS", attCAM.Remarks, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", attCAM.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_OLD_TRAN_DATE", null, OracleDbType.Varchar2, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); DLLCaseAccountDetails.SaveCaseAccountDetail(attCAM.LstAccountDetails, Tran); DLLCaseAccountForward.SaveCaseAccountForward(attCAM.LstAccountForward, Tran, attCAM.CaseID); Tran.Commit(); return(true); } catch (Exception ex) { throw ex; } }
public static DataTable GetEmployeeRetirement(ATTRetirement objRetirement, string opt) { try { List <OracleParameter> ParamList = new List <OracleParameter>(); string select = ""; if (opt == "appl" || opt == "dec") { select = "SELECT * FROM VW_EMP_RETIREMENT WHERE 1=1 "; if (objRetirement.isDecided != "") { select += " AND IS_DECIDED=:IsDecided"; ParamList.Add(Utilities.GetOraParam(":IsDecided", objRetirement.isDecided, OracleDbType.Varchar2, ParameterDirection.Input)); } if (objRetirement.isApproved != "") { select += " AND IS_APPROVED=:IsApproved"; ParamList.Add(Utilities.GetOraParam(":IsApproved", objRetirement.isApproved, OracleDbType.Varchar2, ParameterDirection.Input)); } } else if (opt == "appr") { select = "SELECT * FROM VW_EMP_RETIREMENT WHERE 1=1 "; if (objRetirement.isDecided != "") { select += " AND IS_DECIDED=:IsDecided"; ParamList.Add(Utilities.GetOraParam(":IsDecided", objRetirement.isDecided, OracleDbType.Varchar2, ParameterDirection.Output)); } if (objRetirement.isApproved != "") { select += " AND IS_APPROVED=:IsApproved"; ParamList.Add(Utilities.GetOraParam(":IsApproved", objRetirement.isApproved, OracleDbType.Varchar2, ParameterDirection.Output)); } } GetConnection conn = new GetConnection(); OracleConnection obj = conn.GetDbConn(Module.PMS); DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.Text, select, ParamList.ToArray()); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public static DataTable SearchItemsKNJ(ATTInvOrgItemsKNJ obj) { try { string strSelect = ""; strSelect = "SELECT * FROM VW_INV_ORG_ITEMS_KNJ WHERE ITEMS_STATUS='S' "; List <OracleParameter> ParamList = new List <OracleParameter>(); if (obj.OrgID > 0) { strSelect += " AND ORG_ID = :itmOrgID"; ParamList.Add(Utilities.GetOraParam(":itmOrgID", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsCategoryID > 0) { strSelect += " AND ITEMS_CATEGORY_ID = :itmCatID"; ParamList.Add(Utilities.GetOraParam(":itmCatID", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsSubCategoryID > 0) { strSelect += " AND ITEMS_SUB_CATEGORY_ID = :itmSubCatID"; ParamList.Add(Utilities.GetOraParam(":itmSubCatID", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); } if (obj.ItemsID > 0) { strSelect += " AND ITEMS_ID = :itmID"; ParamList.Add(Utilities.GetOraParam(":itmID", obj.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); } //if (obj.ItemsTypeID > 0) //{ // strSelect += " AND ITEMS_TYPE_ID = :itmTypeID"; // ParamList.Add(Utilities.GetOraParam(":itmTypeID", obj.ItemsTypeID, OracleDbType.Int64, ParameterDirection.Input)); //} GetConnection conn = new GetConnection(); OracleConnection con = conn.GetDbConn(Module.OAS); DataSet ds = SqlHelper.ExecuteDataset(con, CommandType.Text, strSelect, ParamList.ToArray()); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public static bool AddEmpForDeputationDetail(ATTEmployeeDeputaion obj) // added by shanjeev { string sp = ""; if (obj.Action == "A") { sp = "SP_ADD_EMP_DEPUTATION"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("p_emp_id", obj.EmpID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_org_id", obj.OrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_des_id", obj.DesID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_created_date", obj.CreatedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_post_id ", obj.PostID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_from_date ", obj.FromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_application_date ", obj.ApplicationDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_decision_date", obj.DecisionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_dep_org_id ", obj.DepOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_decision_ver_by", obj.DecisionVerifiedBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_responsibilities", obj.Responsibilities, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_entry_by", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIP_ORG_ID", obj.TipOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", obj.TippaniID, OracleDbType.Int32, ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, sp, paramArray.ToArray()); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw new Exception("Error occur while adding duptation details" + ex.Message); } finally { GetConn.CloseDbConn(); } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { var conn = new GetConnection(_config); services.AddControllers() .AddNewtonsoftJson(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore ); services.AddDbContext <MyContext>(options => options.UseSqlServer(conn.applePenConnection())); //options.UseSqlServer(_config.GetConnectionString("applePenConnection"))); services.AddDbContext <manufacture_Context>(options => options.UseSqlServer(conn.manufactureConnection())); //options.UseSqlServer(_config.GetConnectionString("manufactureConnection"))); }
public static DataTable GetPunishments(double empid) { GetConnection conn = new GetConnection(); OracleConnection obj = conn.GetDbConn(Module.PMS); string SelectSP = "SP_GET_EMP_PUNISHMENTS"; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_EMP_ID", empid, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_RC", null, OracleDbType.RefCursor, ParameterDirection.InputOutput)); try { return(SqlHelper.ExecuteDataset(CommandType.StoredProcedure, SelectSP, Module.PMS, paramArray.ToArray()).Tables[0]); } catch (Exception ex) { throw ex; } }
public object Get(GetConnection request) { try { var result = Plugin.TvProxy.GetStatusInfo(new CancellationToken()); return(true); } catch (ServiceAuthenticationException) { // Do nothing, allow an empty list to be passed out } catch (Exception exception) { Plugin.Logger.ErrorException("There was an issue testing the API connection", exception); } return(false); }
public static bool SavePublicationType(ATTPublicationType ObjAtt) { GetConnection Conn = new GetConnection(); OracleConnection DBConn = Conn.GetDbConn(Module.PMS); OracleTransaction Tran = DBConn.BeginTransaction(); string InsertUpdatePubTypeSql = ""; if (ObjAtt.Action == "A") { InsertUpdatePubTypeSql = "SP_PMS_ADD_PUBLICATION_TYPE"; } else if (ObjAtt.Action == "E") { InsertUpdatePubTypeSql = "SP_PMS_EDIT_PUBLICATION_TYPE"; } try { OracleParameter[] ParamArray = new OracleParameter[4]; ParamArray[0] = Utilities.GetOraParam(":P_PUB_TYPE_ID", ObjAtt.PubTypeID, OracleDbType.Int64, ParameterDirection.InputOutput); ParamArray[1] = Utilities.GetOraParam(": P_PUB_TYPE_NAME", ObjAtt.PubTypeName, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[2] = Utilities.GetOraParam(":P_ACTIVE ", ObjAtt.Active, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[3] = Utilities.GetOraParam(":P_ENTRY_BY", ObjAtt.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePubTypeSql, ParamArray); ObjAtt.PubTypeID = int.Parse(ParamArray[0].Value.ToString()); ObjAtt.PubTypeName = ParamArray[1].Value.ToString(); ObjAtt.Active = ParamArray[2].Value.ToString(); Tran.Commit(); return(true); //return newPublicationTypeID; } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { Conn.CloseDbConn(); } }
public static bool SaveCauseList(ATTCauseList objCauseList) { string InsertUpdateSQL = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_CL_ENTRY_TYPE_ID", objCauseList.CauseListID, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_CL_ENTRY_TYPE_NAME", objCauseList.CauseListName, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", objCauseList.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objCauseList.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); if (objCauseList.Action == "A") { InsertUpdateSQL = "SP_ADD_CL_ENTRY_TYPE"; } else if (objCauseList.Action == "E") { InsertUpdateSQL = "SP_EDIT_CL_ENTRY_TYPE"; } GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.CMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertUpdateSQL, paramArray.ToArray()); objCauseList.CauseListID = int.Parse(paramArray[0].Value.ToString()); 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(); } }
public ResultModel CreateBatch(apple model) { var result = new ResultModel(); var _conn = new GetConnection(_config); using (var conn = new SqlConnection(new GetConnection(_config).applePenConnection())) { //INSERT DATA var sql = @"INSERT INTO apples(name) VALUES (@name); "; var pList = new List <DynamicParameters>();//多筆資料 for (int i = 0; i < 10000; i++) { var p = new DynamicParameters(); p.Add("@name", model.name, DbType.String, direction: ParameterDirection.Input); p.Add("@r", DbType.Int32, direction: ParameterDirection.ReturnValue); pList.Add(p); } var sw = new Stopwatch(); sw.Start(); try { conn.Execute(sql, pList); //var rr = conn.Execute("sp_create_apple", pList, commandType: CommandType.StoredProcedure); //result.d = p.Get<dynamic>("@r");//接收SP回傳值 } catch (Exception e) { result.r = false; result.d = e; return(result); } //GET latest data sql = @"SELECT TOP(1) * FROM apples ORDER BY id DESC"; var query = conn.Query(sql).SingleOrDefault(); sw.Stop(); result.r = true; result.m = "Elapsed time = " + sw.ElapsedMilliseconds / 1000.0 + "s"; //result.d = query; } return(result); }
public static bool AddSupplier(ATTInvSupplier supplier) { string InsertSP = ""; if (supplier.Action == "A") { InsertSP = "SP_INV_ADD_SUPPLIERS"; } else if (supplier.Action == "E") { InsertSP = "SP_INV_EDIT_SUPPLIERS"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_ID", supplier.SupplierID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_NAME", supplier.SupplierName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_SUPPLIERS_ADDRESS", supplier.SupplierAddress, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_pan_no", supplier.PanNo, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ACTIVE", supplier.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", supplier.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.OAS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertSP, paramArray.ToArray()); supplier.SupplierID = int.Parse(paramArray[0].Value.ToString()); DLLInvSupplierContact.AddSupplierContact(supplier.LstSupplierContact, supplier.SupplierID, Tran); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
//TODO :: GET and GETALL repository /// <summary> /// Get tournament data given id. /// </summary> /// <param name="tournamentId">integer tournamentId</param> /// <returns>TeamContractModel</returns> public async Task <TournamentContractModel> GetTournamentAsync(int tournamentId) { try { this.StartTransaction(); // Sql Query to join and get all the nested object data. string getQuery = @"SELECT t.*, s.*,tt.*, tps.* FROM [dbo].[Tournament] t LEFT JOIN Sport s ON (s.SportId=t.SportId) LEFT JOIN TournamentType tt ON (tt.TournamentTypeId=t.TournamentTypeId) LEFT JOIN TournamentPointSystem tps ON (tps.TournamentPointSystemId=t.TournamentPointSystemId) WHERE t.TournamentId=@Id"; // expression to set all the required nested objects. var result = await GetConnection.QueryAsync <TournamentContractModel, SportContractModel, TournamentTypeContractModel, TournamentPointSystemContractModel, TournamentContractModel>(getQuery, (t, s, tt, tps) => { t.Sport = new SportContractModel(); t.Sport.SportId = s.SportId; t.Sport.Description = s.Description; t.Sport.Name = s.Name; t.TournamentType = new TournamentTypeContractModel(); t.TournamentType.Name = tt.Name; t.TournamentType.TournamentTypeId = tt.TournamentTypeId; t.TournamentType.Description = tt.Description; t.TournamentPointSystem = new TournamentPointSystemContractModel(); t.TournamentPointSystem.TournamentPointSystemId = tps.TournamentPointSystemId; t.TournamentPointSystem.Name = tps.Name; t.TournamentPointSystem.Winpoint = tps.Winpoint; t.TournamentPointSystem.DrawPoint = tps.DrawPoint; t.TournamentPointSystem.LossPoint = tps.LossPoint; return(t); }, new { Id = tournamentId }, splitOn : "TournamentId,SportId,TournamentTypeId,TournamentPointSystemId", commandType : CommandType.Text, transaction : Transaction); this.CommitTransaction(); return(result.FirstOrDefault()); } catch (Exception) { this.RollbackTransaction(); // rollback & close throw; } }
public static System.Data.DataTable GetSessionCourseMemberForMarks(int orgID, int prgID, int sessionID, int?CourseID) { string SelectSP = "SP_GET_CA_MEM_FOR_MARKS"; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_ORG_ID", orgID, OracleDbType.Int64, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_PRG_ID", prgID, OracleDbType.Int64, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_SESSION_ID", sessionID, OracleDbType.Int64, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_COURSE_ID", CourseID, OracleDbType.Int64, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_RC", null, OracleDbType.RefCursor, System.Data.ParameterDirection.InputOutput)); GetConnection GetConn = new GetConnection(); try { OracleConnection DBConn = GetConn.GetDbConn(Module.DLPDS); SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, SelectSP, paramArray.ToArray()); if (paramArray[4].Value == System.DBNull.Value || paramArray[4].Value == null) { return(new DataTable()); } else { OracleDataReader reader = ((OracleRefCursor)paramArray[4].Value).GetDataReader(); DataTable tbl = new DataTable(); tbl.Load(reader, LoadOption.OverwriteChanges); return(tbl); } } catch (Exception ex) { throw ex; } finally { GetConn.CloseDbConn(); } }
public static async Task <TipoMPEntity> UpdateTipoMP(short IdTipMan, string Descripcion, decimal Kilometros, decimal KilometrosAviso, short Dias, short DiasAviso, short Horas, short HorasAviso, short Meses, short MesesAviso) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_UPD_tb_tipomantenimiento", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdTipMan", SqlDbType.Int).Value = IdTipMan; cmd.Parameters.Add("@Descripcion", SqlDbType.Text).Value = Descripcion; cmd.Parameters.Add("@Kilometros", SqlDbType.Decimal).Value = Kilometros; cmd.Parameters.Add("@KilometrosAviso", SqlDbType.Decimal).Value = KilometrosAviso; cmd.Parameters.Add("@Dias", SqlDbType.Int).Value = Dias; cmd.Parameters.Add("@DiasAviso", SqlDbType.Int).Value = DiasAviso; cmd.Parameters.Add("@Horas", SqlDbType.Int).Value = Horas; cmd.Parameters.Add("@HorasAviso", SqlDbType.Int).Value = HorasAviso; cmd.Parameters.Add("@Meses", SqlDbType.Int).Value = Meses; cmd.Parameters.Add("@MesesAviso", SqlDbType.Int).Value = MesesAviso; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }
public static bool UpdateDocument(ATTDocument objDoc) { string UpdateSQL = "SP_EDIT_Document"; int CountDocAttachment = objDoc.LstDocAttachment.Count; int CountDocProcess = objDoc.LstDocProcess.Count; OracleParameter[] paramArray = new OracleParameter[7]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objDoc.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_UNIT_ID", objDoc.UnitID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_DOC_ID", objDoc.DocID, OracleDbType.Int64, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":p_DOCUMENT_NAME", objDoc.DocumentName, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":p_DOCUMENT_DESC", objDoc.DocDescription, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":p_FILE_CAT_ID", objDoc.DocCategory, OracleDbType.Int64, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":p_DOCUMENT_FLOW_ID", objDoc.DocFlowType, OracleDbType.Int64, ParameterDirection.Input); GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, UpdateSQL, paramArray); if (CountDocProcess > 0) { DLLDocumentProcess.UpateDocProcess(objDoc.LstDocProcess, Tran); } if (CountDocAttachment > 0) { DLLDocumentAttachment.UpateDocAttachment(objDoc.LstDocAttachment, Tran); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } }
public static DataTable GetMessagePersonListTable(int?orgID, int?unitID, string searchValue) { GetConnection Conn = new GetConnection(); try { string selectSQL; if (orgID != null && unitID != null) { selectSQL = "SELECT EMP_ID,FIRST_NAME,MID_NAME,SUR_NAME FROM VW_EMP_WORK_DISTRIBUTION WHERE ORG_ID =" + orgID + " AND ORG_UNIT_ID = " + unitID; } else if (orgID != null) { selectSQL = "SELECT EMP_ID,FIRST_NAME,MID_NAME,SUR_NAME FROM VW_EMP_WORK_DISTRIBUTION WHERE ORG_ID =" + orgID; } else { selectSQL = "SELECT EMP_ID,FIRST_NAME,MID_NAME,SUR_NAME FROM VW_EMP_WORK_DISTRIBUTION WHERE 1 = 1 "; } if (searchValue.Trim() != "") { selectSQL += " AND FIRST_NAME LIKE '" + searchValue + "%'"; } selectSQL += " ORDER BY FIRST_NAME ASC "; OracleConnection DBConn = Conn.GetDbConn(Module.OAS); DataSet ds = SqlHelper.ExecuteDataset(DBConn, CommandType.Text, selectSQL); DataTable tbl = new DataTable(); tbl = (DataTable)ds.Tables[0]; return(tbl); } catch (Exception ex) { throw (ex); } finally { Conn.CloseDbConn(); } }
public static bool SaveLeaveType(ATTLeaveType ObjAtt) { GetConnection Conn = new GetConnection(); OracleConnection DBConn; OracleTransaction Tran; string InsertUpdateLeaveType = ""; try { DBConn = Conn.GetDbConn(Module.PMS); Tran = DBConn.BeginTransaction(); if (ObjAtt.LeaveTypeID == 0) { InsertUpdateLeaveType = "SP_ADD_LEAVE_TYPES"; } else { InsertUpdateLeaveType = "SP_EDIT_LEAVE_TYPES"; } OracleParameter[] ParamArray = new OracleParameter[4]; ParamArray[0] = Utilities.GetOraParam(":p_LEAVE_TYPE_ID", ObjAtt.LeaveTypeID, OracleDbType.Int64, ParameterDirection.InputOutput); ParamArray[1] = Utilities.GetOraParam(":p_LEAVE_TYPE_NAME", ObjAtt.LeaveTypeName, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[2] = Utilities.GetOraParam(":p_GENDER", ObjAtt.Gender, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[3] = Utilities.GetOraParam(":p_ACTIVE", ObjAtt.Active, OracleDbType.Varchar2, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateLeaveType, ParamArray); int LeaveTypeID = int.Parse(ParamArray[0].Value.ToString()); ObjAtt.LeaveTypeID = LeaveTypeID; Tran.Commit(); return(true); } catch (Exception ex) { throw ex; } finally { Conn.CloseDbConn(); } }
public static bool AddSewa(ATTSewa sewa) { string InsertSP; if (sewa.Action == "A") { InsertSP = "SP_ADD_SEWA"; } else { InsertSP = "SP_EDIT_SEWA"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_sewa_id", sewa.SewaID, OracleDbType.Int64, System.Data.ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_sewa_name", sewa.SewaName, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by", sewa.EntryBy, OracleDbType.Varchar2, System.Data.ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_on", sewa.EntryOn, OracleDbType.Date, System.Data.ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, InsertSP, paramArray.ToArray()); sewa.SewaID = int.Parse(paramArray[0].Value.ToString()); sewa.Action = "M"; DLLSamuha.AddSamuha(sewa.LstSamuha, sewa.SewaID, Tran); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }
public static async Task <int> InsertInformeTareas(InformeTareasEntity objEntidad) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("Usp_Tb_InformeTareas_Insert", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdInforme", SqlDbType.Int).Value = objEntidad.IdInforme; cmd.Parameters.Add("@IdTarea", SqlDbType.Int).Value = objEntidad.IdTarea; cmd.Parameters.Add("@Observacion", SqlDbType.VarChar).Value = objEntidad.Observacion; cmd.Parameters.Add("@ServTerceros_Codigo", SqlDbType.VarChar).Value = ""; cmd.Parameters.Add("@ServTerceros_TbgDocumento", SqlDbType.VarChar).Value = ""; cmd.Parameters.Add("@UsuarioRegistro", SqlDbType.Int).Value = objEntidad.UsuarioRegistro; cmd.Parameters.Add("@FInicio", SqlDbType.DateTime).Value = Functions.Check.Datetime(objEntidad.FechaInicio); cmd.Parameters.Add("@IdPlanEjecucionTareas", SqlDbType.VarChar).Value = ""; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static bool saveDonationPurchases(ATTInvDonationsPurchases obj) { List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":p_org_id ", obj.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_category_id", obj.ItemsCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_sub_category_id", obj.ItemsSubCategoryID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_items_id", obj.ItemsID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_date ", obj.DonationPurchaseDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_seq", obj.DonationPurchaseSeq, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_type", obj.DonationPurchaseType, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_org", obj.DonationPurchaseOrg, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_qty ", obj.DonationPurchaseQty, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_don_pur_unit_price", obj.DonationPurchaseUnitPrice, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rcvd_by", obj.ReceivedBy, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_rcvd_date", obj.ReceivedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":p_entry_by ", obj.EntrBy, OracleDbType.Varchar2, ParameterDirection.Input)); GetConnection getConn = new GetConnection(); try { OracleConnection DBConn = getConn.GetDbConn(Module.OAS); if (obj.Action == "A") //New Add { SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, "sp_inv_add_don_purchases", paramArray.ToArray()); } else if (obj.Action == "E") //Update { SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, "sp_inv_edit_don_purchases", paramArray.ToArray()); } obj.DonationPurchaseSeq = int.Parse(paramArray[5].Value.ToString()); return(true); } catch (Exception ex) { throw ex; } finally { getConn.CloseDbConn(); } }
public static bool LeaveApprove(ATTEmployeeLeave var) { OracleTransaction Tran; GetConnection conn = new GetConnection(); OracleConnection DBConn = conn.GetDbConn(Module.PMS); Tran = DBConn.BeginTransaction(); try { string InsertUpdateDLSP = "SP_LEAVE_APPROVE"; OracleParameter[] paramArray = new OracleParameter[16]; paramArray[0] = Utilities.GetOraParam("P_IS_OTHERS", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_EMP_ID", var.EmpID, OracleDbType.Int32, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_LEAVE_TYPE_ID", var.LeaveTypeID, OracleDbType.Int32, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":P_APPL_DATE", var.ApplDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_APP_BY", var.AppByID, OracleDbType.Int32, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_APP_DATE", var.AppDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_APP_FROM_DATE", var.AppFrom, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_APP_TO_DATE", var.AppTo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_APP_NO_OF_DAYS", var.AppDays, OracleDbType.Int32, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_APP_YES_NO", var.Approved, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_APP_REASON", var.AppReason, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[11] = Utilities.GetOraParam(":P_LEAVE_FY", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[12] = Utilities.GetOraParam("P_LEAVE_PERIOD_UNIT", null, OracleDbType.Int32, ParameterDirection.Input); paramArray[13] = Utilities.GetOraParam("P_PERIOD_TYPE", null, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[14] = Utilities.GetOraParam("P_PERIOD_COUNT", null, OracleDbType.Int32, ParameterDirection.Input); paramArray[15] = Utilities.GetOraParam("P_LEAVE_TAKEN_CNT", null, OracleDbType.Int32, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdateDLSP, paramArray); Tran.Commit(); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { DBConn.Close(); } return(true); }
public static DataTable GetSessionCourseTable(int orgID, int programID, int sessionID, int CourseID) { string SelectSP = "SP_GET_SESSION_COURSE"; OracleParameter[] paramArray = new OracleParameter[5]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", orgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_PROGRAM_ID", programID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_SESSION_ID", sessionID, OracleDbType.Int64, ParameterDirection.Input); if (CourseID > 0) { paramArray[3] = Utilities.GetOraParam(":p_COURSE_ID", CourseID, OracleDbType.Int64, ParameterDirection.Input); } else { paramArray[3] = Utilities.GetOraParam(":p_COURSE_ID", null, OracleDbType.Int64, ParameterDirection.Input); } paramArray[4] = Utilities.GetOraParam(":P_RC", null, OracleDbType.RefCursor, ParameterDirection.Output); GetConnection GetConn = new GetConnection(); try { OracleConnection DBConn = GetConn.GetDbConn(Module.DLPDS); SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, SelectSP, paramArray); OracleDataReader reader = ((OracleRefCursor)paramArray[4].Value).GetDataReader(); DataTable tbl = new DataTable(); tbl.Load(reader, LoadOption.OverwriteChanges); return(tbl); } catch (Exception ex) { throw ex; } finally { GetConn.CloseDbConn(); } }
public static List <MarcaModeloEntity> ListMarcaModelo() { List <MarcaModeloEntity> List = new List <MarcaModeloEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_LIS_Tb_MarcaModeloBuses", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new MarcaModeloEntity { cod_marca = DataReader.GetStringValue(dr, "cod_marca"), marca = DataReader.GetStringValue(dr, "marca"), cod_modelo = DataReader.GetStringValue(dr, "cod_modelo"), modelo = DataReader.GetStringValue(dr, "modelo"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <BaseEntity> ListArticulosAutocomplete(string idEmpresa, string idAlmacen, string value) { List <BaseEntity> List = new List <BaseEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_Mer_Listar_Autocomplete", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pCodi_Empresa", SqlDbType.VarChar).Value = idEmpresa; cmd.Parameters.Add("@pidalmacen", SqlDbType.VarChar).Value = idAlmacen; cmd.Parameters.Add("@pfiltro", SqlDbType.VarChar).Value = (value != null) ? value : string.Empty; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new BaseEntity { Codigo = DataReader.GetStringValue(dr, "Codigo"), Descripcion = DataReader.GetStringValue(dr, "Descripcion"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static DataTable GetEmpDesLeave(int eid) { try { GetConnection conn = new GetConnection(); OracleConnection obj = conn.GetDbConn(Module.PMS); string GetEmpDesLeaveSQL = "SP_GET_EMP_DES_LEAVE"; OracleParameter[] ParamArray = new OracleParameter[2]; ParamArray[0] = Utilities.GetOraParam(":P_EMP_ID", eid, OracleDbType.Int64, ParameterDirection.Input); ParamArray[1] = Utilities.GetOraParam(":P_RC", null, OracleDbType.RefCursor, ParameterDirection.Output); DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.StoredProcedure, GetEmpDesLeaveSQL, ParamArray); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public Vita(GetConnection getconn, string name, string package, string appkeypath) { this.getconn = getconn; this.name = name; this.package = string.IsNullOrEmpty(package) ? null : Path.GetFullPath(package); this.appkeypath = appkeypath; }