private void BindGridView(string fileName, string filterOption) { var dbContext = new AFDDataContext(); var where = new StringBuilder(); var parms = new List <SqlParameter>(); if (!fileName.Equals("All", StringComparison.CurrentCultureIgnoreCase)) { where.Append("[file] = @file"); parms.Add(new SqlParameter("@file", fileName)); } if (filterOption.Equals("errorsonly", StringComparison.CurrentCultureIgnoreCase)) { if (where.Length != 0) { where.Append(" And "); } where.Append("checkResult > 1"); } if (where.Length != 0) { where.Insert(0, "Where "); } this.GridView1.DataSource = dbContext.Customers.SqlQuery("Select * From CustomerDatas " + where.ToString(), parms.ToArray()).ToList(); this.GridView1.DataBind(); }
public static void SaveItemsToDb(List <CustomerData> items) { var dbContext = new AFDDataContext(); foreach (var item in items) { dbContext.Customers.Add(item); } dbContext.SaveChanges(); }
public static void TransferFinished(Dictionary <CustomerData, EvilReturn> results, Guid requestId) { var dbContext = new AFDDataContext(); var failedItems = new Dictionary <CustomerData, EvilReturn>(); var builder = new StringBuilder(); int goodCount = 0; foreach (var result in results) { var parms = new SqlParameter[] { new SqlParameter("@status", System.Data.SqlDbType.TinyInt), new SqlParameter("@hash", System.Data.SqlDbType.NVarChar), new SqlParameter("@checkResult", System.Data.SqlDbType.TinyInt), new SqlParameter("@checkerror", System.Data.SqlDbType.NVarChar), new SqlParameter("@id", System.Data.SqlDbType.UniqueIdentifier) }; if (result.Value.added.Equals("true", StringComparison.CurrentCultureIgnoreCase)) { goodCount++; //result.Key.hash = result.Value.hash; //result.Key.uploadstatus = 0; parms[0].Value = 3; parms[1].Value = result.Value.hash; parms[2].Value = result.Key.checkResult; parms[3].SqlValue = ((result.Key.checkerror == null) ? DBNull.Value : (object)result.Key.checkerror); parms[4].Value = result.Key.id; dbContext.Database.ExecuteSqlCommand( "Update CustomerDatas " + "Set uploadstatus = @status, hash = @hash, checkResult = @checkResult, checkerror = @checkerror " + "Where id = @id", parms.ToArray()); } else { //result.Key.hash = null; //result.Key.uploadstatus = 2; // failed parms[0].Value = 2; parms[1].Value = ""; parms[2].Value = result.Key.checkResult; parms[3].SqlValue = result.Key.checkerror; parms[4].Value = result.Key.id; dbContext.Database.ExecuteSqlCommand( "Update CustomerDatas " + "Set uploadstatus = @status, hash = @hash, checkResult = @checkResult, checkerror = @checkerror " + "Where id = @id", parms); failedItems.Add(result.Key, result.Value); } //dbContext.Customers.Add(result.Key); } //dbContext.SaveChanges(); builder.Append(string.Format("{0} orders successfully updated<br/>", goodCount)); if (failedItems.Count != 0) { foreach (var item in failedItems) { builder.Append(string.Format("Customer {0} was not updated. Error {1}<br/>", item.Key.customer, ((item.Value.errors.Length != 0) ? item.Value.errors[0] : ""))); } } ThreadResult.Add(requestId.ToString(), builder.ToString()); // you can add your result in second parameter. }