public bool AddMStockItemsReceipe(MStockItemsReceipe mstockitemsreceipe)
        {
            SqlCommand cmd;

            cmd             = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "AddMStockItemsReceipe";

            cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsreceipe.PkSrNo);

            //   cmd.Parameters.AddWithValue("@IngredientNo", mstockitemsreceipe.IngredientNo);

            cmd.Parameters.AddWithValue("@ReceipeDesc", mstockitemsreceipe.ReceipeDesc);

            cmd.Parameters.AddWithValue("@LangReceipeDesc", mstockitemsreceipe.LangReceipeDesc);

            cmd.Parameters.AddWithValue("@SequenceNo", mstockitemsreceipe.SequenceNo);

            cmd.Parameters.AddWithValue("@UserID", mstockitemsreceipe.UserID);

            cmd.Parameters.AddWithValue("@UserDate", mstockitemsreceipe.UserDate);

            cmd.Parameters.AddWithValue("@CompanyNo", mstockitemsreceipe.CompanyNo);

            commandcollection.Add(cmd);
            return(true);
        }
        public bool DeleteMStockItemsReceipe(MStockItemsReceipe mstockitemsreceipe)
        {
            SqlCommand cmd;

            cmd             = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "DeleteMStockItemsReceipe";

            cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsreceipe.PkSrNo);

            commandcollection.Add(cmd);
            return(true);
        }