private void btnTest_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(rtbQuery.Text) || String.IsNullOrEmpty(rtbValues.Text))
{
MessageBox.Show("favor introducir todos los datos");
}
else
{
var matches = rtbValues.Text.Split(',');
ArrayList values = new ArrayList();
foreach (var val in matches)
{
var value = val.Split('|');
var type = Type.GetType(value[1]);
values.Add(Convert.ChangeType(value[0],type));
}
var directions = rtbDirections.Text.Split(',');
directions = (directions.Count() == 0 || directions[0] == "") ? null : directions;
GenericDAO<OracleCommand, OracleConnection, OracleDataAdapter> dao =
new GenericDAO<OracleCommand, OracleConnection, OracleDataAdapter>();
dynamic parameters = "";
if (IsTextCommand.Checked)
{
dao.FillCommand(rtbQuery.Text, values.ToArray(), directions);
parameters = DBUtils.getParameterNames<OracleCommand>(rtbQuery.Text);
}
else
{
var prms = rtbQuery.Text.Split('&');
var procedureName = prms[0];
parameters = prms[1];
dao.FillCommand(procedureName, values.ToArray(), parameters, directions);
}
String result = "";
result += string.Format("Query: \n {0} \n", rtbQuery.Text);
result += "\nValores producidos en DbParameter\n\n";
foreach (OracleParameter parameter in dao.Command.Parameters)
{
result += string.Format("nombre: {3}, valor: {0}, tipo: {1}, direccion: {2}\n", parameter.Value, parameter.DbType, parameter.Direction, parameter.ParameterName);
}
rtbResult.Text = result;
}
}
private void BuildUserProfileBasedOnLdap()
{
var gameStockConfig = new StockGameConfiguration();
var ldapService = new LdapService(gameStockConfig);
ldapService.Init();
var userProfile = ldapService.FindRuleEmployee("wasztemborski");
//var a = ldapService.AuthenticateUser("RULE", "wasztemborski", "rule2financial!");
var userProfileDao = new GenericDAO<UserProfile>();
userProfile = userProfileDao.FindById(userProfileDao.Save(userProfile));
var instrument = new Instrument();
instrument.Ask = new Random().Next();
instrument.Bid = new Random().Next();
instrument.Name = "Procom " + new Random().Next();
var orderDbo = new GenericDAO<Order>();
var order = new Order();
order.Owner = userProfile;
order.OrderStategy = OrderStategy.StopLost;
orderDbo.SaveOrUpdate(order);
}
public DataTable getnormaladdressdetails()
{
return(GenericDAO.getDataTable("select * from View_NewShippingAddress_Master where AddressType='Normal'"));
}
public DataTable getaddtocartdetails(int productid)
{
return(GenericDAO.getDataTable("select * from View_AddToCart_Master where ProductID='" + productid + "'"));
}
public DataTable getproductdetails(string productskuid)
{
return(GenericDAO.getDataTable("select * from View_ImageProductNew_Master where SKUCode='" + productskuid + "'"));
}
public int?updateaddtocartproductdetails(String userId, string SKUCode, int q, int totalPrice)
{
return(GenericDAO.updateQuery("update View_AddToCart_Master set Quantity ='" + q + "', TotalPrice='" + totalPrice + "' where UserID='" + userId + "' and ProductSKUCode ='" + SKUCode + "'"));
}
public static void removeFromCart(string sessionId, string sku)
{
GenericDAO.deleteQuery("delete CART where SESSION_ID='" + sessionId + "' and sku='" + sku + "'");
}
public Revista buscar(int id)
{
return(GenericDAO <Revista> .buscar(id));
}
public int?DeleteAddToCartOfUser(String id)
{
return(GenericDAO.deleteQuery("delete from AddToCart_Master where AddToCart_UserID='" + id + "'"));
}
public DataTable getaddtocartproductdetails(int UserID)
{
return(GenericDAO.getDataTable("select * from View_AddToCart_Master where UserID='" + UserID + "'"));
}
public int?AddToWishlistByUser(Dictionary <string, string> paramDic)
{
return(GenericDAO.executeProcedure("sp_FrontEnd_AddToWaitList_Master", paramDic));
}
public DataTable getskusizeproductidofuser(string stylecode, string size)
{
return(GenericDAO.getDataTable("select * from View_ImageProductNew_Master where StyleCode='" + stylecode + "' and Size='" + size + "'"));
}
public static DropdownEntity[] GetDropdownLisData()
{
var details = new List <DropdownEntity>();
try
{
List <JewelleryMasterEntity> objlst = new List <JewelleryMasterEntity>();
objlst = new GenericDAO().GetActiveJewelleryList();
foreach (JewelleryMasterEntity obj in objlst)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "JEWELLERY";
details.Add(objnew);
}
List <DesignMasterEntity> objlstdesign = new List <DesignMasterEntity>();
objlstdesign = new GenericDAO().GetActiveDesignList();
foreach (DesignMasterEntity obj in objlstdesign)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "DESIGN";
details.Add(objnew);
}
List <CollectionsMasterEntity> objlstcol = new List <CollectionsMasterEntity>();
objlstcol = new GenericDAO().GetActiveCollectionsList();
foreach (CollectionsMasterEntity obj in objlstcol)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "COLLECTON";
details.Add(objnew);
}
List <MaterialMasterEntity> objlstmat = new List <MaterialMasterEntity>();
objlstmat = new GenericDAO().GetActiveMaterialList();
foreach (MaterialMasterEntity obj in objlstmat)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "MATERIAL";
details.Add(objnew);
}
List <OccasionMasterEntity> objlstosscat = new List <OccasionMasterEntity>();
objlstosscat = new GenericDAO().GetActiveOccasionList();
foreach (OccasionMasterEntity obj in objlstosscat)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "OCCASION";
details.Add(objnew);
}
List <GramSlabMasterEntity> objlstgs = new List <GramSlabMasterEntity>();
objlstgs = new GenericDAO().GetActiveGramSlabList();
foreach (GramSlabMasterEntity obj in objlstgs)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "GRAMSLAB";
details.Add(objnew);
}
List <KaratMasterEntity> objlstkarat = new List <KaratMasterEntity>();
objlstkarat = new GenericDAO().GetActiveKaratList();
foreach (KaratMasterEntity obj in objlstkarat)
{
DropdownEntity objnew = new DropdownEntity();
objnew.NAME = obj.NAME;
objnew.ID = obj.ID;
objnew.TYPE = "KARAT";
details.Add(objnew);
}
}
catch (Exception ex)
{
// details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
/// <summary>
/// Default constructor.
/// </summary>
/// <param name="motor">Database context class. Performs the database access operations.</param>
public ProductsDAO(Motor motor)
{
this.motor = motor;
GenericDAO d = new GenericDAO(motor);
}
private void btnTaoMaTD_Click(object sender, EventArgs e)
{
txtMaTranDau.Text = GenericDAO.getKey("select dbo.getKeyMaTranDau()");
}
public DataTable getnewshippingaddressdetails(int userid)
{
return(GenericDAO.getDataTable("select * from View_NewShippingAddress_Master where UserID='" + userid + "'"));
}
public int crear(Revista revista)
{
return(GenericDAO <Revista> .crear(revista));
}
public DataTable getaddtocartproductfornew(int UserID, string SKUCode)
{
return(GenericDAO.getDataTable("select * from View_AddToCart_Master where UserID='" + UserID + "' and ProductSKUCode ='" + SKUCode + "'"));
}
public DataTable getaddtocartByUserId(String UserID)
{
return(GenericDAO.getDataTable("select * from View_AddToCart_Master where UserID='" + UserID + "'"));
}
internal static void clearCart(string sessionId)
{
GenericDAO.updateQuery("delete CART where SESSION_ID='" + sessionId + "'");
}