public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(srAccID,partName,description,partNumber,color,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + Sunrail300AccessoriesName + "','" + Sunrail300AccessoriesDescription + "','" + PartNumber + "','" + Sunrail300AccessoriesColor + "'," + Sunrail300AccessoriesUsdPrice + "," + Sunrail300AccessoriesCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); count = selectTable.Count; try { sqlInsert = "INSERT INTO " + table + "(accId,partName,description,partNumber,color,packQuantity,width,widthUnits,length,lengthUnits,size,sizeUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + AccessoryName + "','" + AccessoryDescription + "','" + AccessoryNumber + "','" + AccessoryColor + "'," + AccessoryPackQuantity + "," + AccessoryWidth + ",'" + AccessoryWidthUnits + "'," + AccessoryLength + ",'" + AccessoryLengthUnits + "'," + AccessorySize + ",'" + accessorySizeUnits + "'," + AccessoryUsdPrice + "," + AccessoryCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); } catch (Exception ex) { string troubleshoot = ex.Message; } }
public void TransferDetailServiceTest() { string Username = "******"; string PassWord = "******"; var mockAuthenticationManager = new Mock<IAuthenticationManager>(); mockAuthenticationManager.Setup(am => am.SignOut()); mockAuthenticationManager.Setup(am => am.SignIn()); IdentityHelper.AuthenticationManager = mockAuthenticationManager.Object; HttpContext.Current = FakeHttpContext(); AppDomain.CurrentDomain.SetData( "DataDirectory", @"C:\Users\Priyank Kapadia\Documents\Visual Studio 2015\Projects\BnkApplication\BnkApplication\App_Data\"); bool RememberME = true; LoginService servicetest = new LoginService(Username, PassWord, RememberME); servicetest.Login(); // Role Authentication the user who is not admin should not be able to view all details // faking the object as in the UI System.Web.UI.WebControls.SqlDataSource sql = new System.Web.UI.WebControls.SqlDataSource(); sql.SelectCommand = "SELECT * FROM [Table]"; TransferDetailService testserv = new TransferDetailService(sql,Username); Assert.AreEqual("SELECT * FROM [Table] where PAYER_NAME ='" + Username + "'", sql.SelectCommand); }
public void TransferDetailServiceTest() { string Username = "******"; string PassWord = "******"; var mockAuthenticationManager = new Mock <IAuthenticationManager>(); mockAuthenticationManager.Setup(am => am.SignOut()); mockAuthenticationManager.Setup(am => am.SignIn()); IdentityHelper.AuthenticationManager = mockAuthenticationManager.Object; HttpContext.Current = FakeHttpContext(); AppDomain.CurrentDomain.SetData( "DataDirectory", @"C:\Users\Priyank Kapadia\Documents\Visual Studio 2015\Projects\BnkApplication\BnkApplication\App_Data\"); bool RememberME = true; LoginService servicetest = new LoginService(Username, PassWord, RememberME); servicetest.Login(); // Role Authentication the user who is not admin should not be able to view all details // faking the object as in the UI System.Web.UI.WebControls.SqlDataSource sql = new System.Web.UI.WebControls.SqlDataSource(); sql.SelectCommand = "SELECT * FROM [Table]"; TransferDetailService testserv = new TransferDetailService(sql, Username); Assert.AreEqual("SELECT * FROM [Table] where PAYER_NAME ='" + Username + "'", sql.SelectCommand); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(insulatedFloorID,partName,description,composition,partNumber,size,sizeUnits,maxWidth,widthUnits,maxLength,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + InsulatedFloorName + "','" + InsulatedFloorDescription + "','" + InsulatedFloorComposition + "','" + PartNumber + "'," + InsulatedFloorSize + ",'" + InsulatedFloorSizeUnits + "'," + InsulatedFloorMaxWidth + ",'" + InsulatedFloorMaxWidthUnits + "','" + InsulatedFloorMaxLength + "'," + InsulatedFloorUsdPrice + "," + InsulatedFloorCadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(extrusionID,partName,description,partNumber,size,sizeUnits,color,extrusionAngleA,angleAUnits,extrusionAngleB,angleBUnits,extrusionAngleC,angleCUnits,maxLength,lengthUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + ExtrusionName + "','" + ExtrusionDescription + "','" + ExtrusionNumber + "'," + ExtrusionSize + ",'" + SizeUnits + "','" + ExtrusionColor + "'," + AngleA + ",'" + AngleAUnits + "'," + AngleB + ",'" + AngleBUnits + "'," + AngleC + ",'" + AngleCUnits + "'," + ExtrusionMaxLength + ",'" + MaxLengthUnits + "'," + UsdPrice + "," + CadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(rollID,partName,partNumber,width,widthUnits,length,lengthUnits,usdPrice,cadPrice,status)" + "VALUES" + "(" + (count + 1) + ",'" + ScreenRollName + "','" + PartNumber + "'," + ScreenRollWidth + ",'" + ScreenRollWidthUnits + "'," + ScreenRollLength + ",'" + ScreenRollLengthUnits + "'," + UsdPrice + "," + CadPrice + "," + 1 + ")"; dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum) { dataSource.UpdateCommand = "UPDATE tblSchematicParts SET usdPrice=" + PartUsdPrice + ", cadPrice=" + PartCadPrice + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
public TransferDetailService(System.Web.UI.WebControls.SqlDataSource sql, string name) { //if (System.Web.HttpContext.Current.Session["AdminFlag"] == null) // This part is modified to see if that //{ //sql.SelectCommand = "SELECT * FROM [Table] where PAYER_NAME ='" + name + "'"; //} }
//Select all parts from the database public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT schematicNumber, description, partName, usdPrice, cadPrice, status FROM " + table + " WHERE schematicNumber='" + partNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
public DataView getUserListData() { System.Web.UI.WebControls.SqlDataSource sds = new System.Web.UI.WebControls.SqlDataSource(); sds.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; String SQLStr = "SELECT username,name,dep,mail,note FROM AspNetLinkUserData"; sds.SelectParameters.Clear(); //sds.SelectParameters.Add("group_name", "%" + group_name + "%"); sds.SelectCommand = SQLStr; DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); return(dv); }
//刪除使用者 public bool DeleteUser(string username) { var Db = new ApplicationDbContext(); var user = Db.Users.First(u => u.UserName == username); Db.Users.Remove(user); Db.SaveChanges(); System.Web.UI.WebControls.SqlDataSource sds = new System.Web.UI.WebControls.SqlDataSource(); sds.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; String SQLStr = "DELETE AspNetLinkUserData Where username = @username"; sds.DeleteParameters.Add("username", username); sds.DeleteCommand = SQLStr; sds.Delete(); return(true); }
//Database select all public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT partName, description, partNumber, color, size, sizeUnits, extrusionAngleA," + " angleAUnits, extrusionAngleB, angleBUnits, extrusionAngleC, angleCUnits, maxLength, lengthUnits, usdPrice, cadPrice, status FROM " + table + " WHERE partNumber = '" + partNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
//Select all parts from the database public System.Data.DataView SelectAll(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum, string schematicNum) { //set up a dataview object for object member data System.Data.DataView anObjectTable = new System.Data.DataView(); //select row based on table name and part number dataSource.SelectCommand = "SELECT tblParts.partNumber,tblParts.partName,tblSchematicParts.SchematicNumber, tblSchematicParts.usdPrice, tblSchematicParts.cadPrice, " + "tblSchematicParts.keyNumber " + "FROM tblParts " + "INNER JOIN tblSchematicParts " + "ON tblParts.partNumber = tblSchematicParts.partNumber " + "WHERE tblParts.partNumber = '" + partNum + "' AND tblSchematicParts.schematicNumber= '" + schematicNum + "'"; //assign the row to the dataview object anObjectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //return the DataView object return(anObjectTable); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string partNum) { int bitStatus; if (SchematicStatus) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE tblSchematics SET description ='" + SchematicDescription + "', usdPrice=" + SchematicUsdPrice + ", cadPrice=" + SchematicCadPrice + ", status=" + bitStatus + " WHERE schematicNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (Sunrail300AccessoriesStatus) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + Sunrail300AccessoriesDescription + "', usdPrice=" + Sunrail300AccessoriesUsdPrice + ", cadPrice=" + Sunrail300AccessoriesCadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
public void Insert(System.Web.UI.WebControls.SqlDataSource dataSource, string table) { string sqlCount; string sqlInsert; System.Data.DataView selectTable = new System.Data.DataView(); int count; sqlCount = "SELECT * FROM " + table; dataSource.SelectCommand = sqlCount; selectTable = (System.Data.DataView)dataSource.Select(System.Web.UI.DataSourceSelectArguments.Empty); //find out how many records are in the table in order to set the primary key count = selectTable.Count; //Insert sqlInsert = "INSERT INTO " + table + "(sr400ID,partName,description,partNumber,color,maxLengthFeet,lengthFeetUnits,maxLengthInches,lengthInchesUnits,usdPrice,cadPrice,status)" + "VALUES(" + (count + 1) + ",'" + Sunrail400Name + "','" + Sunrail400Description + "','" + PartNumber + "','" + Sunrail400Color + "'," + Sunrail400MaxLengthFeet + ",'" + Sunrail400MaxLengthFeetUnits + "'," + Sunrail400MaxLengthInches + ",'" + Sunrail400MaxLengthInchesUnits + "'," + Sunrail400UsdPrice + "," + Sunrail400CadPrice + "," + 1 + ")"; if (Sunrail400MaxLengthInches == null) { sqlInsert = "INSERT INTO " + table + "(sr400ID,partName,description,partNumber,color,maxLengthFeet,lengthFeetUnits,maxLengthInches,lengthInchesUnits,usdPrice,cadPrice,status)" + "VALUES(" + (count + 1) + ",'" + Sunrail400Name + "','" + Sunrail400Description + "','" + PartNumber + "','" + Sunrail400Color + "'," + Sunrail400MaxLengthFeet + ",'" + Sunrail400MaxLengthFeetUnits + "',null,null," + Sunrail400UsdPrice + "," + Sunrail400CadPrice + "," + 1 + ")"; } //Null Insert dataSource.InsertCommand = sqlInsert; dataSource.Insert(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (Status) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET width =" + VinylRollWidth + ", widthUnits='" + VinylRollWidthUnits + "', weight=" + VinylRollWeight + ", weightUnits='" + VinylRollWeightUnits + "', usdPrice=" + UsdPrice + ", cadPrice=" + CadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (Sunrail400Status) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + Sunrail400Description + "', maxLengthFeet=" + Sunrail400MaxLengthFeet + ", maxLengthInches=" + Sunrail400MaxLengthInches + ", usdPrice=" + Sunrail400UsdPrice + ", cadPrice=" + Sunrail400CadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (Status) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + wallExtrusionDescription + "', maxLength=" + wallExtrusionMaxLength + ", lengthUnits='" + LengthUnits + "', usdPrice=" + UsdPrice + ", cadPrice=" + CadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (Status) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + PanelDescription + "', composition='" + PanelComposition + "', standard='" + PanelStandard + "', color='" + PanelColor + "', size=" + PanelSize + ", sizeUnits='" + PanelSizeUnits + "', maxWidth=" + PanelMaxWidth + ", widthUnits='" + MaxWidthUnits + "', maxLength='" + PanelMaxLength + "', usdPrice=" + UsdPrice + ", cadPrice=" + CadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (accessoryStatus) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + AccessoryDescription + "', packQuantity=" + AccessoryPackQuantity + ", width=" + AccessoryWidth + ", widthUnits='" + AccessoryWidthUnits + "', length=" + AccessoryLength + ", lengthUnits='" + AccessoryLengthUnits + "', size=" + AccessorySize + ", sizeUnits='" + AccessorySizeUnits + "', usdPrice=" + AccessoryUsdPrice + ", cadPrice=" + AccessoryCadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
//Database update public void Update(System.Web.UI.WebControls.SqlDataSource dataSource, string table, string partNum) { int bitStatus; if (InsulatedFloorStatus) { bitStatus = 1; } else { bitStatus = 0; } dataSource.UpdateCommand = "UPDATE " + table + " SET description ='" + InsulatedFloorDescription + "', composition='" + InsulatedFloorComposition + "', size=" + InsulatedFloorSize + ", sizeUnits='" + InsulatedFloorSizeUnits + "', maxWidth=" + InsulatedFloorMaxWidth + ", widthUnits='" + InsulatedFloorMaxWidthUnits + "', maxLength='" + InsulatedFloorMaxLength + "', usdPrice=" + InsulatedFloorUsdPrice + ", cadPrice=" + InsulatedFloorCadPrice + ", status=" + bitStatus + " WHERE partNumber = '" + partNum + "'"; dataSource.Update(); }
public CascadingDropDownNameValue[] GetSubCategories(string knownCategoryValues, string category) { StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>(); int ParentCategoryID = 0; foreach (string s in kv.Keys) ParentCategoryID = Convert.ToInt32(kv[s]); using (var DS = new System.Web.UI.WebControls.SqlDataSource()) { DS.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["AdventureWorksConnectionString"].ConnectionString; DS.SelectCommand = "select ProductCategoryID, Name from ProductCategory where ParentProductCategoryID = " + ParentCategoryID + " order by Name"; using (var result = (DS.Select(System.Web.UI.DataSourceSelectArguments.Empty) as System.Data.DataView).Table) { foreach (DataRow row in result.Rows) { values.Add(new CascadingDropDownNameValue(row["Name"].ToString(), row["ProductCategoryID"].ToString())); } } } return values.ToArray(); }
public static void CombineSQL(System.Web.UI.DataSourceControl _dataSource, string _columnName, Object _value, string _paramName, EnumSQLOperator _op) { StringBuilder _sb = new StringBuilder(256); string _parameterName, _parameterName1, _whereSQL, _originalSelectCommand = ""; int _where_pos; //int _parameterCount = 0; if ((_columnName == null) || (_columnName.Trim() == "")) { return; } if (!(_op == EnumSQLOperator.IsNull || _op == EnumSQLOperator.IsNotNull)) { if (_value == null || _value.ToString() == "") { return; } } //if (_dataSource is System.Web.UI.WebControls.SqlDataSource) //{ // _parameterCount = ((System.Web.UI.WebControls.SqlDataSource)_dataSource).SelectParameters.Count; //} //else //{ // return; //} if (!(_dataSource is System.Web.UI.WebControls.SqlDataSource)) { return; } _parameterName = "@" + _paramName; _parameterName1 = _paramName; _whereSQL = CombineSQL(_columnName, _parameterName, _op); if (_dataSource is System.Web.UI.WebControls.SqlDataSource) { _originalSelectCommand = ((System.Web.UI.WebControls.SqlDataSource)_dataSource).SelectCommand; } _sb.Append(_originalSelectCommand); _sb.Replace("\r\n", " "); _where_pos = _sb.ToString().ToUpper().IndexOf(" WHERE "); if (_where_pos >= 0) { _sb.Insert(_where_pos + 7, _whereSQL + " AND "); } else { int _group_pos = _sb.ToString().ToUpper().IndexOf(" GROUP "); if (_group_pos >= 0) { _sb.Insert(_group_pos, " WHERE " + _whereSQL + " "); } else { int _order_pos = _sb.ToString().ToUpper().IndexOf(" ORDER "); if (_order_pos >= 0) { _sb.Insert(_order_pos, " WHERE " + _whereSQL + " "); } else { _sb.Append(" WHERE " + _whereSQL + " "); } } } if (_dataSource is System.Web.UI.WebControls.SqlDataSource) { ((System.Web.UI.WebControls.SqlDataSource)_dataSource).SelectCommand = _sb.ToString(); if (_op == EnumSQLOperator.IsNull || _op == EnumSQLOperator.IsNotNull) { return; } string _data = ""; if (_op == EnumSQLOperator.Like || _op == EnumSQLOperator.NotLike) { _data = "%" + _value.ToString() + "%"; } else { _data = _value.ToString(); } System.Web.UI.WebControls.SqlDataSource _ds = (System.Web.UI.WebControls.SqlDataSource)_dataSource; bool _flag = false; int _index = 0; while (_index < _ds.SelectParameters.Count && _flag == false) { if (_ds.SelectParameters[_index].Name.Trim().Contains(_parameterName1)) { _flag = true; } _index++; } if (!_flag) { _ds.SelectParameters.Add(_parameterName1, _data); } else { _ds.SelectParameters[_parameterName1].DefaultValue = _data; } } }