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