public List <Stationary> ViewSelectedStationary(int typeId)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT *FROM t_Stationary WHERE TypeId=" + typeId;
//string query = "select t_Stationary.Name,t_Stationary.Price,t_Stationary.Purpose,Sum(t_Stationary.Price) As Total_Price from t_Stationary join t_stationarType on t_Stationary.TypeId=t_stationarType.Id WHERE t_Stationary.TypeId=" +typeId + " Group By t_Stationary.Name,t_Stationary.Price,t_Stationary.Purpose";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <Stationary> stationaries = new List <Stationary>();
while (reader.Read())
{
Stationary stationary = new Stationary()
{
Name = reader["Name"].ToString(),
Price = Convert.ToDecimal(reader["Price"].ToString()),
Purpose = reader["Purpose"].ToString(),
};
stationaries.Add(stationary);
}
reader.Close();
connection.Close();
return(stationaries);
}
public ActionResult Create([Bind(Include = "Stationary_ID,Category,Name,Image,ForSubject,Description,Price")] Stationary stationery)
{
LoadSubjects();
if (ModelState.IsValid)
{
if (stationery.Image == null || stationery.Image == "")
{
stationery.Image = "/Content/Default.jpg";
}
if (stationery.Description == null || stationery.Description == "")
{
stationery.Description = "No Description";
}
stationery.Favorite = false;
db.Stationaries.Add(stationery);
db.SaveChanges();
Variant vari = new Variant();
vari.Stocked = false;
vari.Colour = "Default";
vari.Status = "New";
vari.Stationary_ID = stationery.Stationary_ID;
vari.Amount = 1;
db.Variants.Add(vari);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Edit(int?id)
{
Stationary stationery = db.Stationaries.Find(id);
stationery.Variants = stationery.Variants.OrderBy(x => x.Colour).ToList();
return(View(stationery));
}
public static Stationary iteminfo(String ItemID)
{
Stationary stationery = new Stationary();
using (SqlConnection C = new SqlConnection(DataLink.connectionString))
{
C.Open();
string query = @"SELECT * from Stationery where ItemID = '" + ItemID + "'";
SqlCommand cmd = new SqlCommand(query, C);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
stationery = new Stationary();
stationery.ItemID = (string)reader["ItemID"];
stationery.CategoryID = (string)reader["CategoryID"];
stationery.ItemName = (string)reader["ItemName"];
stationery.UOM = (string)reader["UOM"];
stationery.ReorderLevel = (int)reader["ReorderLevel"];
stationery.ReorderQuantity = (int)reader["ReorderQuantity"];
stationery.PrioritySupplier1 = (string)reader["PrioritySupplier1"];
stationery.PrioritySupplier2 = (string)reader["PrioritySupplier2"];
stationery.PrioritySupplier3 = (string)reader["PrioritySupplier3"];
}
return(stationery); //pass to calling function (supplier controller)
}
}
public List <Stationary> Stationery_List()
{
List <Stationary> Lt_Stationary = new List <Stationary>();
using (SqlConnection C = new SqlConnection(DataLink.connectionString))
{
C.Open();
string cmdtext = @"SELECT * FROM Stationery";
SqlCommand cmd = new SqlCommand(cmdtext, C);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Stationary St = new Stationary();
St.ItemID = (string)sdr["ItemID"];
St.CategoryID = (string)sdr["CategoryID"];
St.ItemName = (string)sdr["ItemName"];
St.UOM = (string)sdr["UOM"];
Lt_Stationary.Add(St);
}
return(Lt_Stationary);
}
}
public void SetItemCoordinates(Coordinate coordinate, Stationary stationary)
{
if (ItemCoordinates.GetValueOrDefault(coordinate.ToString(), null) != null)
{
return;
}
ItemCoordinates.Add(coordinate.ToString(), stationary);
}
public ActionResult Add2Cart(Stationary s) //this method triggers when the "ADD" button is pressed for the item.
{
Debug.WriteLine(s.ItemID);
using (SqlConnection conn = new SqlConnection(DataLink.connectionString))
{
conn.Open();
string cmdtext = @"insert into WishList (UserID,ItemID,ItemName,RequiredQuantity,UOM) values ('" + (int)Session["UserID"] + "','" + s.ItemID + "','" + s.ItemName + "','" + s.RequiredQuantity + "','" + s.UOM + "')";
SqlCommand cmd = new SqlCommand(cmdtext, conn);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("ViewCatalogue", "DepartmentRep"));
}
public ActionResult Edit(
[Bind(Include = "Stationary_ID,Category,Name,ForSubject,Image,Description,Price,Variants")]
Stationary stationery)
{
int count = 1;
foreach (Variant vari in stationery.Variants)
{
if (stationery.Variants.Count != count)
{
if (vari.markedfordeletion)
{
count++;
Variant variant = db.Variants.Find(vari.Variant_ID);
db.Variants.Remove(variant);
}
}
}
db.SaveChanges();
if (ModelState.IsValid)
{
foreach (Variant vari in stationery.Variants)
{
if (!vari.markedfordeletion)
{
if (vari.Colour == null || vari.Colour == "")
{
vari.Colour = "Default";
}
if (vari.Status == null || vari.Status == "")
{
vari.Status = "Unspecified";
}
db.Entry(vari).State = EntityState.Modified;
}
}
db.Entry(stationery).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stationery));
}
public ActionResult DeleteConfirmed(int?id)
{
Stationary stationery = db.Stationaries.Find(id);
List <Variant> variants = new List <Variant>();
variants = db.Variants.Where(x => x.Stationary_ID == id).ToList();
foreach (var vari in variants)
{
db.Variants.Remove(vari);
}
db.Stationaries.Remove(stationery);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int SaveStationary(Stationary stationary)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO t_Stationary VALUES('" + stationary.Name + "','" + stationary.Price + "','" + stationary.Purpose + "','" + stationary.TypeId + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int noOfRowsAffected = command.ExecuteNonQuery();
connection.Close();
return(noOfRowsAffected);
}
public ActionResult Display(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Stationary stationery = db.Stationaries.Find(id);
if (stationery == null)
{
return(HttpNotFound());
}
return(View(stationery));
}
public override bool InitMagicalObject(GameObject Weapon, GameObject Direction)
{
CharacterStatus Charstats = Weapon.GetComponentInParent <CharacterStatus>();
CasterName = Charstats.gameObject.name;
if (Charstats.CurrentMana >= Cost)
{
GameObject Blizz = Instantiate(SpellPrefab);
Blizz.transform.position = CastAtPosition;
Stationary stationary = Blizz.GetComponent <Stationary>();
stationary.maxDuration = Cooldown;
stationary.duration = Cooldown;
stationary.OnVictim = Effect;
Charstats.CurMana = -Cost;
return(true);
}
return(false);
}
public static void deleteStationaries(List <StationaryID> jsonParam)
{
//public static void deleteStationaries(Object jsonParam) {
System.Diagnostics.Debug.WriteLine(" count json param ::" + jsonParam.Count);
System.Diagnostics.Debug.WriteLine("1111count stationary List: " + stationaryList.Count);
// System.Diagnostics.Debug.WriteLine(" dont give up::" + st.Id);
ArrayList myStList = stationaryList;
for (int i = 0; i < jsonParam.Count; i++)
{
StationaryID stI = jsonParam[i];
for (int j = 0; j < myStList.Count; j++)
{
Stationary stJ = (Stationary)myStList[j];
if (stJ.Id == stI.Id)
{
System.Diagnostics.Debug.WriteLine("FOUNDDDD::" + stJ.Id + " " + stI.Id);
stationaryList.RemoveAt(0);
}
} //innerloops
} //outerloop
System.Diagnostics.Debug.WriteLine(" 2222 count stationary List: " + stationaryList.Count);
/*
* StationaryID[] stArr = getStationaryIdArray(jsonParam);
* ArrayList myStList = stationaryList;
* for (int i = 0; i<stArr.Length;i++ ) {
* StationaryID stId = stArr[i];
* Console.WriteLine("STID:"+stId.Id);
*
* for (int j=0;j< myStList.Count;j++)
* {
* stationaryList.RemoveAt(j);
* }//inner
*
*
* }//outerList*/
}
public void AddStationery(Stationary s)
{
List <Stationary> cat = new List <Stationary>();
using (SqlConnection connection = new SqlConnection(DataLink.connectionString))
{
connection.Open();
string cmdquery = "Insert into Stationary (ItemID,CategoryID,ItemName,RequiredQuantity,UOM,ReorderLevel,ReorderQuantity,PrioritySupplier1,PrioritySupplier2,PrioritySupplier3)" +
"values('" + s.ItemID + "','" + s.CategoryID + "','" + s.ItemName + "','" + s.RequiredQuantity + "','" + s.UOM + "','" + s.ReorderLevel + "','" + s.ReorderQuantity + "','" + s.PrioritySupplier1 + "','" +
s.PrioritySupplier2 + "','" + s.PrioritySupplier3 + "')";
SqlCommand cmd = new SqlCommand(cmdquery, connection);
//Call Execute reader to get query results
SqlDataReader reader = cmd.ExecuteReader();
//Print out each record
while (reader.Read())
{
Stationary sat = new Stationary();
{
sat.ItemID = (string)reader["ItemID"];
sat.CategoryName = (string)reader["CategoryName"];
sat.ItemName = (string)reader["ItemName"];
sat.UOM = (string)reader["UOM"];
sat.ReorderLevel = (int)reader["ReorderLevel"];
sat.ReorderQuantity = (int)reader["ReorderQuantity"];
sat.PrioritySupplier1 = (string)reader["PrioritySupplier1"];
sat.PrioritySupplier2 = (string)reader["PrioritySupplier2"];
sat.PrioritySupplier3 = (string)reader["PrioritySupplier3"];
}
cat.Add(s);
}
}
}
public ActionResult ViewSupplier(Stationary s)
{
Stationary st = DataSuppliers.iteminfo(s.ItemID);
List <Suppliers> SupplierList = new List <Suppliers>();
Suppliers s1 = DataSuppliers.supplierDetails(st.PrioritySupplier1);
SupplierList.Add(s1);
Suppliers s2 = DataSuppliers.supplierDetails(st.PrioritySupplier2);
SupplierList.Add(s2);
Suppliers s3 = DataSuppliers.supplierDetails(st.PrioritySupplier3);
SupplierList.Add(s3);
ViewBag.supplierInfo = SupplierList;
return(View());
}
public List <Stationary> DisbursementDetails(int ID)
{
List <Stationary> DisbursementDetailsList = new List <Stationary>();
using (SqlConnection C = new SqlConnection(DataLink.connectionString))
{
C.Open();
string cmdtext = @"select s.ItemName, s.UOM ,d.DisbursementID,d.ActualQty,d.DeliveredQty from DisbursementDetails d INNER JOIN Stationery s ON d.ItemID = s.ItemID where d.DisbursementID='" + ID + "'";
SqlCommand cmd = new SqlCommand(cmdtext, C);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Stationary details = new Stationary();
details.ItemName = sdr[0] != DBNull.Value ? (string)sdr[0] : "";
details.UOM = sdr[1] != DBNull.Value ? (string)sdr[1] : "";
details.RequiredQuantity = sdr[3] != DBNull.Value ? (int)sdr[3] : 0;
details.ReorderQuantity = sdr[4] != DBNull.Value ? (int)sdr[4] : 0;
DisbursementDetailsList.Add(details);
/* DisbursmentDetails.ItemName = (string)sdr["ItemName"];
* DisbursmentDetails.UOM = (string)sdr["UOM"];
* DisbursmentDetails.RequiredQuantity = (int)sdr["ActualQty"];
* DisbursmentDetails.ReorderQuantity = (int)sdr["DeliveredQty"];
* DisbursementDetails.Add(DisbursmentDetails);*/
/*
* dept.DepartmentID = reader[0] != DBNull.Value ? (String)reader[0] : throw new Exception("No department found");
* dept.Departmentname = reader[1] != DBNull.Value ? (String)reader[1] : "";
* dept.DepartmentHead = reader[2] != DBNull.Value ? (String)reader[2] : "";
* dept.CollectionPoint = reader[3] != DBNull.Value ? (String)reader[3] : "";
* dept.ContactName = reader[4] != DBNull.Value ? (String)reader[4] : "";
* dept.ContactNumber = reader[5] != DBNull.Value ? (String)reader[5] : "";
* dept.FaxNo = reader[6] != DBNull.Value ? (String)reader[*/
}
return(DisbursementDetailsList);
}
}
public void Write(Packet packet)
{
packet.PutBit(NoBirthAnim);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(Move != null);
packet.PutBit(false);
packet.PutBit(Stationary != null);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(HasRotation);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(ThisIsYou);
packet.PutBit(false);
packet.PutBit(false);
packet.PutBit(false);
packet.FlushBits();
packet.Write(0);
if (Move != null)
{
Move.Write(packet);
}
if (Stationary != null)
{
Stationary.Write(packet);
}
if (HasRotation)
{
packet.Write(Rotation);
}
}
public List <Stationary> CatByID()
{
List <Stationary> cat = new List <Stationary>();
using (SqlConnection connection = new SqlConnection(DataLink.connectionString))
{
connection.Open();
string cmdquery = "Select * from Category c,Stationery s where s.CategoryID =c.CategoryID";
SqlCommand cmd = new SqlCommand(cmdquery, connection);
//Call Execute reader to get query results
SqlDataReader reader = cmd.ExecuteReader();
//Print out each record
while (reader.Read())
{
Stationary s = new Stationary();
s.ItemID = (string)reader["ItemID"];
s.CategoryName = (string)reader["CategoryName"];
s.ItemName = (string)reader["ItemName"];
s.UOM = (string)reader["UOM"];
s.ReorderLevel = (int)reader["ReorderLevel"];
s.ReorderQuantity = (int)reader["ReorderQuantity"];
s.PrioritySupplier1 = (string)reader["PrioritySupplier1"];
s.PrioritySupplier2 = (string)reader["PrioritySupplier2"];
s.PrioritySupplier3 = (string)reader["PrioritySupplier3"];
cat.Add(s);
}
return(cat);
}
}
public ActionResult Delete(int?id)
{
Stationary stationery = db.Stationaries.Find(id);
return(View(stationery));
}
public ActionResult SaveStationary(Stationary stationary)
{
ViewBag.stationaryType = LoadAllType();
ViewBag.msz = stationaryManager.SaveStationary(stationary);
return(View());
}
public int SaveStationary(Stationary stationary)
{
return(stationaryGateway.SaveStationary(stationary));
}
