public List <ArrayList> getBillList(Bill billRef1)
{
string qry = "";
// List<Items> itemsList = new List<Items>();
ArrayList itemsList = new ArrayList();
DataBaseconnection DbCon = new DataBaseconnection();
{ }
if (billRef1 == null)
{
qry = "select * from dbo.order_orderBill";
Console.WriteLine("inside if ");
}
else
{
Console.WriteLine("!!!!!!!!!!!!!!!! outside if ");
if (billRef1.orderId != 0)
{
qry = "select * from dbo.order_orderBill where orderId= '" + billRef1.orderId + "';";
Console.WriteLine("order iD !!!!!!!");
}
Console.WriteLine("!!!!!!!!!!!!!!!! outside else :{0} ", billRef1.billNoRef.billNo);
if (billRef1.billNoRef.billNo >= 0)
{
Console.WriteLine("!!!!!!!!!!!!!!!! insidceeeeeeeeee else ");
qry = "select * from dbo.order_orderBill where billNo= '" + billRef1.billNoRef.billNo + "';";
Console.WriteLine("!!!!!!!!!!!!!!!! inside else ");
Console.WriteLine("inside else \n bill No.={0} ", billRef1.billNoRef.billNo);
}
}
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
Bill billRef = new Bill();
Category categoryRef = new Category();
// List<List<string>> itemm = new List<List<string>>();
List <ArrayList> bills = new List <ArrayList>();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n\n select * values \n\n");
// itemm.Add(billRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3),Convert.ToString(reader.GetInt16(4)),Convert.ToString(reader.GetFloat(5))));
// ArrayList arr = billRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt16(4), reader.GetFloat(5));
// Console.WriteLine("******item name:{0}\t item Category:{1}\t item desc:{2} \t item type:{3}\t item stock:{4}\t item unit price:{5}", reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetDouble(5));
bills.Add(billRef.BillList(reader.GetInt32(0), reader.GetInt32(1), reader.GetString(2), reader.GetInt32(3), reader.GetDouble(4)));
}
}
else
{
Console.WriteLine("No rows found.");
}
return(bills);
}
public List <Items> getItemsList(Items ItemsRef1)
{
string qry = "";
List <Items> itemsList = new List <Items>();
DataBaseconnection DbCon = new DataBaseconnection();
if (ItemsRef1 == null)
{
qry = "select * from dbo.order_item";
Console.WriteLine("inside if ");
}
else
{
qry = "select * from dbo.order_item where itemName= '" + ItemsRef1.itemName + "';";
Console.WriteLine("inside else ");
}
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
Items ItemsRef = new Items();
Category categoryRef = new Category();
List <string> itemm = new List <string>();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n\n select * values \n\n");
// itemm=ItemsRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
//ItemsRef.itemName = reader.GetString(0);
//categoryRef.categoryName = reader.GetString(1);
//string catName = reader.GetString(1);
//ItemsRef.category.categoryName = catName;
//ItemsRef.description= reader.GetString(2);
//ItemsRef.itemType= reader.GetString(3);
//Console.WriteLine("@@@@@@@@@\nItem name:{0} \n Item category:{1}\n description:{2}\n Item Name:{3}\n", ItemsRef.itemName, categoryRef.categoryName, ItemsRef.description, ItemsRef.itemName);
//// Items categoryAdd = new Items(ItemsRef.itemName,categoryRef, ItemsRef.description, ItemsRef.itemName);
//itemsList.Add(ItemsRef);
//Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
// reader.GetString(1));
}
}
else
{
Console.WriteLine("No rows found.");
}
foreach (Items ItemsRef2 in itemsList)
{
Console.WriteLine("$$$$$$$$$$$$$$$$$\nItem name:{0} \n Item category:{1}\n description:{2}\n Item Name:{3}\n", ItemsRef2.itemName, ItemsRef2.category, ItemsRef2.description, ItemsRef2.itemName);
}
return(itemsList);
}
public List <ArrayList> getItemsListSample(Items ItemsRef1)
{
string qry = "";
// List<Items> itemsList = new List<Items>();
ArrayList itemsList = new ArrayList();
DataBaseconnection DbCon = new DataBaseconnection();
if (ItemsRef1 == null)
{
qry = "select * from dbo.order_item";
Console.WriteLine("inside if ");
}
else
{
Console.WriteLine("!!!!!!!!!!!!!!!! outside if ");
if (ItemsRef1.itemName != null)
{
qry = "select * from dbo.order_item where itemName= '" + ItemsRef1.itemName + "';";
Console.WriteLine("item name!!!!!!!");
}
Console.WriteLine("!!!!!!!!!!!!!!!! outside else ");
if (ItemsRef1.category.categoryName != null)
{
Console.WriteLine("!!!!!!!!!!!!!!!! insidceeeeeeeeee else ");
qry = "select * from dbo.order_item where category= '" + ItemsRef1.category.categoryName + "';";
Console.WriteLine("!!!!!!!!!!!!!!!! inside else ");
Console.WriteLine("inside else\n category name={0} ", ItemsRef1.category.categoryName);
}
}
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
Items ItemsRef = new Items();
Category categoryRef = new Category();
// List<List<string>> itemm = new List<List<string>>();
List <ArrayList> itemm = new List <ArrayList>();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n\n select * values \n\n");
// itemm.Add(ItemsRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3),Convert.ToString(reader.GetInt16(4)),Convert.ToString(reader.GetFloat(5))));
// ArrayList arr = ItemsRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt16(4), reader.GetFloat(5));
Console.WriteLine("******item name:{0}\t item Category:{1}\t item desc:{2} \t item type:{3}\t item stock:{4}\t item unit price:{5}", reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetDouble(5));
itemm.Add(ItemsRef.BillList(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), 1, reader.GetDouble(5)));
}
}
else
{
Console.WriteLine("No rows found.");
}
return(itemm);
}
public List <ArrayList> getUsrList(UserMaster usermasterRef)
{
UserMaster usrmasterRef = new UserMaster();
List <ArrayList> listOfUsers = new List <ArrayList>();
DataBaseconnection DbCon = new DataBaseconnection();
List <ArrayList> usrList = new List <ArrayList>();
SqlConnection cnn = DbCon.ObtainConnection();
UserMaster usrMasterRef = new UserMaster();
string qry = null;
if (usermasterRef == null)
{
qry = "select * from dbo.order_user";
}
else
{
if (usermasterRef.username != "")
{
Console.WriteLine("\n ^^^^^^^^^^^^inside if User name\n");
Console.WriteLine("user Name:{0}\n", usermasterRef.username);
qry = "select * from dbo.order_user where name='" + usermasterRef.username + "'";
}
if (usermasterRef.designationRef.roleName != null)
{
Console.WriteLine("inside else if \nRole Name:{0}", usermasterRef.designationRef.roleName);
qry = "select * from dbo.order_user where designation='" + usermasterRef.designationRef.roleName + "'";
}
}
Console.WriteLine("\n ^^^^^^^^^^^^outside if User name\n");
// Console.WriteLine("user Name:{0}\n", usermasterRef.username);
// Console.WriteLine("outside else if \nRole Name:{0}", usermasterRef.designationRef.roleName);
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("");
// (0 int id,1 string usename, 2 string mobileNo,3 string address, 4 string g, 5 string mailid, 6 DateTime d,7 string pwd,8 string RoleMaster)
Console.WriteLine("Role name={0}", reader.GetString(8));
usrList.Add(usrmasterRef.getUserList(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetDateTime(6), reader.GetString(7), reader.GetString(8)));
Console.WriteLine("USER ID:{0}\n ID:{1}\n mobile no:{2}\n address:{3}\n gender:{4}\n mailid:{5}\tdob:{6}\npwd:{7}\nrole:[8]", reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetDateTime(6), reader.GetString(7), reader.GetString(8));
}
}
else
{
Console.WriteLine("No row found!!\n");
}
return(usrList);
}
private int generateOrderId()
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "select count(billNo) from dbo.order_orderCredentials;";
SqlConnection cnn = DbCon.ObtainConnection();
SqlCommand cmd = new SqlCommand(qry, cnn);
int i = Convert.ToInt32(cmd.ExecuteScalar());
cnn.Close();
return(i++);
}
public UserMaster findbyprimaryKey(int userId)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "select * from dbo.order_user where userid= '" + userId + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
// da.InsertCommand = new SqlCommand(qry, cnn);
// da.InsertCommand.ExecuteReader();
SqlDataReader reader = cmd.ExecuteReader();
UserMaster userMasterref = new UserMaster();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n inserted values \n");
Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
reader.GetString(1));
userMasterref.userid = reader.GetInt32(0);
userMasterref.username = reader.GetString(1);
userMasterref.mobileNo = reader.GetString(2);
userMasterref.address = reader.GetString(3);
userMasterref.gender = reader.GetString(4);
userMasterref.emailId = reader.GetString(5);
userMasterref.dob = reader.GetDateTime(6);
userMasterref.pwd = reader.GetString(7);
RoleMaster roleMasterRef = new RoleMaster();
roleMasterRef.roleName = reader.GetString(8);
userMasterref.designationRef = roleMasterRef;
}
}
else
{
Console.WriteLine("No rows found.");
}
reader.Close();
// MessageBox.Show("display successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
return(userMasterref);
}
public void deleteItems(Items ItemsRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "delete from dbo.order_item where itemName= '" + ItemsRef.itemName + "';";
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("delete successfull !!");
cnn.Dispose();
cnn.Close();
}
public UserMaster login(UserMaster usermasterRef)
{
Console.WriteLine("\n\n\n inside login()\n\n\n\n\n\n");
DataBaseconnection DbCon = new DataBaseconnection();
//string qry = "select * from dbo.order_user where mobileNo= '" + usermasterRef.mobileNo + "';";
string qry = "select * from dbo.order_user where mobileNo= '" + usermasterRef.mobileNo + "' and pwd='" + usermasterRef.pwd + "'";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
// da.InsertCommand = new SqlCommand(qry, cnn);
// da.InsertCommand.ExecuteReader();
SqlDataReader reader = cmd.ExecuteReader();
UserMaster userMasterref = new UserMaster();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n inserted values \n");
//Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
// reader.GetString(1));
Console.WriteLine("\n inserted values \n");
//Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
// reader.GetString(1));
userMasterref.userid = reader.GetInt32(0);
userMasterref.username = reader.GetString(1);
userMasterref.mobileNo = reader.GetString(2);
userMasterref.address = reader.GetString(3);
userMasterref.gender = reader.GetString(4);
userMasterref.emailId = reader.GetString(5);
// userMasterref.dob = reader.GetDateTime(6);
userMasterref.pwd = reader.GetString(7);
RoleMaster roleMasterRef = new RoleMaster();
roleMasterRef.roleName = reader.GetString(8);
Console.WriteLine("\n\n++++++++++\nRole Name:{0}", roleMasterRef.roleName);
userMasterref.designationRef = roleMasterRef;
// SqlConnection cnn = DbCon.ObtainConnection();
// SqlCommand cmd = new SqlCommand(qry, cnn);
//SqlDataReader reader = cmd.ExecuteReader();
//if (reader.HasRows)
// return 1;
//else return 0;
}
}
cnn.Dispose();
cnn.Close();
return(userMasterref);
}
//public Category findbyprimaryKey(string categoryName)
//{
// DataBaseconnection DbCon = new DataBaseconnection();
// string qry = "select * from dbo.order_category where name= '" + categoryName + "';";
// SqlConnection cnn = DbCon.ObtainConnection();
// // MessageBox.Show("Connectiom established !!");
// SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
// // da.InsertCommand = new SqlCommand(qry, cnn);
// // da.InsertCommand.ExecuteReader();
// SqlDataReader reader = cmd.ExecuteReader();
// Category CategoryRef = new Category();
// if (reader.HasRows)
// {
// while (reader.Read())
// {
// Console.WriteLine("\n inserted values \n");
// Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
// reader.GetString(1));
// CategoryRef.categoryName = reader.GetString(0);
// CategoryRef.categoryDesc = reader.GetString(1);
// }
// }
// else
// {
// Console.WriteLine("No rows found.");
// }
// Console.WriteLine("{0}\t{1}\n", CategoryRef.categoryName,
// CategoryRef.categoryDesc);
// reader.Close();
// // MessageBox.Show("display successfull !!");
// cnn.Dispose();
// cnn.Close();
// // MessageBox.Show("Connectiom closed !!");
// return CategoryRef;
//}
public List <Category> getcategoryList(Category CategoryRef1)
{
string qry = "";
List <Category> categorylist = new List <Category>();
DataBaseconnection DbCon = new DataBaseconnection();
if (CategoryRef1 == null)
{
qry = "select * from dbo.order_category";
Console.WriteLine("inside if ");
}
else
{
qry = "select * from dbo.order_category where name= '" + CategoryRef1.categoryName + "';";
Console.WriteLine("inside else ");
}
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
Category CategoryRef = new Category();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n\n select * values \n\n");
CategoryRef.categoryName = reader.GetString(0);
CategoryRef.categoryDesc = reader.GetString(1);
Category categoryAdd = new Category(CategoryRef.categoryName, CategoryRef.categoryDesc);
categorylist.Add(categoryAdd);
Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
reader.GetString(1));
}
}
else
{
Console.WriteLine("No rows found.");
}
foreach (Category catgry in categorylist)
{
Console.WriteLine("category name:{0} \n category value:{1}", catgry.categoryName, catgry.categoryDesc);
}
reader.Close();
return(categorylist);
}
public List <ArrayList> getorderCredentialsList(OrderCredentials orderCredentialsRef1)
{
string qry = "";
// List<Items> itemsList = new List<Items>();
ArrayList itemsList = new ArrayList();
DataBaseconnection DbCon = new DataBaseconnection();
if (orderCredentialsRef1 == null)
{
qry = "select * from dbo.order_orderCredentials";
Console.WriteLine("inside if ");
}
else
{
Console.WriteLine("!!!!!!!!!!!!!!!! outside if ");
if (orderCredentialsRef1.billNo != 0)
{
qry = "select * from dbo.order_orderCredentials where billNo= '" + orderCredentialsRef1.billNo + "';";
Console.WriteLine("item name!!!!!!!");
}
}
SqlConnection cnn = DbCon.ObtainConnection();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
OrderCredentials orderCredentialsRef = new OrderCredentials();
List <ArrayList> orderCredList = new List <ArrayList>();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n\n select * values \n\n");
// itemm.Add(orderCredentialsRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3),Convert.ToString(reader.GetInt16(4)),Convert.ToString(reader.GetFloat(5))));
// ArrayList arr = orderCredentialsRef.Itemss(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt16(4), reader.GetFloat(5));
Console.WriteLine("******item name:{0}\t item Category:{1}\t item desc:{2} \t item type:{3}\t item stock:{4}\t item unit price:{5}", reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetInt32(4), reader.GetDouble(5));
orderCredList.Add(orderCredentialsRef.OrderCredentialsList(reader.GetInt32(0), reader.GetDateTime(1)));
}
}
else
{
Console.WriteLine("No rows found.");
}
return(orderCredList);
}
public void inseritems(Items ItemsRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "insert into dbo.order_item(itemName,category,Description,itemType,stock,unitPrice) values('" + ItemsRef.itemName + "','" + ItemsRef.category.categoryName + "','" + ItemsRef.description + "','" + ItemsRef.itemType + "','" + ItemsRef.stock + "','" + ItemsRef.unitprice + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("insert successfull !!");
cnn.Dispose();
cnn.Close();
}
public void insertOrderCredentials(OrderCredentials orderCredentialsRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "insert into dbo.order_orderCredentials(billNo,OrderDate) values('" + orderCredentialsRef.billNo + "','" + orderCredentialsRef.orderDate + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("insert successfull to Order Credentails !!");
cnn.Dispose();
cnn.Close();
}
public void insertBill(Bill billRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "insert into dbo.order_orderBill(orderId,billNo,selectedItemName,quantity,price) values('" + billRef.orderId + "','" + billRef.billNoRef.billNo + "','" + billRef.selectedItemName + "','" + billRef.quantity + "','" + billRef.price + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
// MessageBox.Show("insert successfull to Bill table !!");
cnn.Dispose();
cnn.Close();
}
public void deleteBill(Bill billRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "delete from dbo.order_orderBill where billNo= '" + billRef.billNoRef.billNo + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("delete successfull in bill table !!");
cnn.Dispose();
cnn.Close();
}
public void updaterole(RoleMaster roleMasterRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "update dbo.order_role set roleDesc = '" + roleMasterRef.roleDesc + "' where rolename= '" + roleMasterRef.roleName + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("update successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public void deleteCategory(Category CategoryRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "delete from dbo.order_category where name= '" + CategoryRef.categoryName + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("delete successfull !!");
cnn.Dispose();
cnn.Close();
//MessageBox.Show("Connectiom closed !!");
}
public void insertCatelog(Category CategoryRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "insert into dbo.order_category(name,Categorydesc) values('" + CategoryRef.categoryName + "','" + CategoryRef.categoryDesc + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("insert successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public void deleteUser(UserMaster userMasterRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "delete from dbo.order_user where userid= '" + userMasterRef.userid + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("delete successfull !!");
cnn.Dispose();
cnn.Close();
//MessageBox.Show("Connectiom closed !!");
}
public void updateUser(UserMaster userMasterRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "update dbo.order_user set name = '" + userMasterRef.username + "', mobileNo= '" + userMasterRef.mobileNo + "', address= '" + userMasterRef.address + "', gender= '" + userMasterRef.gender + "', emailid= '" + userMasterRef.emailId + "', dob= '" + userMasterRef.dob + "', pwd= '" + userMasterRef.pwd + "' where userid= '" + userMasterRef.userid + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("update successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public void insertRole(RoleMaster roleMasterRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "insert into dbo.order_role(rolename,roleDesc) values('" + roleMasterRef.roleName + "','" + roleMasterRef.roleDesc + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("insert successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public void insertUser(UserMaster userMasterRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
// string qry = "insert into dbo.order_user(userid,name,mobileNo,address,gender,emailid,dob,pwd,designation) values('" + userMasterRef.userid + "','" + userMasterRef.username + "','" + userMasterRef.mobileNo + "','" + userMasterRef.address + "','" + userMasterRef.gender + "','" + userMasterRef.emailId + "','" + userMasterRef.dob + "','" + userMasterRef.pwd + "','" + userMasterRef.designationRef.roleName + "')";
string qry = "insert into dbo.order_user(name,mobileNo,address,gender,emailid,dob,pwd,designation) values('" + userMasterRef.username + "','" + userMasterRef.mobileNo + "','" + userMasterRef.address + "','" + userMasterRef.gender + "','" + userMasterRef.emailId + "','" + userMasterRef.dob + "','" + userMasterRef.pwd + "','" + userMasterRef.designationRef.roleName + "')";
SqlConnection cnn = DbCon.ObtainConnection();
//MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("User Added !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public void updateBill(Bill billRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
//if(billRef.description!=null)
// string qry = "update dbo.order_item set Description= '" +billRef.description+ "',itemType= '" + billRef.itemType + "' where itemName= '" + billRef.itemName+ "';";
string qry = "update dbo.order_orderBill set selectedItemName= '" + billRef.selectedItemName + "',quantity= '" + billRef.quantity + "' ,price= '" + billRef.price + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("update successfull !!");
cnn.Dispose();
cnn.Close();
}
public void updateorderCredentials(OrderCredentials orderCredentialsRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
//if(orderCredentialsRef.description!=null)
// string qry = "update dbo.order_item set Description= '" +orderCredentialsRef.description+ "',itemType= '" + orderCredentialsRef.itemType + "' where itemName= '" + orderCredentialsRef.itemName+ "';";
string qry = "update dbo.order_orderCredentials set Description= '" + orderCredentialsRef.orderDate + "' where itemName= '" + orderCredentialsRef.billNo + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("update successfull !!");
cnn.Dispose();
cnn.Close();
}
public RoleMaster findbyprimaryKey(string roleName)
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "select * from dbo.order_role where rolename= '" + roleName + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
// da.InsertCommand = new SqlCommand(qry, cnn);
// da.InsertCommand.ExecuteReader();
SqlDataReader reader = cmd.ExecuteReader();
RoleMaster roleMasterref = new RoleMaster();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n inserted values \n");
Console.WriteLine("{0}\t{1}\n", reader.GetString(0),
reader.GetString(1));
roleMasterref.roleName = reader.GetString(0);
roleMasterref.roleDesc = reader.GetString(1);
}
}
else
{
Console.WriteLine("No rows found.");
}
Console.WriteLine("{0}\t{1}\n", roleMasterref.roleName,
roleMasterref.roleDesc);
reader.Close();
// MessageBox.Show("display successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
return(roleMasterref);
}
public void updateItems(Items ItemsRef)
{
DataBaseconnection DbCon = new DataBaseconnection();
//if(ItemsRef.description!=null)
// string qry = "update dbo.order_item set Description= '" +ItemsRef.description+ "',itemType= '" + ItemsRef.itemType + "' where itemName= '" + ItemsRef.itemName+ "';";
string qry = "update dbo.order_item set Description= '" + ItemsRef.description + "',itemType= '" + ItemsRef.itemType + "' ,stock= '" + ItemsRef.stock + "' ,unitPrice= '" + ItemsRef.unitprice + "' where itemName= '" + ItemsRef.itemName + "';";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
// SqlCommand cmd = new SqlCommand(qry, cnn);
da.InsertCommand = new SqlCommand(qry, cnn);
da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("update successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
}
public List <string> getRoleName()
{
DataBaseconnection DbCon = new DataBaseconnection();
string qry = "select * from dbo.order_role";
SqlConnection cnn = DbCon.ObtainConnection();
// MessageBox.Show("Connectiom established !!");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, cnn);
SqlDataReader reader = cmd.ExecuteReader();
RoleMaster roleRef = new RoleMaster();
List <string> roleNames = new List <string>();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine("\n inserted values \n");
Console.WriteLine("{0}\t\n", reader.GetString(0));
roleNames.Add(reader.GetString(0));
}
}
else
{
Console.WriteLine("couldn't display");
}
reader.Close();
// MessageBox.Show("display successfull !!");
cnn.Dispose();
cnn.Close();
// MessageBox.Show("Connectiom closed !!");
return(roleNames);
}
