public static List<AssignmentClass> GetProductCID(string inCID)
{
List<AssignmentClass> productList = new List<AssignmentClass>();
SqlConnection con = new SqlConnection(GetConnectionString());
string sel = "SELECT aGUID, Course_ID, Assignment_ID, Description "
+ "FROM Assignments "
+ "WHERE Course_ID = @inCID "
+ "ORDER BY Course_ID desc";
SqlCommand cmd = new SqlCommand(sel, con);
cmd.Parameters.AddWithValue("inCID", inCID);
con.Open();
SqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
AssignmentClass product;
while (dr.Read())
{
product = new AssignmentClass();
product.aGUID = dr["aGUID"].ToString();
product.Course_id = dr["Course_ID"].ToString();
product.assignmentNumber = dr["Assignment_ID"].ToString();
product.descripton = dr["Description"].ToString();
productList.Add(product);
}
dr.Close();
return productList;
}
public static int DeleteOrder(AssignmentClass product)
{
SqlConnection con = new SqlConnection(GetConnectionString());
string del = "DELETE FROM Assignments "
+ "WHERE aGUID = @aGUID";
SqlCommand cmd = new SqlCommand(del, con);
cmd.Parameters.AddWithValue("aGUID",product.aGUID);
cmd.Parameters.AddWithValue("Course_ID", product.Course_id);
cmd.Parameters.AddWithValue("Assignment_ID", product.assignmentNumber);
cmd.Parameters.AddWithValue("Description", product.descripton);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
public static int InsertOrder(AssignmentClass product)
{
SqlConnection con = new SqlConnection(GetConnectionString());
string ins = "INSERT INTO Assignments"
+ " (aGUID, Course_ID, Assignment_ID, Description) "
+ " VALUES( @aGUID, @Course_ID, @Assignment_ID, @Description)";
SqlCommand cmd = new SqlCommand(ins, con);
cmd.Parameters.AddWithValue("aGUID", product.aGUID);
cmd.Parameters.AddWithValue("Course_ID", product.Course_id);
cmd.Parameters.AddWithValue("Assignment_ID", product.assignmentNumber);
cmd.Parameters.AddWithValue("Description", product.descripton);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
public static List<AssignmentClass> GetProduct()
{
List<AssignmentClass> productList = new List<AssignmentClass>();
SqlConnection con = new SqlConnection(GetConnectionString());
string sel = "SELECT aGUID, Course_ID, Assignment_ID "
+ "FROM Assignments ORDER BY Course_ID desc";
SqlCommand cmd = new SqlCommand(sel, con);
con.Open();
SqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
AssignmentClass product;
while (dr.Read())
{
product = new AssignmentClass();
product.aGUID= dr["aGUID"].ToString();
product.Course_id = dr["Course_ID"].ToString();
product.assignmentNumber = dr["Assignment_ID"].ToString();
productList.Add(product);
}
dr.Close();
return productList;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
selectedProduct = new AssignmentClass();
this.selectedProduct.Course_id = course_id.ToString();
if (Page.IsValid)
{
CartItemList cart = CartItemList.GetCart();
int locCount = cart.Count;
locCount = locCount + 1;
this.selectedProduct.assignmentNumber = locCount.ToString();
this.selectedProduct.aGUID = Guid.NewGuid().ToString();
this.selectedProduct.Num_Assignment = locCount;
this.selectedProduct.descripton = txtDescription.Text;
CartItem cartItem = new CartItem();
CartItem newCartItem = new CartItem();
int Num_Assignments=0;
int assignment = 1; //will be produced from loop according to Num_Assignments
cart = CartItemList.GetCart();
cartItem = cart[selectedProduct.Course_id];
newCartItem = cart[selectedProduct.Course_id];
if (cartItem == null)
{
cart.AddItem(selectedProduct, Num_Assignments,assignment);
newCart.AddItem(selectedProduct, Num_Assignments, assignment);
}
else
{
cart.AddItem(selectedProduct, Num_Assignments, assignment);
newCart.AddItem(selectedProduct, Num_Assignments, assignment);
cartItem.AddQuantity(1);
newCartItem.AddQuantity(1);
}
this.DisplayCart();
// this.DisplayNewCart();
}
}
public static List<AssignmentClass> GetCourses()
{
List<AssignmentClass> productList = new List<AssignmentClass>();
SqlConnection con = new SqlConnection(GetConnectionString());
string sel = "SELECT Course_ID, Course_Name, Course_Description, Course_EnrollmentKey, Course_Owner "
+ "FROM Courses ORDER BY Course_ID desc";
SqlCommand cmd = new SqlCommand(sel, con);
con.Open();
SqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
AssignmentClass productClass;
while (dr.Read())
{
productClass = new AssignmentClass();
productClass.aGUID = dr["aGUID"].ToString();
productClass.Course_id = dr["Course_id"].ToString();
productClass.assignmentNumber = dr["assignmentNumber"].ToString();
productClass.Num_Assignment = Convert.ToInt32(dr["Num_Assignment"]);
productList.Add(productClass);
}
dr.Close();
return productList;
}
public static int UpdateOrder(AssignmentClass original_Product, AssignmentClass product)
{
SqlConnection con = new SqlConnection(GetConnectionString());
string up = "UPDATE Assignments "
+ "SET aGUID = @, "
+ "WHERE aGUID = @original_aGUID ";
SqlCommand cmd = new SqlCommand(up, con);
cmd.Parameters.AddWithValue("aGUID", product.aGUID);
cmd.Parameters.AddWithValue("Course_ID", product.Course_id);
cmd.Parameters.AddWithValue("Assignment_ID", product.assignmentNumber);
cmd.Parameters.AddWithValue("Description", product.descripton);
cmd.Parameters.AddWithValue("origional_aGUID", original_Product.aGUID);
cmd.Parameters.AddWithValue("original_Course_ID", original_Product.Course_id);
cmd.Parameters.AddWithValue("original_Assignment_ID", original_Product.assignmentNumber);
cmd.Parameters.AddWithValue("original_Description", original_Product.descripton);
con.Open();
int updateCount = cmd.ExecuteNonQuery();
con.Close();
return updateCount;
}
private async Task AssignmentDefaults()
{
using (var uow = new UnitOfWork(Tsdl))
{
if (!uow.Query <AssignmentType>().Any(x => x.TypeName == UNK))
{
var at = new AssignmentType(uow)
{
TypeName = UNK, TypeDescription = UNK
};
uow.CommitChanges();
}
}
using (var odw = new OracleDatabaseWorker(tbOracleConnectionStringText))
{
//just good olfd status for now
List <string> statuses = odw.GetDistinctDataColumn(assignmentPrimlocTable, "STATUS");
List <string> Classes = odw.GetDistinctDataColumn(assignmentPrimlocTable, "ASSIGNMENTCLASS");
statuses.Add(GlobalSystemSettings.AssignmentStatusActive);
//class
var del = new MyDelegate((lst) =>
{
using (var uow = new UnitOfWork(Tsdl))
{
foreach (var str in lst.Where(s =>
s != "" && !uow.Query <AssignmentStatus>().Select(x => x.StatusName).Contains(s)))
{
AssignmentStatus cs = new AssignmentStatus(uow)
{
StatusName = str
};
uow.CommitChanges();
}
}
return(true);
});
IAsyncResult sres = del.BeginInvoke(statuses, null, null);
del = new MyDelegate((lst) =>
{
using (var uow = new UnitOfWork(Tsdl))
{
foreach (var str in lst.Where(s =>
s != "" && !uow.Query <AssignmentClass>().Select(x => x.Class).Contains(s)))
{
AssignmentClass cs = new AssignmentClass(uow)
{
Class = str
};
uow.CommitChanges();
}
}
return(true);
});
IAsyncResult cres = del.BeginInvoke(Classes, null, null);
await Task.FromResult(sres);
await Task.FromResult(cres);
}
}
public void AddItem(AssignmentClass product, int quantity,int tSide)
{
CartItem c = new CartItem(product, quantity);
cartItems.Add(c);
}
public CartItem(AssignmentClass product, int quantity)
{
this.Product = product;
this.Quantity = quantity;
}
